[
https://issues.apache.org/jira/browse/CASSANDRA-10583?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Kai Wang updated CASSANDRA-10583:
---------------------------------
Attachment: screenshot.png
Reproduced In: 2.2.4, 2.1.10 (was: 2.1.10, 2.2.4)
> After bulk loading CQL query on timestamp column returns wrong result
> ---------------------------------------------------------------------
>
> Key: CASSANDRA-10583
> URL: https://issues.apache.org/jira/browse/CASSANDRA-10583
> Project: Cassandra
> Issue Type: Bug
> Environment: Windows 2008 R2, Java x64 1.8.0_60, CentOS 7, Java
> 1.8.0._65
> Reporter: Kai Wang
> Fix For: 2.1.x, 2.2.x, 3.x
>
> Attachments: screenshot.png, timeseries_test.zip
>
>
> I have this table:
> {noformat}
> CREATE TABLE test (
> tag text,
> group int,
> timestamp timestamp,
> value double,
> PRIMARY KEY (tag, group, timestamp)
> ) WITH CLUSTERING ORDER BY (group ASC, timestamp DESC)
> {noformat}
> First I used CQLSSTableWriter to bulk load a bunch of sstables. Then I ran
> this query:
> {noformat}
> cqlsh> select * from test where tag = 'MSFT' and group = 1 and timestamp
> ='2004-12-15 16:00:00-0500';
> tag | group | timestamp | value
> ------+-------+--------------------------+-------
> MSFT | 1 | 2004-12-15 21:00:00+0000 | 27.11
> MSFT | 1 | 2004-12-16 21:00:00+0000 | 27.16
> MSFT | 1 | 2004-12-17 21:00:00+0000 | 26.96
> MSFT | 1 | 2004-12-20 21:00:00+0000 | 26.95
> MSFT | 1 | 2004-12-21 21:00:00+0000 | 27.07
> MSFT | 1 | 2004-12-22 21:00:00+0000 | 26.98
> MSFT | 1 | 2004-12-23 21:00:00+0000 | 27.01
> MSFT | 1 | 2004-12-27 21:00:00+0000 | 26.85
> MSFT | 1 | 2004-12-28 21:00:00+0000 | 26.95
> MSFT | 1 | 2004-12-29 21:00:00+0000 | 26.9
> MSFT | 1 | 2004-12-30 21:00:00+0000 | 26.76
> (11 rows)
> {noformat}
> The result is obviously wrong.
> If I run this query:
> {noformat}
> cqlsh> select * from test where tag = 'MSFT' and group = 1 and timestamp
> ='2004-12-16 16:00:00-0500';
> tag | group | timestamp | value
> -----+-------+-----------+-------
> (0 rows)
> {noformat}
> In DevCenter I tried to create a similar table and insert a few rows but
> couldn't reproduce this. This may have something to do with the bulk loading
> process. But still, the fact cqlsh returns data that doesn't match the query
> is concerning.
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
