DataStax Support Forums » Tag: cqlsh

DataStax Support Forums » Tag: cqlsh - Recent Posts http://www.datastax.com/support-forums/tags/cqlsh Software, Support, and Training for Apache Cassandra en-US Wed, 19 Jun 2013 05:55:55 +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 ? purblind on "integers inserted with cqlsh are not the same as integers inserted with hector" http://www.datastax.com/support-forums/topic/integers-inserted-with-cqlsh-are-not-the-same-as-integers-inserted-with-hector#post-1079 Wed, 01 Feb 2012 16:07:53 +0000 purblind 1079@http://www.datastax.com/support-forums/ description: setting integer column values with cqlsh does not return the same values when read back with Hector; cassandra version 1.0.7 hector version 1.0-2 mycf: 1-row, multi-column CF with integer values: ColumnFamily: mycf Key Validation Class: org.apache.cassandra.db.marshal.AsciiType Default column value validator: org.apache.cassandra.db.marshal.IntegerType Columns sorted by: org.apache.cassandra.db.marshal.UTF8Type Row cache size / save period in seconds / keys to save : 0.0/0/all Row Cache Provider: org.apache.cassandra.cache.SerializingCacheProvider Key cache size / save period in seconds: 200000.0/14400 GC grace seconds: 864000 Compaction min/max thresholds: 4/32 Read repair chance: 1.0 Replicate on write: true Bloom Filter FP chance: default Built indexes: [] cqlsh: update mycf set alt = 81001 where KEY = 'alt'; java: public void write(final String alt, final int hash) { final Mutator<String> mut = HFactory.createMutator( HFactory.createKeyspace("test", cluster), StringSerializer.get()); mut.addInsertion("alt", "mycf", HFactory.createColumn(alt, hash, StringSerializer.get(), IntegerSerializer.get())); mut.execute(); } public int read(final String alt) { final RangeSlicesQuery<String, String, Integer> query = HFactory .createRangeSlicesQuery( HFactory.createKeyspace("test", cluster), StringSerializer.get(), StringSerializer.get(), IntegerSerializer.get()).setColumnFamily("mycf") .setRange(null, null, false, 13).setColumnNames(alt); final ArrayList<Byte> arrayList = new ArrayList<Byte>(); Integer result = null; for (final Row<String, String, Integer> item : query.setRowCount(10) .execute().get().getList()) { final HColumn<String, Integer> i = item.getColumnSlice() .getColumnByName(alt); log.debug(Arrays.toString(i.getValueBytes().array())); result = i.getValue(); } return result; } writing an integer with hector, and reading with hector: [-128, 1, 0, 2, 0, 0, 0, 16, 103, 101, 116, 95, 114, 97, 110, 103, 101, 95, 115, 108, 105, 99, 101, 115, 0, 0, 0, 5, 15, 0, 0, 12, 0, 0, 0, 1, 11, 0, 1, 0, 0, 0, 3, 97, 108, 116, 15, 0, 2, 12, 0, 0, 0, 1, 12, 0, 1, 11, 0, 1, 0, 0, 0, 6, 68, 69, 78, 73, 83, 50, 11, 0, 2, 0, 0, 0, 4, 0, 1, 60, 105, 10, 0, 3, 0, 4, -73, -24, -127, -39, 107, -128, 0, 0, 0, 0] writing an integer with cqlsh, reading with hector: [-128, 1, 0, 2, 0, 0, 0, 16, 103, 101, 116, 95, 114, 97, 110, 103, 101, 95, 115, 108, 105, 99, 101, 115, 0, 0, 0, 3, 15, 0, 0, 12, 0, 0, 0, 1, 11, 0, 1, 0, 0, 0, 3, 97, 108, 116, 15, 0, 2, 12, 0, 0, 0, 1, 12, 0, 1, 11, 0, 1, 0, 0, 0, 6, 68, 69, 78, 73, 83, 50, 11, 0, 2, 0, 0, 0, 3, 1, 60, 105, 10, 0, 3, 0, 4, -73, -24, -111, 104, 96, 56, 0, 0, 0, 0] thepaul on "Importing CQL scripts" http://www.datastax.com/support-forums/topic/importing-cql-scripts#post-1032 Mon, 09 Jan 2012 15:30:34 +0000 thepaul 1032@http://www.datastax.com/support-forums/ You can pipe (or copy and paste) CQL commands into cqlsh directly, but there isn't (yet) any good way to have it stop on error. <a href="https://issues.apache.org/jira/browse/CASSANDRA-3479" rel="nofollow">https://issues.apache.org/jira/browse/CASSANDRA-3479</a> is tracking the addition of that feature. Anonymous on "Importing CQL scripts" http://www.datastax.com/support-forums/topic/importing-cql-scripts#post-901 Wed, 21 Dec 2011 06:54:55 +0000 Anonymous 901@http://www.datastax.com/support-forums/ Is there any way to import a set of CQL commands using 'cqlsh' or 'schematool' ? I see the 'import' option in 'schematool', not sure if its for CQL scripts. 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. 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>