Support Forums : DataStax

DataStax Support Forums » DataStax Enterprise

Error: csv using sstableloader

(9 posts) (2 voices)

Started 10 months ago by datastaxtesting
Latest reply from Piotr Kołaczkowski
This topic is not resolved

Tags:

datastaxtesting
Member

I am trying to execute DataImportExample.java but it gives following error:
(NOTE: I have generated the DataImportExample.class and DataImportExample$CsvEntry.class by compiling :

[root@NJVC-BAO-DEV-DB-1 cassandra]# ./csvtoCassandra.sh test.csv
SLF4J: Failed to load class "org.slf4j.impl.StaticLoggerBinder".
SLF4J: Defaulting to no-operation (NOP) logger implementation
SLF4J: See http://www.slf4j.org/codes.html#StaticLoggerBinder for further details.
Unable to find snitch class 'com.datastax.bdp.snitch.DseDelegateSnitch'
Fatal configuration error; unable to start server. See log for stacktrace.

DEBUG>> I checked cassandra.yaml endpoint_snitch is set to com.datastax.bdp.snitch.DseDelegateSnitch

My csvtoCassandra.sh looks like:

#!/bin/sh

# paths to the cassandra source tree, cassandra jar and java
CASSANDRA_HOME="."
CASSANDRA_JAR="$CASSANDRA_HOME/lib/cassandra-all-1.0.10.jar"
JAVA=which java

# Java classpath. Must include:
# - directory of DataImportExample
# - directory with cassandra/log4j config files
# - cassandra jar
# - cassandra depencies jar
CLASSPATH=".:$CASSANDRA_HOME/conf:$CASSANDRA_JAR"

for jar in $CASSANDRA_HOME/lib/*.jar; do
CLASSPATH=$CLASSPATH:$jar
done

$JAVA -ea -cp $CLASSPATH -Xmx256M \
-Dlog4j.configuration=log4j-tools.properties \
DataImportExample "$@"

Posted 10 months ago #
Piotr Kołaczkowski
Administrator

com.datastax.bdp.snitch.DseDelegateSnitch is located in the dse-*.jar. You seem to not have it on the classpath.

Posted 10 months ago #
datastaxtesting
Member

Thanks pkolaczk!!

Now I get the following error while executing:
[root@NJVC-BAO-DEV-DB-1 cassandra]# ./csvtoCassandra.sh test.csv SLF4J: Failed to load class "org.slf4j.impl.StaticLoggerBinder".
SLF4J: Defaulting to no-operation (NOP) logger implementation
SLF4J: See http://www.slf4j.org/codes.html#StaticLoggerBinder for further details.
Exception in thread "main" java.lang.IllegalArgumentException: Invalid UUID string: # uuid
at java.util.UUID.fromString(UUID.java:204)
at DataImportExample$CsvEntry.parse(DataImportExample.java:101)
at DataImportExample.main(DataImportExample.java:59)

My test.csv file is:

# uuid, firstname, lastname, password, age, email

58, Alice, Smith, asmi1975, 32, alice.smith@mail.com
48, Bob, Miller, af3!df8, 28, bob.miller@mail.com
17, Carol, White, cw1845?, 49, c.white@mail.com

Posted 10 months ago #
Piotr Kołaczkowski
Administrator

You should provide UUID in canonical form which is described here:
http://en.wikipedia.org/wiki/Universally_unique_identifier

In Java, you can use UUID.randomUUID to generate uuids for your rows.

Posted 10 months ago #
datastaxtesting
Member

Thanks Now I am trying to execute sstableloader but i am getting the following error:

[root@NJVC-BAO-DEV-DB-1 cassandra]# bin/sstableloader -v ./Demo/ SLF4J: Failed to load class "org.slf4j.impl.StaticLoggerBinder".
SLF4J: Defaulting to no-operation (NOP) logger implementation
SLF4J: See http://www.slf4j.org/codes.html#StaticLoggerBinder for further details.
Cannot locate dse.yaml
Fatal configuration error; unable to start server. See log for stacktrace.

I tried to give the classpath of dse.yaml using -cp but it gives error.

Posted 10 months ago #
Piotr Kołaczkowski
Administrator

Can you post a full log with stacktrace?

Try adding -Ddse.config=<URL to your dse.yaml> system property.

Posted 10 months ago #
datastaxtesting
Member

Here is the complete scenario that I am trying to execute:

I made a cluster of 2 nodes: 10.3.11.90 (cassandra running) and 10.3.11.91(analytics running)
Result:
[root@NJVC-BAO-DEV-DB-1 cassandra]# /usr/local/datastax-2.1/dse-2.1/bin/dsetool ring
Address DC Rack Workload Status State Load Owns Token
85070591730234615865843651857942052864
10.3.11.90 DC1 RAC1 Cassandra Up Normal 21.81 MB 50.00% 0
10.3.11.91 DC1 RAC2 Analytics(tt) Up Normal 24.35 MB 50.00% 85070591

Now in 10.3.11.90 .../resources/cassandra folder I am able to create the Demo folder using ./csvto Cassandra.sh test.csv

Now I am trying to execute inside cassandra folder in 10.3.11.90 server itself: bin/sstableloader Demo/....I get the following error(note I changed the storage_port in cassandra.yaml to 7070 as I was getting the error; port is being used):

[root@NJVC-BAO-DEV-DB-1 cassandra]# bin/sstableloader Demo/
SLF4J: Failed to load class "org.slf4j.impl.StaticLoggerBinder".
SLF4J: Defaulting to no-operation (NOP) logger implementation
SLF4J: See http://www.slf4j.org/codes.html#StaticLoggerBinder for further details.
Starting client (and waiting 30 seconds for gossip) ...
java.lang.IllegalStateException: Cannot load any sstable, no live member found in the cluster

Although 10.3.11.90 is live than why I am getting this error?

Posted 10 months ago #
datastaxtesting
Member

Another way I tried I created Demo1 inside dse-data/data folder in 10.3.11.90...and executed <path to sstableloader> Demo1

I get the following error:

[root@NJVC-BAO-DEV-DB-1 cassandra]# bin/sstableloader /usr/local/datastax-2.1/dse-2.1/dse-data/data/Demo1/
SLF4J: Failed to load class "org.slf4j.impl.StaticLoggerBinder".
SLF4J: Defaulting to no-operation (NOP) logger implementation
SLF4J: See http://www.slf4j.org/codes.html#StaticLoggerBinder for further details.
Starting client (and waiting 30 seconds for gossip) ...
org.apache.cassandra.config.ConfigurationException: /10.3.11.90:7000 is in use by another process. Change listen_address:storage_port in cassandra.yaml to values that do not conflict with other services
[root@NJVC-BAO-DEV-DB-1 cassandra]#

Posted 10 months ago #
Piotr Kołaczkowski
Administrator

How many DSE processes have you started on that machine? Are you sure some previous instance is not running?

Posted 10 months ago #

RSS feed for this topic

Reply

You must log in to post.