Hello, I am fairly new to cassandra so this might be naieve question:
I have table that currently has following entries: SELECT asset_id,event_time,sensor_type, temperature,humidity from temp_humidity_data where asset_id='2'; asset_id | event_time | sensor_type | temperature | humidity ----------+--------------------------+-------------+-------------+---------- 2 | 2014-08-17 03:33:16-0700 | 1 | 74.768 | 65.768 2 | 2014-08-17 03:33:17-0700 | 1 | 67.228 | 91.228 2 | 2014-08-17 03:33:19-0700 | 1 | 61.97 | 73.97 Now if I execute a query : SELECT asset_id,event_time,sensor_type, temperature,humidity from temp_humidity_data where asset_id='2' and event_time > '2014-08-17 03:33:20' ALLOW FILTERING; it gives me back same results (!), I expected it to give me 0 results. asset_id | event_time | sensor_type | temperature | humidity ----------+--------------------------+-------------+-------------+---------- 2 | 2014-08-17 03:33:16-0700 | 1 | 74.768 | 65.768 2 | 2014-08-17 03:33:17-0700 | 1 | 67.228 | 91.228 2 | 2014-08-17 03:33:19-0700 | 1 | 61.97 | 73.97 am I doing something wrong? Note I have created table with following options. CREATE TABLE temp_humidity_data ( asset_id text, event_time timestamp, sensor_serial_number text, sensor_type int, temperature float, humidity float, polling_freq int, PRIMARY KEY(asset_id ,event_time) ) WITH CLUSTERING ORDER BY (event_time ASC) AND caching = '{"keys":"ALL", "rows_per_partition":"ALL"}' I have also created following indexes: CREATE INDEX event_time_index ON temp_humidity_data (event_time); Also of note is, since actual installation I will be running against large time series data I have configured 'row_cache_size_in_mb: 20' I am running cqlsh 5.0.1 , and cassandra version 2.1.0-rc3 Would appreciate any suggestion on why the date grater-than query is returning all the results? -Subodh