DataStax Academy FAQ

DataStax Academy migrated to a new learning management system (LMS) in July 2020. We are also moving to a new Cassandra Certification process so there are changes to exam bookings, voucher system and issuing of certificates.

Check out the Academy FAQ pages for answers to your questions:


question

arsooo avatar image
arsooo asked ·

Why is the CQL function FLOOR() only available in DataStax Enterprise?

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.

dsecqlaggregation
10 |1000 characters needed characters left characters exceeded

Up to 8 attachments (including images) can be used with a maximum of 1.0 MiB each and 10.0 MiB total.

1 Answer

Erick Ramirez avatar image
Erick Ramirez answered ·

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!

Share
10 |1000 characters needed characters left characters exceeded

Up to 8 attachments (including images) can be used with a maximum of 1.0 MiB each and 10.0 MiB total.