cassandra-commits mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "jack chen (JIRA)" <>
Subject [jira] [Created] (CASSANDRA-13478) SASIndex has a time to live issue in Cassandra
Date Wed, 26 Apr 2017 08:40:04 GMT
jack chen created CASSANDRA-13478:

             Summary: SASIndex has a time to live issue in Cassandra
                 Key: CASSANDRA-13478
             Project: Cassandra
          Issue Type: Bug
          Components: sasi
         Environment: cqlsh 5.0.1 | Cassandra 3.10 | CQL spec 3.4.4 | Native protocol v4 |
ubuntu 14.04
            Reporter: jack chen
            Priority: Minor
         Attachments: schema

I have a table, the schema can be seen in attach file

I would like to search the data using the timestamp data type with lt gt eq as a query condition,
Select * from userlist where lastposttime> '2017-04-01 16:00:00+0000';

There are 2 conditions :
If I insert the data and then select it, the result will be correct
But in case I insert data and then the next day I restart Cassandra, and after that select
the data, there will be no data selected

The difference is that there is no Service restart on th next day in the first manner. Actually,
the data are still living in Cassandra, but TimeStamp can’t be used as the query condition

This message was sent by Atlassian JIRA

View raw message