Does anyone know, is the "floor" function available in Apache Cassandra?
This query works on Datastax's Cassandra
SELECT min(value) AS min, timestamp FROM test WHERE id=2020 AND timestamp>=1596240000073 AND timestamp<1598917999073 GROUP BY floor(timestamp, 10s);
But I can't run the same on Apache Cassandra.
The FLOOR() function for aggregating GROUP BY results was added in DSE 6.0 (DB-75).
It has not been added to open-source Apache Cassandra. The equivalent implementation is CASSANDRA-11871 originally planned for Cassandra 3.11 but did not make the cut. It has been slotted for C* 4.0 but has not been done yet. Cheers!
5 People are following this question.
