Apache Druid

could you do something like
```SELECT
  FLOOR(__time TO HOUR),
  AVG(dim)
FROM "table"
GROUP BY 1```
?

Thank you for the answer! I have tried the query, I need to perform some test to be sure that the aggregation is correct but after a first rapid look it seems to work. Is there any loss of efficency in writing the query in sql rather than using druid native language? Does Druid still perform all "its magic" also if the query is in sql?

performance between SQL and native JSON queries is equivalent other than the (generally slight) time it takes to parse/plan SQL

since the SQL planner plans into native JSON queries and then executes those

I understand. Thank you for the clarification!