http://www.datastax.com/support-forums/topic/cql-30 Software, Support, and Training for Apache Cassandra en-US Fri, 24 May 2013 10:20:10 +0000 http://bbpress.org/?v=1.0.3 q http://www.datastax.com/support-forums/search.php http://www.datastax.com/support-forums/topic/cql-30#post-6730 Sun, 30 Sep 2012 16:10:43 +0000 Srini 6730@http://www.datastax.com/support-forums/ <p>There is bug fix for similar issue. Check out</p> <p><a href="https://issues.apache.org/jira/browse/CASSANDRA-4219" rel="nofollow">https://issues.apache.org/jira/browse/CASSANDRA-4219</a> </p> http://www.datastax.com/support-forums/topic/cql-30#post-6722 Fri, 28 Sep 2012 18:01:20 +0000 kannanspec 6722@http://www.datastax.com/support-forums/ <p>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,<br /> any idea?</p> <p>cqlsh:xynergy&gt; select * from seen_ships;<br /> TSocket read 0 bytes<br /> cqlsh:xynergy&gt; </p> http://www.datastax.com/support-forums/topic/cql-30#post-6622 Fri, 21 Sep 2012 20:47:58 +0000 xedin 6622@http://www.datastax.com/support-forums/ <p>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.</p> <p>CREATE COLUMNFAMILY "OM_CDMA_SECTOR_DATA_MAIN" (<br /> id &lt;something&gt;,<br /> day timestamp,<br /> PRIMARY KEY (id, day)<br /> ); </p> http://www.datastax.com/support-forums/topic/cql-30#post-6621 Fri, 21 Sep 2012 20:33:51 +0000 kannanspec 6621@http://www.datastax.com/support-forums/ <p>Yes i have below indexed columns set up already, is there anything missing</p> <p>CREATE INDEX IDX1 ON OM_CDMA_SECTOR_DATA_MAIN (Day);</p> <p>thanks<br /> Kannan </p> http://www.datastax.com/support-forums/topic/cql-30#post-6620 Fri, 21 Sep 2012 20:32:13 +0000 xedin 6620@http://www.datastax.com/support-forums/ <p>Right, because you have to set up indexed columns before doing any operations :) </p> http://www.datastax.com/support-forums/topic/cql-30#post-6619 Fri, 21 Sep 2012 20:21:21 +0000 kannanspec 6619@http://www.datastax.com/support-forums/ <p>Hi, I used CQL 3.0 but i still get the below error which i get in 2.0</p> <p>cqlsh:xynergy&gt; select "Day" from "OM_CDMA_SECTOR_DATA_MAIN" where "Day" &gt; '7/29/2012';<br /> Bad Request: No indexed columns present in by-columns clause with Equal operator</p> <p>Thanks<br /> Kannan </p> http://www.datastax.com/support-forums/topic/cql-30#post-6618 Fri, 21 Sep 2012 19:46:25 +0000 xedin 6618@http://www.datastax.com/support-forums/ <p>To fix that you will have to double-quote ColumnFamily names in mixed case like this select * from "OM_CDMA_SECTOR_NEW1"; </p> http://www.datastax.com/support-forums/topic/cql-30#post-6617 Fri, 21 Sep 2012 19:44:39 +0000 kannanspec 6617@http://www.datastax.com/support-forums/ <p>Hi Xedin thanks for the suggestion, it worked but i am not able to query the tables created using previous version, any suggestion?</p> <p>cqlsh&gt; select * from OM_CDMA_SECTOR_NEW1;<br /> Bad Request: unconfigured columnfamily om_cdma_sector_new1</p> <p>thanks<br /> Kannan </p> http://www.datastax.com/support-forums/topic/cql-30#post-6616 Fri, 21 Sep 2012 19:13:12 +0000 xedin 6616@http://www.datastax.com/support-forums/ <p>Hi, you can give cqlsh --cql3 option and if you use thrift you can setCQLVersion to "3.0.0" to enable it. </p> http://www.datastax.com/support-forums/topic/cql-30#post-6615 Fri, 21 Sep 2012 18:53:51 +0000 kannanspec 6615@http://www.datastax.com/support-forums/ <p>Hi, How do i configure cassandra 1.1.0 to use cql 3.0?<br /> or<br /> what is the way to use CQL 3.0?<br /> I wanted to use Less than and greater than operation in the where clause. </p>