You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@cassandra.apache.org by "Alex Petrov (JIRA)" <ji...@apache.org> on 2017/05/12 06:09:04 UTC
[jira] [Comment Edited] (CASSANDRA-13478) SASIndex has a time to
live issue in Cassandra
[ https://issues.apache.org/jira/browse/CASSANDRA-13478?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16007674#comment-16007674 ]
Alex Petrov edited comment on CASSANDRA-13478 at 5/12/17 6:08 AM:
------------------------------------------------------------------
Would appreciate it, will be much easier to reproduce / understand what's going on. You can ping me directly at [here|mailto:alex.petrov@datastax.com]
was (Author: ifesdjeen):
Would appreciate it, will be much easier to reproduce / understand what's going on. You can ping me directly at [here|alex.petrov@datastax.com]
> SASIndex has a time to live issue in Cassandra
> ----------------------------------------------
>
> Key: CASSANDRA-13478
> URL: https://issues.apache.org/jira/browse/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,
> Ex:
> {code}
> CREATE TABLE XXX.userlist (
> userid text PRIMARY KEY,
> lastposttime timestamp
> )
> Select * from userlist where lastposttime> '2017-04-01 16:00:00+0000';
> {code}
> 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
(v6.3.15#6346)
---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@cassandra.apache.org
For additional commands, e-mail: commits-help@cassandra.apache.org