ERR: mixing aggregate and non-aggregate queries is not supported

3

Thank you for your reply.
Unfortunately this does not seem to work.

I tried the following:

SELECT sum(value) as value, last(host) as host FROM collectd_db."default".rain where value <>0 GROUP BY time(10m) LIMIT 2

and got:

time                value  host
----                -----  ----
1562994000000000000 0.5588
1562994600000000000 0.5588

I tried to replace last() with several other functions which never resulted in a value for the host.