FIRST/ LAST return "interface is nil, not engine.FirstOrLastAggregatorState"

[nicolai86]

I've a query which looks like this:

SELECT FIRST(a), FIRST(b) FROM my_series WHERE time > now() - 7d GROUP BY c, d, time(24h) fill(0);

In influxdb 0.7.3 this worked just fine, 0.8.0 returns

Internal Error: interface conversion: interface is nil, not engine.FirstOrLastAggregatorState

I'm not quite sure why this stopped working - according to the 0.8 docs the functions should work the same still.

Removing FIRST makes the query execute again, but it returns different results.

[nicolai86]

After looking at the go source I think this use case should already have a test in integration/data_test.go:1320 CountWithAlias because it executes select %s(column0) as some_alias from test_aliasing for every aggregator, including FIRST and LAST.

I've added a test case to the data_test with my specific query and it works without any problems. Guess it must be a initialization problem someplace else.

[Dieterbe]

see also #780 where i found various issues with different aggregation methods

[nicolai86]

Just a heads up: the error still persists in v0.8.1 and current master branch.

[nicolai86]

@jvshahid any update on this? the error persists since v0.8.0 through v0.8.2 as well as on master.

[jvshahid]

Duplicate of #780. @dgnorton is actually taking a stab at it

[pablo-tech]

this error persist as of today for

select FIRST(PRICE), MIN(PRICE), MAX(PRICE), LAST(PRICE) from "SPX-INDEX-TRADED" group BY time(1h) fill(0) where time > '2015-07-01 00:00:00' AND time < '2015-07-08 23:59:59'

at http://calvinklein-fluxcapacitor-1.c.influxdb.com:8083

[beckettsean]

@pablo-tech that server is running version 0.8.2, for which there is no longer ongoing support. As I recommended, try putting the fill(0) at the end of the query, but otherwise the solution is to upgrade to 0.9.