I think you need to create the keyspace under the context of a v3 connection. Maybe someone else can confirm?
________________________________ From: cyril auburtin [mailto:[email protected]] Sent: Friday, May 11, 2012 11:46 AM To: [email protected] Subject: Re: C 1.1 & CQL 2.0 or 3.0? thx just: can't connect to keyspace with cql 3.0 tic@my:~$ cqlsh Connected to My Cluster at 127.0.0.1:4201. [cqlsh 2.2.0 | Cassandra 1.1.0 | CQL spec 2.0.0 | Thrift protocol 19.30.0] Use HELP for help. cqlsh> use mykeyspace; cqlsh:mykeyspace> exit; tic@my:~$ cqlsh -3 Connected to My Cluster at 127.0.0.1:4201. [cqlsh 2.2.0 | Cassandra 1.1.0 | CQL spec 3.0.0 | Thrift protocol 19.30.0] Use HELP for help. cqlsh> use mykeyspace; Bad Request: Keyspace 'mykeyspace' does not exist cqlsh> ?? 2012/5/11 Jason Wellonen <[email protected]> Version 2 is the default for your connection. Are you using cqlsh? If so, use the "-3" parameter for version 3... ________________________________ From: cyril auburtin [mailto:[email protected]] Sent: Friday, May 11, 2012 10:51 AM To: [email protected] Subject: C 1.1 & CQL 2.0 or 3.0? I have C* 1.1 but it seems to only come with cql 2.0 INFO 19:35:21,579 Cassandra version: 1.1.0 INFO 19:35:21,581 Thrift API version: 19.30.0 INFO 19:35:21,583 CQL supported versions: 2.0.0,3.0.0-beta1 (default: 2.0.0) the problem is I would like to create such CF : CREATE COLUMNFAMILY TaggedPosts ( ... tag text, ... post uuid, ... blog_rowentries_rowkey text, ... PRIMARY KEY (tag, post) ... ) WITH COMPACT STORAGE; and for me, (cql 2.0) it returns this error Bad Request: line 6:0 mismatched input ')' expecting EOF Is it due to the cql version? how to upgrade to 3.0, since I already have the lastest cassandra release?
