I am having a look at the Cassandra documentation at this link and wanted some clarity on the currentDate function and the example used Untitled | Apache Cassandra Documentation
For example the last two days of data can be retrieved using:
SELECT * FROM myTable WHERE date >= currentDate() - 2d;
I have the following questions based on the above synatx:
1. I am trying to populate a table with lots of data via a pipeline and wanted to query the last 3 days of data from the table using the following syntax example
SELECT * FROM myTable WHERE date >= currentDate() - 3d;
Would the above syntax be correct?
2. Supposing I wanted to query data over a period of time in hours, is there any function I could use to do this? Based on the documentation from the same link above, there is a currentTime() function and I am not sure if this would be ideal to use in this context.
Any help would be greatly appreciated.