Does velox support something like DATE_BIN in influxdb SQL or group by time(1h) in influxql? #10875
Unanswered
Super-long
asked this question in
Q&A
Replies: 1 comment
-
Clickhouse can be executed like this : |
Beta Was this translation helpful? Give feedback.
0 replies
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment
-
influxdb sql:
SELECT
DATE_BIN(INTERVAL '2 hours', time, '1970-01-01T00:00:00Z'::TIMESTAMP)
AS _time,
room,
selector_max(temp, time)['value'] AS 'max temp',
selector_min(temp, time)['value'] AS 'min temp',
avg(temp) AS 'average temp'
FROM home
GROUP BY _time, room
ORDER BY room, _time
influxql:
SELECT COUNT("water_level") FROM "h2o_feet" WHERE "location"='coyote_creek' AND time >= '2019-08-18T00:06:00Z' AND time < '2019-08-18T00:18:00Z' GROUP BY time(12m)
2019-08-18T00:00:00Z 1.0000000000
2019-08-18T00:12:00Z 1.0000000000
Does velox natively support this syntax, or how to make velox support it?
Beta Was this translation helpful? Give feedback.
All reactions