Yes Rahul, i didn't created any ring. just a stand alone setup (single node cluster) Issue got resolved after creating sstable file properly...i mean, Keyspace/ColumnFamily folder manually and keeping sstable file in it.
Somehow java api is not creating column family folder under keyspace, did you or any one saw such problem before ? 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: Rahul Neelakantan <ra...@rahul.be> To: "user@cassandra.apache.org" <user@cassandra.apache.org> Date: 07/29/2014 05:02 PM Subject: Re: unable to load data using sstableloader Is SStable loader being run on the same host as the Cassandra node 127.0.0.1 (I see your ring is made up of all loop back IPs). Rahul Neelakantan 678-451-4545 On Jul 29, 2014, at 4:55 AM, Akshay Ballarpure <akshay.ballarp...@tcs.com> wrote: Thanks Duncan for quick help.... now i am trying sstableloader but its not loading data...any suggestion ? [root@CSL-simulation conf]# ps -eaf | grep -i cass root 20322 1 0 Jul28 ? 00:04:27 /usr/java/jdk1.7.0_60/bin/java -ea -javaagent:./../lib/jamm-0.2.5.jar -XX:+CMSClassUnloadingEnabled -XX:+UseThreadPriorities -XX:ThreadPriorityPolicy=42 -Xms7G -Xmx7G -Xmn1800M -XX:+HeapDumpOnOutOfMemoryError -Xss256k -XX:StringTableSize=1000003 -XX:+UseParNewGC -XX:+UseConcMarkSweepGC -XX:+CMSParallelRemarkEnabled -XX:SurvivorRatio=8 -XX:MaxTenuringThreshold=1 -XX:CMSInitiatingOccupancyFraction=75 -XX:+UseCMSInitiatingOccupancyOnly -XX:+UseTLAB -XX:+UseCondCardMark -Djava.net.preferIPv4Stack=true -Dcom.sun.management.jmxremote.port=7199 -Dcom.sun.management.jmxremote.rmi.port=7199 -Dcom.sun.management.jmxremote.ssl=false -Dcom.sun.management.jmxremote.authenticate=false -Dlog4j.configuration=log4j-server.properties -Dlog4j.defaultInitOverride=true -cp ./../conf:./../build/classes/main:./../build/classes/thrift:./../lib/antlr-3.2.jar:./../lib/apache-cassandra-2.0.8.jar:./../lib/apache-cassandra-clientutil-2.0.8.jar:./../lib/apache-cassandra-thrift-2.0.8.jar:./../lib/commons-cli-1.1.jar:./../lib/commons-codec-1.2.jar:./../lib/commons-lang3-3.1.jar:./../lib/compress-lzf-0.8.4.jar:./../lib/concurrentlinkedhashmap-lru-1.3.jar:./../lib/disruptor-3.0.1.jar:./../lib/guava-15.0.jar:./../lib/high-scale-lib-1.1.2.jar:./../lib/jackson-core-asl-1.9.2.jar:./../lib/jackson-mapper-asl-1.9.2.jar:./../lib/jamm-0.2.5.jar:./../lib/jbcrypt-0.3m.jar:./../lib/jline-1.0.jar:./../lib/json-simple-1.1.jar:./../lib/libthrift-0.9.1.jar:./../lib/log4j-1.2.16.jar:./../lib/lz4-1.2.0.jar:./../lib/metrics-core-2.2.0.jar:./../lib/netty-3.6.6.Final.jar:./../lib/reporter-config-2.1.0.jar:./../lib/servlet-api-2.5-20081211.jar:./../lib/slf4j-api-1.7.2.jar:./../lib/slf4j-log4j12-1.7.2.jar:./../lib/snakeyaml-1.11.jar:./../lib/ snappy-java-1.0.5.jar:./../lib/snaptree-0.1.jar:./../lib/super-csv-2.1.0.jar:./../lib/thrift-server-internal-only-0.3.3.jar org.apache.cassandra.service.CassandraDaemon root 28246 26448 0 14:24 pts/3 00:00:00 grep -i cass [root@CSL-simulation conf]# ../bin/sstableloader sample_new/data_new -d localhost Established connection to initial hosts Opening sstables and calculating sections to stream Streaming relevant part of sample_new/data_new/sample_new-data_new-jb-1-Data.db to [/127.0.0.1] Streaming session ID: 05c15ca0-16fe-11e4-bdb8-731053160c4f progress: [/127.0.0.1 1/1 (100%)] [total: 100% - 0MB/s (avg: 0MB/s)] WARN 14:25:00,535 [Stream #05c15ca0-16fe-11e4-bdb8-731053160c4f] Stream failed Streaming to the following hosts failed: [/127.0.0.1] java.util.concurrent.ExecutionException: org.apache.cassandra.streaming.StreamException: Stream failed [root@CSL-simulation conf]# ../bin/sstableloader sample_new/data_new -d 127.0.0.1 Established connection to initial hosts Opening sstables and calculating sections to stream Streaming relevant part of sample_new/data_new/sample_new-data_new-jb-1-Data.db to [/127.0.0.1] Streaming session ID: 161819e0-16fe-11e4-8377-731053160c4f progress: [/127.0.0.1 1/1 (100%)] [total: 100% - 0MB/s (avg: 0MB/s)] WARN 14:25:27,957 [Stream #161819e0-16fe-11e4-8377-731053160c4f] Stream failed Streaming to the following hosts failed: [/127.0.0.1] java.util.concurrent.ExecutionException: org.apache.cassandra.streaming.StreamException: Stream failed 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: Duncan Sands <duncan.sa...@gmail.com> To: user@cassandra.apache.org Date: 07/29/2014 12:58 PM Subject: Re: unable to load data using sstableloader Hi Akshay, On 29/07/14 09:14, Akshay Ballarpure wrote: > 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*) here SAMPLE_NEW is in upper case, while describe keyspaces showed it lower case, sample_new. Try using quote marks: CREATE KEYSPACE "SAMPLE_NEW" ... Ciao, Duncan. =====-----=====-----===== 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