You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@cassandra.apache.org by Akshay Ballarpure <ak...@tcs.com> on 2014/07/28 13:28:11 UTC
unable to load data using sstableloader
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
Re: unable to load data using sstableloader
Posted by Akshay Ballarpure <ak...@tcs.com>.
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.ballarpure@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" <us...@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 <ak...@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.ballarpure@tcs.com
Website: http://www.tcs.com
____________________________________________
Experience certainty. IT Services
Business Solutions
Consulting
____________________________________________
From:
Duncan Sands <du...@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
Re: unable to load data using sstableloader
Posted by Rahul Neelakantan <ra...@rahul.be>.
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 <ak...@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.ballarpure@tcs.com
> Website: http://www.tcs.com
> ____________________________________________
> Experience certainty. IT Services
> Business Solutions
> Consulting
> ____________________________________________
>
>
> From: Duncan Sands <du...@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
>
Re: unable to load data using sstableloader
Posted by Rahul Neelakantan <ra...@rahul.be>.
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 <ak...@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.ballarpure@tcs.com
> Website: http://www.tcs.com
> ____________________________________________
> Experience certainty. IT Services
> Business Solutions
> Consulting
> ____________________________________________
>
>
> From: Duncan Sands <du...@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
>
Re: unable to load data using sstableloader
Posted by Akshay Ballarpure <ak...@tcs.com>.
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.ballarpure@tcs.com
Website: http://www.tcs.com
____________________________________________
Experience certainty. IT Services
Business Solutions
Consulting
____________________________________________
From:
Duncan Sands <du...@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
Re: unable to load data using sstableloader
Posted by Duncan Sands <du...@gmail.com>.
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.
Re: unable to load data using sstableloader
Posted by Akshay Ballarpure <ak...@tcs.com>.
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.ballarpure@tcs.com
Website: http://www.tcs.com
____________________________________________
Experience certainty. IT Services
Business Solutions
Consulting
____________________________________________
From:
Colin Kuo <co...@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.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
Re: unable to load data using sstableloader
Posted by Colin Kuo <co...@gmail.com>.
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
>
>