Cassandra SELECT BETWEEN two dates

Question

How can i convert below SQL query to CQL query?

SELECT * FROM csv_report WHERE sensor_id=170268 AND create_day BETWEEN 20150401 AND 20150403;

also i trying different BETWEEN query:

SELECT * FROM csv_report WHERE sensor_id=170268 AND create_day >= 20150401 AND create_day <= 20150403;

But this query raised an error:

code=2200 [Invalid query] message="Only EQ and IN relation are supported on the partition key (unless you use the token() function)"

Answer 1

Try this

SELECT * 
FROM csv_report 
WHERE sensor_id=170268 
AND create_day IN (20150401, 20150402, 20150403);