cassandra-commits mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Alex Liu (JIRA)" <j...@apache.org>
Subject [jira] [Updated] (CASSANDRA-5718) Cql3 reader returns duplicate rows if the cluster column is reversed
Date Tue, 02 Jul 2013 16:59:20 GMT

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

Alex Liu updated CASSANDRA-5718:
--------------------------------

    Description: 
To reproduce it,

cqlsh:test>  select * from wordfreq;

 title   | occurances | word
---------+------------+-------
 alex123 |          4 |  liu3
   alex1 |      23456 |  liu2
  alex10 |         10 | liu10
  alex12 |         34 |  liu3
    alex |     123456 |  liu1
    alex |       1000 |   liu


CREATE TABLE wordfreq ( title text, word text, occurances int, PRIMARY KEY (title,occurances))
WITH CLUSTERING ORDER by (occurances DESC);

The hadoop job returns 7 rows instead of 6 rows. 

I will post a patch soon.


  was:
To reproduce it,

cqlsh:test>  select * from wordfreq;

 title   | occurances | word
---------+------------+-------
 alex123 |          4 |  liu3
   alex1 |      23456 |  liu2
  alex10 |         10 | liu10
  alex12 |         34 |  liu3
    alex |     123456 |  liu1
    alex |       1000 |   liu


CREATE TABLE wordfreq ( title text, word text, occurances int, PRIMARY KEY (title,occurances))
WITH CLUSTERING ORDER by (occurances DESC);

I will post a patch soon.


    
> Cql3 reader returns duplicate rows if the cluster column is reversed
> --------------------------------------------------------------------
>
>                 Key: CASSANDRA-5718
>                 URL: https://issues.apache.org/jira/browse/CASSANDRA-5718
>             Project: Cassandra
>          Issue Type: Bug
>    Affects Versions: 1.2.6
>            Reporter: Alex Liu
>            Assignee: Alex Liu
>
> To reproduce it,
> cqlsh:test>  select * from wordfreq;
>  title   | occurances | word
> ---------+------------+-------
>  alex123 |          4 |  liu3
>    alex1 |      23456 |  liu2
>   alex10 |         10 | liu10
>   alex12 |         34 |  liu3
>     alex |     123456 |  liu1
>     alex |       1000 |   liu
> CREATE TABLE wordfreq ( title text, word text, occurances int, PRIMARY KEY (title,occurances))
WITH CLUSTERING ORDER by (occurances DESC);
> The hadoop job returns 7 rows instead of 6 rows. 
> I will post a patch soon.

--
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