Select SUM with Group By time(XXm) not working

InfluxDB 2
,
1

Hi all,

I have the following query which is aggregating a total of energy data for every record in a 15 minute timeframe. It will not work no matter what I try.

SELECT SUM("energy_pos_balanced")
FROM "Sensor Data"
WHERE "serial" = '10000000cc6f363c' AND 
time >= '2024-05-05T00:00:00.00Z' AND 
time < '2024-05-18T00:00:00.00Z'
GROUP BY time(15m)

The query throws this error:
Error while planning query: SQL error: ParserError(“Expected ), found: m”): rpc error: code = InvalidArgument desc = Error while planning query: SQL error: ParserError(“Expected ), found: m”)

I have searched and searched and cannot find an answer as to why this will not work. Removing group by makes this work.

I am executing this through the online data explorer on influxdb cloud.

2

@Sunny_Kumar GROUP BY time(15m) is a feature unique to InfluxQL, not SQL. The InfluxDB Cloud Serverless Data Explorer only supports SQL. The same query in SQL would look like:

SELECT
  DATE_BIN(INTERVAL '15 minutes', time) AS time,
  SUM("energy_pos_balanced")
FROM
  "Sensor Data"
WHERE
  "serial" = '10000000cc6f363c'
  AND time >= '2024-05-05T00:00:00.00Z'
  AND time < '2024-05-18T00:00:00.00Z'
GROUP BY
  time