cql 3.0

(10 posts) (3 voices)

• Started 7 months ago by kannanspec
• Latest reply from Srini
• This topic is not a support question

Tags:

No tags yet.

1. 

   kannanspec
   Member

   Hi, How do i configure cassandra 1.1.0 to use cql 3.0?
   or
   what is the way to use CQL 3.0?
   I wanted to use Less than and greater than operation in the where clause.

   Posted 7 months ago #
2. 

   xedin
   Member

   Hi, you can give cqlsh --cql3 option and if you use thrift you can setCQLVersion to "3.0.0" to enable it.

   Posted 7 months ago #
3. 

   kannanspec
   Member

   Hi Xedin thanks for the suggestion, it worked but i am not able to query the tables created using previous version, any suggestion?

   cqlsh> select * from OM_CDMA_SECTOR_NEW1;
   Bad Request: unconfigured columnfamily om_cdma_sector_new1

   thanks
   Kannan

   Posted 7 months ago #
4. 

   xedin
   Member

   To fix that you will have to double-quote ColumnFamily names in mixed case like this select * from "OM_CDMA_SECTOR_NEW1";

   Posted 7 months ago #
5. 

   kannanspec
   Member

   Hi, I used CQL 3.0 but i still get the below error which i get in 2.0

   cqlsh:xynergy> select "Day" from "OM_CDMA_SECTOR_DATA_MAIN" where "Day" > '7/29/2012';
   Bad Request: No indexed columns present in by-columns clause with Equal operator

   Thanks
   Kannan

   Posted 7 months ago #
6. 

   xedin
   Member

   Right, because you have to set up indexed columns before doing any operations :)

   Posted 7 months ago #
7. 

   kannanspec
   Member

   Yes i have below indexed columns set up already, is there anything missing

   CREATE INDEX IDX1 ON OM_CDMA_SECTOR_DATA_MAIN (Day);

   thanks
   Kannan

   Posted 7 months ago #
8. 

   xedin
   Member

   I think you will have to re-create your ColumnFamily with CQL3 to use it properly and include "Date" field into PRIMARY KEY, because CQL3 makes use of composite comparators, e.g.

   CREATE COLUMNFAMILY "OM_CDMA_SECTOR_DATA_MAIN" (
   id <something>,
   day timestamp,
   PRIMARY KEY (id, day)
   );

   Posted 7 months ago #
9. 

   kannanspec
   Member

   Hi, I created new column family with CQL3 option. but when i load the data using the SSTableLoader , which i used for cql2.0, i recieve below error on the column family,
   any idea?

   cqlsh:xynergy> select * from seen_ships;
   TSocket read 0 bytes
   cqlsh:xynergy>

   Posted 7 months ago #
10. 

    Srini
    Member

    There is bug fix for similar issue. Check out

    https://issues.apache.org/jira/browse/CASSANDRA-4219

    Posted 7 months ago #

RSS feed for this topic

Reply

You must log in to post.