[ https://issues.apache.org/jira/browse/CASSANDRA-5718?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13709123#comment-13709123 ]
Alex Liu edited comment on CASSANDRA-5718 at 7/15/13 11:03 PM: --------------------------------------------------------------- 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. The patch cover the compact storage type tables. Is there any other type of thrift table I am missing? was (Author: alexliu68): 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