Yes, I have created keyspaces, but still i am getting error. cqlsh:sample_new> DESCRIBE KEYSPACES ;
system sample mykeyspace test sample_new system_traces [root@CSL-simulation conf]# ../bin/sstableloader /root/Akshay/Cassandra/apache-cassandra-2.0.8/conf/SAMPLE_NEW/DATA_NEW/ -d localhost --debug Could not retrieve endpoint ranges: InvalidRequestException(why:No such keyspace: SAMPLE_NEW) java.lang.RuntimeException: Could not retrieve endpoint ranges: at org.apache.cassandra.tools.BulkLoader$ExternalClient.init(BulkLoader.java:259) at org.apache.cassandra.io.sstable.SSTableLoader.stream(SSTableLoader.java:149) at org.apache.cassandra.tools.BulkLoader.main(BulkLoader.java:85) Caused by: InvalidRequestException(why:No such keyspace: SAMPLE_NEW) at org.apache.cassandra.thrift.Cassandra$describe_ring_result$describe_ring_resultStandardScheme.read(Cassandra.java:34055) at org.apache.cassandra.thrift.Cassandra$describe_ring_result$describe_ring_resultStandardScheme.read(Cassandra.java:34022) at org.apache.cassandra.thrift.Cassandra$describe_ring_result.read(Cassandra.java:33964) at org.apache.thrift.TServiceClient.receiveBase(TServiceClient.java:78) at org.apache.cassandra.thrift.Cassandra$Client.recv_describe_ring(Cassandra.java:1251) at org.apache.cassandra.thrift.Cassandra$Client.describe_ring(Cassandra.java:1238) at org.apache.cassandra.tools.BulkLoader$ExternalClient.init(BulkLoader.java:235) Thanks & Regards Akshay Ghanshyam Ballarpure Tata Consultancy Services Cell:- 9985084075 Mailto: akshay.ballarp...@tcs.com Website: http://www.tcs.com ____________________________________________ Experience certainty. IT Services Business Solutions Consulting ____________________________________________ From: Colin Kuo <colinkuo...@gmail.com> To: user@cassandra.apache.org Date: 07/28/2014 10:56 PM Subject: Re: unable to load data using sstableloader Have you created the schema for these data files? I meant the schema should be created before you load these data file to C*. Here is the article for introduction of sstableloader that you could refer. http://www.datastax.com/documentation/cassandra/1.2/cassandra/tools/toolsBulkloader_t.html On Mon, Jul 28, 2014 at 7:28 PM, Akshay Ballarpure < akshay.ballarp...@tcs.com> wrote: Hello, I am unable to load sstable into cassandra using sstable loader, please suggest. Thanks. [root@CSL-simulation conf]# pwd /root/Akshay/Cassandra/apache-cassandra-2.0.8/conf [root@CSL-simulation conf]# ls -ltr keyspace/col/ total 32 -rw-r--r-- 1 root root 16 Jul 28 16:55 Test-Data-jb-1-Filter.db -rw-r--r-- 1 root root 300 Jul 28 16:55 Test-Data-jb-1-Index.db -rw-r--r-- 1 root root 3470 Jul 28 16:55 Test-Data-jb-1-Data.db -rw-r--r-- 1 root root 8 Jul 28 16:55 Test-Data-jb-1-CRC.db -rw-r--r-- 1 root root 64 Jul 28 16:55 Test-Data-jb-1-Digest.sha1 -rw-r--r-- 1 root root 4392 Jul 28 16:55 Test-Data-jb-1-Statistics.db -rw-r--r-- 1 root root 79 Jul 28 16:55 Test-Data-jb-1-TOC.txt [root@CSL-simulation conf]# ../bin/sstableloader -d localhost /root/Akshay/Cassandra/apache-cassandra-2.0.8/conf/keyspace/col/ --debug Could not retrieve endpoint ranges: InvalidRequestException(why:No such keyspace: keyspace) java.lang.RuntimeException: Could not retrieve endpoint ranges: at org.apache.cassandra.tools.BulkLoader$ExternalClient.init(BulkLoader.java:259) at org.apache.cassandra.io.sstable.SSTableLoader.stream(SSTableLoader.java:149) at org.apache.cassandra.tools.BulkLoader.main(BulkLoader.java:85) Caused by: InvalidRequestException(why:No such keyspace: keyspace) at org.apache.cassandra.thrift.Cassandra$describe_ring_result$describe_ring_resultStandardScheme.read(Cassandra.java:34055) at org.apache.cassandra.thrift.Cassandra$describe_ring_result$describe_ring_resultStandardScheme.read(Cassandra.java:34022) at org.apache.cassandra.thrift.Cassandra$describe_ring_result.read(Cassandra.java:33964) at org.apache.thrift.TServiceClient.receiveBase(TServiceClient.java:78) at org.apache.cassandra.thrift.Cassandra$Client.recv_describe_ring(Cassandra.java:1251) at org.apache.cassandra.thrift.Cassandra$Client.describe_ring(Cassandra.java:1238) at org.apache.cassandra.tools.BulkLoader$ExternalClient.init(BulkLoader.java:235) ... 2 more Thanks & Regards Akshay Ghanshyam Ballarpure Tata Consultancy Services Cell:- 9985084075 Mailto: akshay.ballarp...@tcs.com Website: http://www.tcs.com ____________________________________________ Experience certainty. IT Services Business Solutions Consulting ____________________________________________ =====-----=====-----===== Notice: The information contained in this e-mail message and/or attachments to it may contain confidential or privileged information. If you are not the intended recipient, any dissemination, use, review, distribution, printing or copying of the information contained in this e-mail message and/or attachments to it are strictly prohibited. If you have received this communication in error, please notify us by reply e-mail or telephone and immediately and permanently delete the message and any attachments. Thank you