I have also tried querying from influxdb.
The moment I add group by:
SELECT *
FROM "Conca"
WHERE
time >= now() - interval '30 days'
AND
("regs" IS NOT NULL)
GROUP BY "ID"
I get the error:
executing query: failed to create Flight record reader: arrow/flight: could not create flight reader: arrow/ipc: could not read schema from stream: arrow/ipc: could not read message schema: rpc error: code = InvalidArgument desc = Error while planning query: Error during planning: Projection references non-aggregate values: Expression Conca.address could not be resolved from available columns: Conca.ID
However if I don’t add the groupby statement and I use the query modifier everything works. But only on the inflkuxdb’s data explorer window…
Could somebody take a look? Because between this issue and the fact that InfluxQL is not working either I’m paying AWS for something unusable