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/snaptr ee-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
