DataStax Support Forums » Tag: cassandra-cli

DataStax Support Forums » Tag: cassandra-cli - Recent Posts http://www.datastax.com/support-forums/tags/cassandra-cli Software, Support, and Training for Apache Cassandra en-US Thu, 20 Jun 2013 01:06:13 +0000 http://bbpress.org/?v=1.0.3 <![CDATA[Search]]> q http://www.datastax.com/support-forums/search.php rob4you on "Nodes were Unavailable" http://www.datastax.com/support-forums/topic/nodes-were-unavailable/page/2#post-7242 Wed, 31 Oct 2012 00:09:58 +0000 rob4you 7242@http://www.datastax.com/support-forums/ The problem doesn't seem to have been fixed. Look at this snippet: > CREATE KEYSPACE a WITH strategy_class = 'org.apache.cassandra.locator.SimpleStrategy' AND strategy_options:replication_factor='1'; > DESCRIBE KEYSPACE a; CREATE KEYSPACE a WITH strategy_class = 'SimpleStrategy' AND strategy_options:replication_factor='1'; > USE a; > CREATE TABLE t (id int PRIMARY KEY, col1 text); > SELECT * FROM t: Unable to complete request: one or more nodes were unavailable. > SHOW VERSION; [cqlsh 2.2.0 | Cassandra 1.1.5 | CQL spec 3.0.0 | Thrift protocol 19.32.0] I'm using DSE, latest release. thobbs on "Nodes were Unavailable" http://www.datastax.com/support-forums/topic/nodes-were-unavailable/page/2#post-5799 Fri, 10 Aug 2012 19:11:28 +0000 thobbs 5799@http://www.datastax.com/support-forums/ Thanks for the post! I sent a note to the docs team, so that should be fixed shortly. tstarbow on "Nodes were Unavailable" http://www.datastax.com/support-forums/topic/nodes-were-unavailable/page/2#post-5688 Thu, 09 Aug 2012 17:48:53 +0000 tstarbow 5688@http://www.datastax.com/support-forums/ It is pretty annoying that the "Getting Started Using the Cassandra CLI" for Cassandra 1.0 (<a href="http://www.datastax.com/docs/1.0/dml/using_cql" rel="nofollow">http://www.datastax.com/docs/1.0/dml/using_cql</a>) code doesn't work as written. It looks like it has been fixed on 1.1 docs: CREATE KEYSPACE twissandra WITH strategy_class = 'org.apache.cassandra.locator.SimpleStrategy' AND strategy_options:replication_factor='1'; thepaul on "CLI v/s CQL" http://www.datastax.com/support-forums/topic/cli-vs-cql#post-1916 Tue, 15 May 2012 19:49:30 +0000 thepaul 1916@http://www.datastax.com/support-forums/ By CLI, I think you mean cassandra-cli, and by CQL, I think you mean cqlsh. They have a lot of differences. Cqlsh is intended to be a command-line tool which natively speaks the CQL language. The CQL language is intended to be the main way to interface with Cassandra going forward, although the Thrift interface will be supported for some time still. The CQL language can be used in your application code using drivers (existing for Python, Java, PHP, node.js, Ruby, and more), so you can use the same syntax in your code and in the command-line inspection tool. The cassandra-cli tool is lower-level than Cqlsh, and uses the Thrift interface instead of CQL. It has its own special syntax for creating columnfamilies and keyspaces, for inserting data, and for making queries. You'll find that while it's not as user-friendly, there are a few things it can still do that Cqlsh can't, like show column timestamps and show the storage engine rows underlying cql3 composite columnfamilies, as opposed to the transformed CQL rows. But for the most part, new users should probably be using the CQL interface and the Cqlsh tool. Anonymous on "CLI v/s CQL" http://www.datastax.com/support-forums/topic/cli-vs-cql#post-1915 Tue, 15 May 2012 19:36:47 +0000 Anonymous 1915@http://www.datastax.com/support-forums/ What are the exact differences between CLI and CQL , i.e. Do the CLI and CQL support all featuresets offered by cassandra ? Is there a difference between creating a keyspace in CLI v/s CQL ? Similarly is there a difference between creating a columnfamily in CLI v/s CQL ? Are objects created with one tool useable/operable with the another ? Going forward what's the future of CLI and CQL ? Will they be both maintained and developed in parallel, or will CQL be the eventual winner ? For a new development, what is the recommendation, use CLI or CQL ? and why ? Anonymous on "Nodes were Unavailable" http://www.datastax.com/support-forums/topic/nodes-were-unavailable/page/2#post-765 Thu, 24 Nov 2011 07:25:41 +0000 Anonymous 765@http://www.datastax.com/support-forums/ This is the link I followed : <a href="http://www.datastax.com/docs/1.0/dml/using_cql" rel="nofollow">http://www.datastax.com/docs/1.0/dml/using_cql</a>. Here there is nothing like replcaition factot in the command. Thanks, Raju. zznate on "Nodes were Unavailable" http://www.datastax.com/support-forums/topic/nodes-were-unavailable/page/2#post-758 Wed, 23 Nov 2011 17:22:46 +0000 zznate 758@http://www.datastax.com/support-forums/ Can you tell me where you found that Keyspace creation script? It looks like you created the keyspace with a replication_factor (3) which is un-achievable on a single node. Re-create the keyspace similar to the following: CREATE KEYSPACE twissandra with placement_strategy = 'org.apache.cassandra.locator.SimpleStrategy' and strategy_options = [{replication_factor:1}]; Anonymous on "Nodes were Unavailable" http://www.datastax.com/support-forums/topic/nodes-were-unavailable/page/2#post-756 Wed, 23 Nov 2011 16:55:20 +0000 Anonymous 756@http://www.datastax.com/support-forums/ Hi, I had run in debug mode. Please find the exception. ############### [default@twissandra] SET users['bobby']['state']='tx'; null UnavailableException() at org.apache.cassandra.thrift.Cassandra$insert_result.read(Cassandra.java:15206) at org.apache.cassandra.thrift.Cassandra$Client.recv_insert(Cassandra.java:858) at org.apache.cassandra.thrift.Cassandra$Client.insert(Cassandra.java:830) at org.apache.cassandra.cli.CliClient.executeSet(CliClient.java:892) at org.apache.cassandra.cli.CliClient.executeCLIStatement(CliClient.java:216) at org.apache.cassandra.cli.CliMain.processStatementInteractive(CliMain.java:222) at org.apache.cassandra.cli.CliMain.main(CliMain.java:350) ############ Thanks, Raju Anonymous on "Nodes were Unavailable" http://www.datastax.com/support-forums/topic/nodes-were-unavailable/page/2#post-755 Wed, 23 Nov 2011 16:51:08 +0000 Anonymous 755@http://www.datastax.com/support-forums/ Hi, Please find the describe twissandra -- [default@twissandra] describe twissandra; ############## Keyspace: twissandra: Replication Strategy: org.apache.cassandra.locator.NetworkTopologyStrategy Durable Writes: true Options: [DC1:3] Column Families: ColumnFamily: users Key Validation Class: org.apache.cassandra.db.marshal.UTF8Type Default column value validator: org.apache.cassandra.db.marshal.UTF8Type Columns sorted by: org.apache.cassandra.db.marshal.UTF8Type Row cache size / save period in seconds / keys to save : 0.0/0/all Key cache size / save period in seconds: 200000.0/14400 GC grace seconds: 864000 Compaction min/max thresholds: 4/32 Read repair chance: 0.1 Replicate on write: true Built indexes: [] Column Metadata: Column Name: birth_year Validation Class: org.apache.cassandra.db.marshal.LongType Column Name: gender Validation Class: org.apache.cassandra.db.marshal.UTF8Type Column Name: password Validation Class: org.apache.cassandra.db.marshal.UTF8Type Column Name: session_token Validation Class: org.apache.cassandra.db.marshal.UTF8Type Column Name: state Validation Class: org.apache.cassandra.db.marshal.UTF8Type Compaction Strategy: org.apache.cassandra.db.compaction.SizeTieredCompactionStrategy ############## Thanks, Raju. zznate on "Nodes were Unavailable" http://www.datastax.com/support-forums/topic/nodes-were-unavailable#post-754 Wed, 23 Nov 2011 16:05:20 +0000 zznate 754@http://www.datastax.com/support-forums/ The 'null' implies there was an exception swallowed on the operations. When you start the cli, use the option --debug this will give you more information. Can you also post the output of 'describe keyspace Twissandra' to verify that the secondary index was created correctly? Anonymous on "Nodes were Unavailable" http://www.datastax.com/support-forums/topic/nodes-were-unavailable#post-753 Wed, 23 Nov 2011 05:16:17 +0000 Anonymous 753@http://www.datastax.com/support-forums/ yeah, i have tried thru cli. It is showing the keyspace twissandra. I used the command to insert "SET users['bobby']['state']='tx';". It returned "null". Please let me know whether I used the command properly or not. I used the same schema that is mentioned in the tutorial. Also please let me know why this is not happening in CQLSH. I had run cli keyspaces demo etc as shown in the tutorial. It worked properly. Anonymous on "Unable to insert new column into some rows" http://www.datastax.com/support-forums/topic/unable-to-insert-new-column-into-some-rows#post-747 Wed, 23 Nov 2011 01:50:36 +0000 Anonymous 747@http://www.datastax.com/support-forums/ They all also particularly liked that the dresses were flattering on their stomachs. zznate on "Nodes were Unavailable" http://www.datastax.com/support-forums/topic/nodes-were-unavailable#post-731 Tue, 22 Nov 2011 16:27:38 +0000 zznate 731@http://www.datastax.com/support-forums/ Try connecting to the keyspace through cassandra-cli program to verify that the keyspace and column family are both visible: <a href="http://www.datastax.com/docs/1.0/dml/using_cli" rel="nofollow">http://www.datastax.com/docs/1.0/dml/using_cli</a> Anonymous on "Nodes were Unavailable" http://www.datastax.com/support-forums/topic/nodes-were-unavailable#post-730 Tue, 22 Nov 2011 10:51:19 +0000 Anonymous 730@http://www.datastax.com/support-forums/ Hi, I am newbie to cassandra. I am using MAC machine. I am following Cassandra tutorial, able to create keyspace Twissandra, column family 'Users'. I am not able to Insert into user family. The CQLSH command is saying "Unable to complete request: one or more nodes were unavailable.". I have changed the Cassandra data path thru SED command .Able to see the name 'twissandra' keyspace under "casssandra-data" folder. it has 755 permissions too. .please help me. Thanks, Raju. zznate on "Unable to insert new column into some rows" http://www.datastax.com/support-forums/topic/unable-to-insert-new-column-into-some-rows#post-699 Thu, 17 Nov 2011 16:00:27 +0000 zznate 699@http://www.datastax.com/support-forums/ Good to hear. Let us know if you have any more questions.