This should not be the case- a keyspace is a keyspace, however created. I haven't been able to reproduce this; are you sure that the cassandra-cli and cqlsh are connecting to the same instance? Maybe you should create a Jira ticket.
p On Fri, May 11, 2012 at 2:05 PM, cyril auburtin <[email protected]>wrote: > yes it seems so > > as long as I create (more than just create keyspace mykeyspace) it with > cassandra cli, by creating CF, then I can't connect to it with cqlsh -3 > > I'll need to translate it in cql3 then > > 2012/5/11 Jason Wellonen <[email protected]> > >> ** >> 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? >>> >> >> >
