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.ballarpure@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.ballarpure@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