Basic SELECT clauses not working with GROUP BY

1

InfluxDB keeps rejecting GROUP BY queries with various SELECT clauses.

SELECT "path","used_percent"
FROM "disk"
GROUP BY "path";

Error while planning query: Error during planning: Projection references non-aggregate values: Expression disk.used_percent could not be resolved from available columns: disk.path: rpc error: code = InvalidArgument desc = Error while planning query: Error during planning: Projection references non-aggregate values: Expression disk.used_percent could not be resolved from available columns: disk.path

SELECT *
FROM "disk"
GROUP BY "path";

flightsql: rpc error: code = InvalidArgument desc = Error while planning query: Error during planning: Projection references non-aggregate values: Expression disk.used_percent could not be resolved from available columns: disk.path
(Trace ID: fd4375358a696715de10bbe3b41ee7df)

Please ensure that GROUP BY works with SELECT clause table columns other than an exact set match of those chosen for the GROUP BY deduplication clause.

2

MAX() works but not the plain value

3

Hello @aep-sunlife,
The docs specify:

GROUP BY is an optional clause used to group rows that have the same values for all columns and expressions in the list. To output an aggregation for each group, include an aggregate or selector function in the SELECT statement.

Can you please try that?
GROUP BY clause | InfluxDB Cloud Serverless Documentation.

Oh I just saw your second comment. Yah you have to include a selector or aggregate function.