http://www.datastax.com/support-forums/topic/use-cqlsh-30-create-a-table-and-we-can-not-use-thrift-api-to-operate-it Software, Support, and Training for Apache Cassandra en-US Thu, 23 May 2013 07:52:14 +0000 http://bbpress.org/?v=1.0.3 q http://www.datastax.com/support-forums/search.php http://www.datastax.com/support-forums/topic/use-cqlsh-30-create-a-table-and-we-can-not-use-thrift-api-to-operate-it#post-9211 Thu, 28 Feb 2013 16:54:46 +0000 nickmbailey 9211@http://www.datastax.com/support-forums/ <p>CQL 2 is completely thrift compatible. It doesn't contain the extra metadata that CQL3 uses.</p> <p>I would recommend filing feature requests for cqlsh at the cassandra jira:</p> <p><a href="https://issues.apache.org/jira/browse/CASSANDRA" rel="nofollow">https://issues.apache.org/jira/browse/CASSANDRA</a> </p> http://www.datastax.com/support-forums/topic/use-cqlsh-30-create-a-table-and-we-can-not-use-thrift-api-to-operate-it#post-9199 Thu, 28 Feb 2013 02:55:18 +0000 karpa13a 9199@http://www.datastax.com/support-forums/ <p>wow<br /> can you make bold note in cqlsh command reference (create/alter 'tables')?<br /> how about cql2? </p> http://www.datastax.com/support-forums/topic/use-cqlsh-30-create-a-table-and-we-can-not-use-thrift-api-to-operate-it#post-9191 Wed, 27 Feb 2013 17:52:38 +0000 nickmbailey 9191@http://www.datastax.com/support-forums/ <p>Column families created with CQL3 (default in cqlsh) contain metadata that the thrift api isn't able to understand. For that reason, those column families aren't shown in tools like the cli when listing keyspaces. </p> http://www.datastax.com/support-forums/topic/use-cqlsh-30-create-a-table-and-we-can-not-use-thrift-api-to-operate-it#post-9186 Wed, 27 Feb 2013 11:56:10 +0000 karpa13a 9186@http://www.datastax.com/support-forums/ <p>the same C1.2.2/ubuntu 12.04/openjdk<br /> CF created thru cassandra-cli visible in phpcassa/cqlsh<br /> but created thru cqlsh not visible in cassandra-cli and phpcassa</p> <p>bug?<br /> feature? </p> http://www.datastax.com/support-forums/topic/use-cqlsh-30-create-a-table-and-we-can-not-use-thrift-api-to-operate-it#post-9138 Fri, 22 Feb 2013 17:39:41 +0000 ws832863 9138@http://www.datastax.com/support-forums/ <p>hallo guys, i have a question about cqlsh3.0 and cassandra-cli. (cassandra version 1.2.1)</p> <p>i have created a table use cqlsh -3 and insert some data in it. However i got a error when i trying to use thrift api +java insert some information. Exception in thread "main" InvalidRequestException(why:Not enough bytes to read value of component 0)</p> <p>then i created a same keyspace with identisch column family by using cassandra-cli.. it works... why? dose it mean, thrif api can not get access to the keyspace which created by cqlsh 3.0?</p> <p>the code: quite simple </p> <p> TTransport tr = new TSocket(HOST, PORT);<br /> TFramedTransport tf = new TFramedTransport(tr);<br /> TProtocol proto = new TBinaryProtocol(tf);<br /> Cassandra.Client client = new Cassandra.Client(proto);</p> <p> tr.open();<br /> String Key_user_id = "userno1";<br /> long timestamp = System.currentTimeMillis();</p> <p> client.set_keyspace("schema1"); // schema1 was created by cqlsh, got error, then i changed to schema created by cassandra-cli, it works....</p> <p> ColumnParent parent = new ColumnParent("users");<br /> Column first_Column = new Column(toByteBuffer("first"));<br /> first_Column = setColumn(first_Column, "testjava", timestamp);<br /> client.insert(toByteBuffer(Key_user_id), parent, first_Column, CL);</p> <p> Column last_idColumn = new Column(toByteBuffer("last"));<br /> last_idColumn = setColumn(last_idColumn, "javatest", timestamp);<br /> client.insert(toByteBuffer(Key_user_id), parent, last_idColumn, CL);</p> <p> Column age_Column = new Column(toByteBuffer("age"));<br /> age_Column = setColumn(age_Column, "333", timestamp);<br /> client.insert(toByteBuffer(Key_user_id), parent, age_Column, CL);</p> <p> tr.close(); </p>