Return-Path: X-Original-To: apmail-cassandra-user-archive@www.apache.org Delivered-To: apmail-cassandra-user-archive@www.apache.org Received: from mail.apache.org (hermes.apache.org [140.211.11.3]) by minotaur.apache.org (Postfix) with SMTP id 7913611ED0 for ; Mon, 28 Jul 2014 17:26:21 +0000 (UTC) Received: (qmail 88269 invoked by uid 500); 28 Jul 2014 17:26:12 -0000 Delivered-To: apmail-cassandra-user-archive@cassandra.apache.org Received: (qmail 88234 invoked by uid 500); 28 Jul 2014 17:26:12 -0000 Mailing-List: contact user-help@cassandra.apache.org; run by ezmlm Precedence: bulk List-Help: List-Unsubscribe: List-Post: List-Id: Reply-To: user@cassandra.apache.org Delivered-To: mailing list user@cassandra.apache.org Received: (qmail 88222 invoked by uid 99); 28 Jul 2014 17:26:12 -0000 Received: from athena.apache.org (HELO athena.apache.org) (140.211.11.136) by apache.org (qpsmtpd/0.29) with ESMTP; Mon, 28 Jul 2014 17:26:12 +0000 X-ASF-Spam-Status: No, hits=1.5 required=5.0 tests=HTML_MESSAGE,RCVD_IN_DNSWL_LOW,SPF_PASS X-Spam-Check-By: apache.org Received-SPF: pass (athena.apache.org: domain of colinkuo.tw@gmail.com designates 209.85.220.170 as permitted sender) Received: from [209.85.220.170] (HELO mail-vc0-f170.google.com) (209.85.220.170) by apache.org (qpsmtpd/0.29) with ESMTP; Mon, 28 Jul 2014 17:26:08 +0000 Received: by mail-vc0-f170.google.com with SMTP id lf12so11921082vcb.1 for ; Mon, 28 Jul 2014 10:25:47 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20120113; h=mime-version:in-reply-to:references:from:date:message-id:subject:to :content-type; bh=h1TXbn4Qv/IlSyiWKddbBz6xVbzw689QimUZZ4cenOs=; b=mxZpguAiwodKhjME1ACCGF0Sex88g6z5UsD7sdyKxE/+nebKe9ziKBmNebjXqkicJp FUPL1OUv97ST+KwCQCl6/43jCZWnUNsHeYtV3z3KnYVa4metTx1v3DupCzvZKFJKV96F lvOtUEWH6YkfYVooxGkuZfvMig9/LEV87I4za3QQ4Yn+wKB0YDxjgAqHzMch3nH/9aL2 jZjzvM/FIe659S4iqr676La50hnfLU0/rsu1e7GZlVbTb54cBDfwS02I07e8Bacosnq9 8ByRnLisW6Sob72nIcjv3fMtJk5ZXuyQB6WdVfQAglWMzq+YVi1ZN4ZgJFgYflzQAYuw j/kQ== X-Received: by 10.52.116.194 with SMTP id jy2mr39724196vdb.39.1406568347490; Mon, 28 Jul 2014 10:25:47 -0700 (PDT) MIME-Version: 1.0 Received: by 10.220.10.6 with HTTP; Mon, 28 Jul 2014 10:25:07 -0700 (PDT) In-Reply-To: References: From: Colin Kuo Date: Tue, 29 Jul 2014 01:25:07 +0800 Message-ID: Subject: Re: unable to load data using sstableloader To: user@cassandra.apache.org Content-Type: multipart/alternative; boundary=bcaec547cbb7b4627504ff4436f8 X-Virus-Checked: Checked by ClamAV on apache.org --bcaec547cbb7b4627504ff4436f8 Content-Type: text/plain; charset=UTF-8 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 > > --bcaec547cbb7b4627504ff4436f8 Content-Type: text/html; charset=UTF-8 Content-Transfer-Encoding: quoted-printable
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.



On Mon,= Jul 28, 2014 at 7:28 PM, Akshay Ballarpure <akshay.ballarpure@t= cs.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 =C2=A0 16 Jul 28 16:55 Test-Data-jb-1-Filter.db
-rw-r--r-- 1 root root =C2=A0300 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 =C2=A0 =C2=A08 Jul 28 16:55 Test-Data-jb-1-CRC.db
-rw-r--r-- 1 root root =C2=A0 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 =C2=A0 79 Jul 28 16:55 Test-Data-jb-1-TOC.txt


[root@CSL-simulation conf]# ../bin/sstableloa= der -d localhost /root/Akshay/Cassandra/apache-cassandra-2.0.8/conf/keyspace/co= l/ --debug
Could not retrieve endpoint ranges:
InvalidRequestException(why= :No such keyspace: keyspace)
java.lang.RuntimeException: Could not retrieve endpoint ranges:
=C2=A0 =C2=A0 =C2=A0 =C2=A0 at org.apache.cas= sandra.tools.BulkLoader$ExternalClient.init(BulkLoader.java:259)
=C2=A0 =C2=A0 =C2=A0 =C2=A0 at org.apache.cas= sandra.io.sstable.SSTableLoader.stream(SSTableLoader.java:149)
=C2=A0 =C2=A0 =C2=A0 =C2=A0 at org.apache.cas= sandra.tools.BulkLoader.main(BulkLoader.java:85)
Caused by: InvalidRequestException(why:No such keyspace: keyspace)
=C2=A0 =C2=A0 =C2=A0 =C2=A0 at org.apache.cas= sandra.thrift.Cassandra$describe_ring_result$describe_ring_resultStandardSc= heme.read(Cassandra.java:34055)
=C2=A0 =C2=A0 =C2=A0 =C2=A0 at org.apache.cas= sandra.thrift.Cassandra$describe_ring_result$describe_ring_resultStandardSc= heme.read(Cassandra.java:34022)
=C2=A0 =C2=A0 =C2=A0 =C2=A0 at org.apache.cas= sandra.thrift.Cassandra$describe_ring_result.read(Cassandra.java:33964)
=C2=A0 =C2=A0 =C2=A0 =C2=A0 at org.apache.thr= ift.TServiceClient.receiveBase(TServiceClient.java:78)
=C2=A0 =C2=A0 =C2=A0 =C2=A0 at org.apache.cas= sandra.thrift.Cassandra$Client.recv_describe_ring(Cassandra.java:1251)
=C2=A0 =C2=A0 =C2=A0 =C2=A0 at org.apache.cas= sandra.thrift.Cassandra$Client.describe_ring(Cassandra.java:1238)
=C2=A0 =C2=A0 =C2=A0 =C2=A0 at org.apache.cas= sandra.tools.BulkLoader$ExternalClient.init(BulkLoader.java:235)
=C2=A0 =C2=A0 =C2=A0 =C2=A0 ... 2 more


Thanks & Regards
Akshay Ghanshyam Ballarpure
Tata Consultancy Services
Cell:- 9985084075
Mailto: aksh= ay.ballarpure@tcs.com
Website: http://www.tcs.com ____________________________________________
Experience certainty. =C2=A0 =C2=A0 =C2=A0 =C2=A0IT Services
=C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0Business Solutions
=C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0Consulting
____________________________________________

=3D=3D=3D=3D=3D-----= =3D=3D=3D=3D=3D-----=3D=3D=3D=3D=3D
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


--bcaec547cbb7b4627504ff4436f8--