kannanspec Software, Support, and Training for Apache Cassandra en-US Thu, 23 May 2013 23:52:53 +0000 http://bbpress.org/?v=1.0.3 q http://www.datastax.com/support-forums/search.php http://www.datastax.com/support-forums/topic/cassandra-sstableloader-load-key-value-instead-of-uuid#post-8906 Mon, 04 Feb 2013 18:17:54 +0000 kannanspec 8906@http://www.datastax.com/support-forums/ <p>This is my table </p> <p>CREATE COLUMNFAMILY OM_CDMA_SECTOR_1 (<br /> ... KEY ascii PRIMARY KEY,<br /> ... '2012dec10' ascii,<br /> ... '2012dec11' ascii,<br /> ... '2012dec12' ascii,<br /> ... '2012dec13' ascii,<br /> ... '2012dec14' ascii,<br /> ... '2012dec15' ascii,<br /> ... '2012dec16' ascii<br /> ... ) </p> <p>I need to load the key column (primary key )from the file instead of UUID </p> <p>i replaced </p> <p> // ByteBuffer uuid = ByteBuffer.wrap(decompose(entry.CorrelationID));<br /> eventWriter.newRow(uuid);</p> <p>to </p> <p>eventWriter.addColumn(bytes("KEY"),bytes(entry.KEY), timestamp);</p> <p>it gives me below error</p> <p>[kmookaia@sql-xcc-vna2d01 apache-cassandra-1.1.0]$ ./run.sh cdma_sector_136.txt<br /> Exception in thread "main" java.lang.NullPointerException<br /> at org.apache.cassandra.io.sstable.AbstractSSTableSimpleWriter.addColumn(AbstractSSTableSimpleWriter.java:115)<br /> at org.apache.cassandra.io.sstable.AbstractSSTableSimpleWriter.addColumn(AbstractSSTableSimpleWriter.java:130)<br /> at SSTableGenerator.main(SSTableGenerator.java:62)</p> <p>how do i load key value from a file using SSTableLoader?</p> <p>Any help appriciated </p> http://www.datastax.com/support-forums/topic/cassandra-loading-csv-using-sstableloader/page/3#post-8882 Sat, 02 Feb 2013 23:59:11 +0000 chandu 8882@http://www.datastax.com/support-forums/ <p>Hello Group,</p> <p>I am using bulkoutputformat to load from HadoopToCassandra. We changed configuration like rpc port to 9161 &amp; storage port to 7002.<br /> How to i pass storage port number from Hadoop Driver.</p> <p>thanks<br /> chandu </p> 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> http://www.datastax.com/support-forums/topic/connect-to-cassandra#post-5813 Fri, 10 Aug 2012 20:10:10 +0000 thobbs 5813@http://www.datastax.com/support-forums/ <p>We recommend FluentCassandra: <a href="https://github.com/managedfusion/fluentcassandra" rel="nofollow">https://github.com/managedfusion/fluentcassandra</a> </p> http://www.datastax.com/support-forums/topic/connect-to-cassandra#post-5460 Tue, 07 Aug 2012 16:21:54 +0000 kannanspec 5460@http://www.datastax.com/support-forums/ <p>I am trying to connect to cassandra from C#, What is best way to connect?<br /> Thanks for you help.</p> <p>Kannan. </p> http://www.datastax.com/support-forums/topic/cassandra-loading-csv-using-sstableloader/page/3#post-2825 Mon, 09 Jul 2012 14:47:32 +0000 kannanspec 2825@http://www.datastax.com/support-forums/ <p>hi,</p> <p>I cleaned up the data directories /var/lib/cassandra/data and restarted the cassandra and now i am able to load the csv using nodetool refresh. </p> <p>Thanks for you help. I am trying to load from different machine now. </p> <p>Thanks<br /> Kannan. </p>