DataStax Support Forums » User Favorites: alexliu

DataStax Support Forums » User Favorites: alexliu alexliu Software, Support, and Training for Apache Cassandra en-US Sun, 19 May 2013 16:03:25 +0000 http://bbpress.org/?v=1.0.3 <![CDATA[Search]]> q http://www.datastax.com/support-forums/search.php kitty on "sstableloader error" http://www.datastax.com/support-forums/topic/sstableloader-error#post-11223 Sun, 19 May 2013 06:15:54 +0000 kitty 11223@http://www.datastax.com/support-forums/ Hi I am also using dse-3.0.1 In the above example given at link : <a href="http://www.datastax.com/dev/blog/bulk-loading" rel="nofollow">http://www.datastax.com/dev/blog/bulk-loading</a>, added partitioner(random partitioner) in constructer argument list, and followed all the steps.Code compiles without errors but on running the script, I keep getting error below: Error instantiating snitch class ‘com.datastax.bdp.snitch.DseDelegateSnitch’. Fatal configuration error; unable to start server. See log for stacktrace. I am executing it from location /usr/lib/datastax/dse-3.0.1/resources/cassandra This is my script file #!/bin/sh # paths to the cassandra source tree, cassandra jar and java CASSANDRA_HOME=”.” CASSANDRA_JAR=”$CASSANDRA_HOME/../../lib/dse-3.0.1.jar” JAVA=<code>which java</code> # 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 “/home/myuser/cassandra_artifacts/demodata.csv” Is there anything taht I have missed out. Can anyone pls help me identify the issue??? upant on "sstableloader error" http://www.datastax.com/support-forums/topic/sstableloader-error#post-11186 Fri, 17 May 2013 16:03:03 +0000 upant 11186@http://www.datastax.com/support-forums/ This is what I have in my run script: # paths to the cassandra source tree, cassandra jar and java CASSANDRA_HOME="/usr/share/dse/" CASSANDRA_JAR="$CASSANDRA_HOME/dse.jar" JAVA=<code>which java</code> # Java classpath. Must include: # - directory of DataImportExample # - directory with cassandra/log4j config files # - cassandra jar # - cassandra depencies jar CLASSPATH=".:/etc/dse/cassandra/:/etc/dse/cassandra/cassandra.yaml:/etc/dse/cassandra/log4j-tools.properties:$CASSANDRA_JAR" for jar in $CASSANDRA_HOME/cassandra/lib/*.jar; do CLASSPATH=$CLASSPATH:$jar done $JAVA -ea -cp $CLASSPATH -Xmx256M \ -Dlog4j.configuration=log4j-tools.properties \ DataImportExample "$@" alexliu on "sstableloader error" http://www.datastax.com/support-forums/topic/sstableloader-error#post-11156 Thu, 16 May 2013 19:37:15 +0000 alexliu 11156@http://www.datastax.com/support-forums/ You may need include the <DSE_HOME>/lib/<dse.jar> in your class path, also make sure the resources/cassandra/conf/cassandra.yaml is in the front of class path. upant on "sstableloader error" http://www.datastax.com/support-forums/topic/sstableloader-error#post-11025 Tue, 14 May 2013 17:29:28 +0000 upant 11025@http://www.datastax.com/support-forums/ - Installed DSE using RPM package. - Created keyspace and column families as mentioned in the example and was able to write/read data using CLI. - Created a Java class(DataImportExample) using example code at <a href="http://www.datastax.com/wp-content/uploads/2011/08/DataImportExample.java" rel="nofollow">http://www.datastax.com/wp-content/uploads/2011/08/DataImportExample.java</a>. - While compiling the class, I got an error. The code listed in the example doesn't have partitioner argument in SSTableSimpleUnsortedWriter constructor. So, passing RandomPartitioner the constructor fixed the error. - Executed the class (DataImportExample) and I got following error: Error instantiating snitch class 'com.datastax.bdp.snitch.DseDelegateSnitch'. Fatal configuration error; unable to start server. - Location of the Java class is /home/myuser/workspace/ - I compiled and executed the class from this folder. alexliu on "sstableloader error" http://www.datastax.com/support-forums/topic/sstableloader-error#post-10982 Mon, 13 May 2013 22:07:38 +0000 alexliu 10982@http://www.datastax.com/support-forums/ It should work, which directory are you in and what command did you issue? upant on "sstableloader error" http://www.datastax.com/support-forums/topic/sstableloader-error#post-10719 Tue, 07 May 2013 20:59:47 +0000 upant 10719@http://www.datastax.com/support-forums/ Hi, I am running DSE 3.0 in CentOS 6.x. I followed installation instructions at <a href="http://www.datastax.com/docs/datastax_enterprise3.0/install/install_rpm_pkg" rel="nofollow">http://www.datastax.com/docs/datastax_enterprise3.0/install/install_rpm_pkg</a>. I can create column families, insert data and retrieve data using CLI. However, whenI tried to run sstableloader (<a href="http://www.datastax.com/dev/blog/bulk-loading)" rel="nofollow">http://www.datastax.com/dev/blog/bulk-loading)</a>, I got following error: Error instantiating snitch class 'com.datastax.bdp.snitch.DseDelegateSnitch'. Fatal configuration error; unable to start server. I tried the same code in Apache Cassandra (not DataStax distribution) and I was able to run the loader without any issue or any additional configuration. Has anybody tried sstableloader in DSE? Thanks, Uddhab Jack Krupansky on "Solr mapping problem" http://www.datastax.com/support-forums/topic/solr-mapping-problem/page/2#post-10627 Sun, 05 May 2013 15:43:23 +0000 Jack Krupansky 10627@http://www.datastax.com/support-forums/ Generally, it is best to create a Solr-searchable column family from scratch using the Solr HTTP API as shown in the documentation. Then, DSE will assure that the column family is Solr-compatible. Jack Krupansky on "DSE 3.0 with Solr giving 404 error" http://www.datastax.com/support-forums/topic/dse-30-with-solr-giving-404-error#post-10625 Sun, 05 May 2013 15:31:06 +0000 Jack Krupansky 10625@http://www.datastax.com/support-forums/ I don't see any way that your issue could be related to this particular issue, the 404 error. FWIW, generally you should create a "Solr" column family from scratch using the Solr HTTP API. There is a known issue with trying to "Solarize" an existing Cassandra column family. Once you have created the column family using Solr, you can then add data with either the Solr or Cassandra APIs. rahul on "DSE 3.0 with Solr giving 404 error" http://www.datastax.com/support-forums/topic/dse-30-with-solr-giving-404-error#post-10596 Sat, 04 May 2013 06:11:12 +0000 rahul 10596@http://www.datastax.com/support-forums/ Here i am using DSE3.0.1. I am creating a dynamic composite column family through cassandra-cli. [default@one] CREATE COLUMN FAMILY XYZ WITH comparator = UTF8Type AND key_validation_class=UTF8Type AND default_validation_class = UTF8Type; But at indexing :-- curl "http://localhost:8983/solr/admin/cores?CREATE&name=one.XYZ" Solr gives following error:-- <html><head><title>Apache Tomcat/6.0.32 - Error report</title><style></style> </head><body><h1>HTTP Status 500 - </h1><HR size="1" noshade="noshade">type Status reportmessage description The server encountered an internal error () that prevented it from fulfilling this request.<HR size="1" noshade="noshade"><h3>Apache Tomcat/6.0.32</h3></body></html> Where am i missing or can i search solr query from cassandra database without indexing them? Please help me. I have badly need it. It'll be very great-full for you. Thank you rahul on "Solr mapping problem" http://www.datastax.com/support-forums/topic/solr-mapping-problem/page/2#post-10593 Sat, 04 May 2013 05:04:02 +0000 rahul 10593@http://www.datastax.com/support-forums/ Here i am using DSE3.0.1. I am creating a composite column family through cassandra-cli.But at indexing solr gives error that "Solr indexes are not supported on ColumnFamilies with non-string comparators". create column family BenchmarkColumnFamily with comparator = 'CompositeType(UTF8Type,UTF8Type)' AND key_validation_class=DateType AND default_validation_class=UTF8Type AND column_metadata = [ {column_name: XYZ, validation_class: UTF8Type} ]; Where am i missing or can i search solr query from cassandra database without indexing them? Please help me. I have badly need it. It'll be very great-full for you. andy on "newbie: trouble with cql containers and secondary index on composite keys" http://www.datastax.com/support-forums/topic/newbie-trouble-with-cql-containers-and-secondary-index-on-composite-keys#post-10588 Fri, 03 May 2013 17:43:58 +0000 andy 10588@http://www.datastax.com/support-forums/ Hi alexliu and sam alexliu's example did not work. I think Sam's explanation is correct. I look forward to version 3.1 Andy sam on "newbie: trouble with cql containers and secondary index on composite keys" http://www.datastax.com/support-forums/topic/newbie-trouble-with-cql-containers-and-secondary-index-on-composite-keys#post-10585 Fri, 03 May 2013 07:50:24 +0000 sam 10585@http://www.datastax.com/support-forums/ The music application example in the blog post uses the final version of CQL 3.0, which is only supported in Cassandra version 1.2 or greater. The current release of DataStax Enterprise (3.0.1) ships with Cassandra 1.1, which supports CQL 3.0-beta. Unfortunately, there are some differences between the two CQL versions which means that for the moment, the example schema can't be created on DSE. DSE 3.1 will include Cassandra 1.2 & this is currently in development and we're aiming to release late in Q2. alexliu on "newbie: trouble with cql containers and secondary index on composite keys" http://www.datastax.com/support-forums/topic/newbie-trouble-with-cql-containers-and-secondary-index-on-composite-keys#post-10580 Fri, 03 May 2013 00:51:11 +0000 alexliu 10580@http://www.datastax.com/support-forums/ The following is working for me MacBook-Pro:cassandra alex$ bin/cqlsh -3 Connected to Test Cluster at localhost:9160. [cqlsh 2.3.0 | Cassandra 1.2.2-DSE-SNAPSHOT | CQL spec 3.0.0 | Thrift protocol 19.35.0] Use HELP for help. cqlsh> use cql3_worldcount4 ... ; cqlsh:cql3_worldcount4> create table a (m int, n int, o int, primary key(m)); cqlsh:cql3_worldcount4> alter table a add tags set<text>; cqlsh:cql3_worldcount4> create index foo on a(o); I guess that you are not using the latest cql version. You can try my example, if it doesn't work, then you may need wait until DSE next release. andy on "newbie: trouble with cql containers and secondary index on composite keys" http://www.datastax.com/support-forums/topic/newbie-trouble-with-cql-containers-and-secondary-index-on-composite-keys#post-10575 Thu, 02 May 2013 22:29:20 +0000 andy 10575@http://www.datastax.com/support-forums/ Hi I am new to cassandra datastax enterprise. I am having a lot of trouble with the sample music app in the documentation. <a href="http://www.datastax.com/docs/1.2/ddl/table#compound-keys-and-clustering" rel="nofollow">http://www.datastax.com/docs/1.2/ddl/table#compound-keys-and-clustering</a> I am not able to create an index on the playlists table. Here is how I start cql on my mac $ ~/cassandra/dataStax/dse-3.0.1/bin/cqlsh --version cqlsh 2.2.0 $ dataStax/dse-3.0.1/bin/cqlsh --cql3 Also the container types do not seem to work. cqlsh:aedwip> ALTER TABLE songs ADD tags set<text>; Bad Request: line 1:27 no viable alternative at input 'set' Any idea what I am doing wrong? thanks in advance Andy CREATE TABLE playlists ( id uuid, song_id uuid, album text, artist text, title text, PRIMARY KEY (id, song_id) ) WITH comment='' AND caching='KEYS_ONLY' AND read_repair_chance=0.100000 AND gc_grace_seconds=864000 AND replicate_on_write='true' AND compaction_strategy_class='SizeTieredCompactionStrategy' AND compression_parameters:sstable_compression='SnappyCompressor'; cqlsh:aedwip> CREATE INDEX ON playlists(artist); Bad Request: Secondary indexes are not (yet) supported on tables with composite PRIMARY KEY Perhaps you meant to use CQL 2? Try using the -2 option when starting cqlsh. cqlsh:aedwip> Abhijit on "Datastax API- CQL Binary protocol example" http://www.datastax.com/support-forums/topic/datastax-api-cql-binary-protocol-example#post-10564 Thu, 02 May 2013 09:30:58 +0000 Abhijit 10564@http://www.datastax.com/support-forums/ He is talking about DSE v 3.0.1 -Abhijit