InfluxDBClientError: 400: Couldn't look up columns, when querying a time-series using an aggregate function and where clause

[sherifzain]

InfluxDBClientError: 400: Couldn't look up columns

When querying a time-series using an aggregate function together with a where clause on the time field for time ranges that do not exist in the series.

Example:

I have a time-series named 'x' which contains data of only one month (the last month)
Then I tried to run the following query:
select mean(energy) from x where time < now() - 300d and time > now() - 400d;

And I got the above error.

[pauldix]

Looks like this is the same thing as #1004. Already a PR in and it'll get fixed in the next release.

[sherifzain]

OK, cool.

I reported it since I was not sure it relates to sharding.