Server returned error: aggregate function required inside the call to elapsed

#1

Hi,

after update my influx from version 1.3.4 to 1.5.4 the query bellow stopped working:

`SELECT mean("elapsed") FROM (
	SELECT elapsed(eventId, 1s) as "elapsed" from "table" WHERE field = 'value' GROUP BY id
)  GROUP BY time(1m) fill(0)`

The error is: Server returned error: aggregate function required inside the call to elapsed

I think is something related to elapsed and group by time() but I can’t figure what,

Somebody already saw this?

#2

Have you tried running just the nested query alone, without the outer query, in order to pinpoint where the error is occurring?

For example, does the following return results?

SELECT elapsed(eventId, 1s) as "elapsed" from "table" WHERE field = 'value' GROUP BY id

#3

Hi, thanks for your reply,

yep, it works, The issue happens when I add the outher query but this is version 1.5.4 everything runs fine on version 1.3.4