Thanks Rob. I am on 1.1.4 now (I can go to 1.1.6 if needed) and apparently it is broken. I defined the table like this:
CREATE TABLE events(interval int,id bigint,containerName varchar,objectName varchar,objectType varchar, " status int, severity int, event varchar, eventType varchar, PRIMARY KEY (interval, id)) WITH CLUSTERING ORDER BY (id DESC); and in cqlsh it returns the value as: [cqlsh 2.2.0 | Cassandra 1.1.4 | CQL spec 3.0.0 | Thrift protocol 19.32.0] Use HELP for help. cqlsh> select id from somedb.events where interval = 1; id ---------------------------- \x00\x04\xd08\x17X<_ \x00\x04\xd08\x17X8v \x00\x04\xd08\x17X8u \x00\x04\xd08\x17X4\x8c \x00\x04\xd08\x17X0\xa3 \x00\x04\xd08\x17X,\xba where without "with clustering" or with WITH CLUSTERING ORDER BY (id ASC) it would return it as: [cqlsh 2.2.0 | Cassandra 1.1.4 | CQL spec 3.0.0 | Thrift protocol 19.32.0] Use HELP for help. cqlsh> select id from somedb.events where interval = 1; id ------------------ 13548426280581 13548426280922 13548426280953 13548426280974 13548426280995 My real table is using uuid rather than long but that broke first, With JDBC driver it is even worse it breaks with : java.lang.NullPointerException at org.apache.cassandra.cql.jdbc.TypedColumn.<init>(TypedColumn.java:44) at org.apache.cassandra.cql.jdbc.CassandraResultSet.createColumn(CassandraResultSet.java:972) at org.apache.cassandra.cql.jdbc.CassandraResultSet.populateColumns(CassandraResultSet.java:156) at org.apache.cassandra.cql.jdbc.CassandraResultSet.<init>(CassandraResultSet.java:130) at org.apache.cassandra.cql.jdbc.CassandraPreparedStatement.doExecute(CassandraPreparedStatement.java:143) at org.apache.cassandra.cql.jdbc.CassandraPreparedStatement.executeQuery(CassandraPreparedStatement.java:199) at com.parseix.demo.RetriveEventJDBC.retreiveEvents(RetriveEventJDBC.java:34) at com.parseix.demo.RetriveEventJDBC.main(RetriveEventJDBC.java:18) please let me know if I need to open a bug. Thanks Shahryar On Wed, Dec 5, 2012 at 9:47 PM, Rob Coli <rc...@palominodb.com> wrote: > On Wed, Dec 5, 2012 at 3:59 PM, Shahryar Sedghi <shsed...@gmail.com> > wrote: > > Is there a keyword with the same functionality as reversed=True or CQL 3 > on > > Cassandra 1.1.6? > > https://issues.apache.org/jira/browse/CASSANDRA-4004 > > =Rob > > -- > =Robert Coli > AIM>ALK - rc...@palominodb.com > YAHOO - rcoli.palominob > SKYPE - rcoli_palominodb > -- "Life is what happens while you are making other plans." ~ John Lennon