[
https://issues.apache.org/jira/browse/CASSANDRA-5718?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13709123#comment-13709123
]
Alex Liu commented on CASSANDRA-5718:
-------------------------------------
create a compact table
{code}
CREATE TABLE wordfreq ( title text, word text, occurances int, PRIMARY KEY
(title,occurances))
WITH COMPACT STORAGE and CLUSTERING ORDER by (occurances DESC);
{code}
show the schema
{code}
cqlsh:test> select key_aliases, column_aliases, key_validator, comparator
from system.schema_columnfamilies where keyspace_name='test';
key_aliases | column_aliases | key_validator |
comparator
-------------+----------------+------------------------------------------+-----------------------------------------------------------------------------------------
["title"] | ["occurances"] | org.apache.cassandra.db.marshal.UTF8Type |
org.apache.cassandra.db.marshal.ReversedType(org.apache.cassandra.db.marshal.Int32Type)
{code}
it has the clustering column and reversed type defined for the table in
system.schema_columnfamilies table.
> 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
> Fix For: 1.2.7
>
> Attachments: 5718-1.2-branch.txt
>
>
> 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
