cassandra-commits mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Brandon Williams (JIRA)" <j...@apache.org>
Subject [jira] [Resolved] (CASSANDRA-4773) CQL shell not reflecting latest data when timestamp is passed as part of insert statements
Date Sat, 06 Oct 2012 19:43:02 GMT

     [ https://issues.apache.org/jira/browse/CASSANDRA-4773?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]

Brandon Williams resolved CASSANDRA-4773.
-----------------------------------------

    Resolution: Not A Problem

Timestamps are the method of conflict resolution, so when you use the same one the behavior
is undefined but deterministic.
                
> CQL shell not reflecting latest data when timestamp is passed as part of insert statements
> ------------------------------------------------------------------------------------------
>
>                 Key: CASSANDRA-4773
>                 URL: https://issues.apache.org/jira/browse/CASSANDRA-4773
>             Project: Cassandra
>          Issue Type: Bug
>    Affects Versions: 1.1.4
>         Environment: CentOS
>            Reporter: Ananth Gundabattula
>            Priority: Critical
>
> While using the CQLSH, I try inserting a row using timestamp and TTL along with consistency.
The insert works fine for the first time. When I try to insert using the same key but different
value and then issue a select , the value of the returned row is always the first value of
the inserted row and not the value that was inserted later. Here are the details : 
> 1. Replication Factor = 1
> 2. Consistency Level = ONE
> 3. TTL = 14 days
> 4. Timestamp = A value which reflects 10 days before the current day 
> 5. Cassandra 1.1.4 
> 6. CQL shell version 2
> It may be noted that if the timstamp is not used while issuing the insert statement,
the second insert on the same key works fine. 
> Here are the details: 
> 1. INSERT INTO Table1 (col1,col2,col3,col4,col5,col6) VALUES('abcde', 0, 87, 1345603159,222,'65DE')
USING  TIMESTAMP 1349476620 AND TTL 1209600;
> This works fine
> 2. Issuing a select works fine for the above row. 
> 3. INSERT INTO Table1 (col1,col2,col3,col4,col5,col6) VALUES('abcde', 0, 87, 1345603159,222,'a2134')
USING  TIMESTAMP 1349476620 AND TTL 1209600;
> There is no error on this statement
> 4. Issuing a select returns the data inserted as given in step 1.
> 5. Giving a timestamp later than the above timestamp also does not change things
> 6. However, if I issue an insert without specifying the timestamp , the select statement
gives the latest data always.

--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators
For more information on JIRA, see: http://www.atlassian.com/software/jira

Mime
View raw message