Sstabloader and Cassandra can't use the same network interface, clearly mentioned in the Cassandra documentation on DataStax. If you are running both Cassandra and SStableloader locally, you have to take some extra steps. Look at the post.
pushpalankajaya.blogspot.com/2012/06/bulk-loading-data-to-cassandra-using.html?m=1 Rahul Neelakantan > 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 >
