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

Reply via email to