cassandra-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Cyril Auburtin <cyril.aubur...@gmail.com>
Subject Re: C 1.1 & CQL 2.0 or 3.0?
Date Wed, 16 May 2012 08:33:35 GMT
well yes, since I can retrieve the keyspace and all CF (not SCF, it's
normal in cql?) with cqlsh (v2),

tic@mPC:~$ cqlsh 1xx.xx.xxx.xx 9165
Connected to Test Cluster at 1xx.xx.xxx.xx:9165.
[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> select * from Application;
cqlsh:Mykeyspace> exit;
tic@myPC:~$ cqlsh -3 1xx.xx.xxx.xx 9165
Connected to Test Cluster at 1xx.xx.xxx.xx:9165.
[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/14 paul cannon <paul@datastax.com>

> 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 <cyril.auburtin@gmail.com>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 <Jason.Wellonen@cassidiancommunications.com>
>>
>>> **
>>> I think you need to create the keyspace under the context of a v3
>>> connection.  Maybe someone else can confirm?
>>>
>>>
>>>  ------------------------------
>>> *From:* cyril auburtin [mailto:cyril.auburtin@gmail.com]
>>> *Sent:* Friday, May 11, 2012 11:46 AM
>>> *To:* user@cassandra.apache.org
>>> *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 <Jason.Wellonen@cassidiancommunications.com>
>>>
>>>> **
>>>> 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:cyril.auburtin@gmail.com]
>>>> *Sent:* Friday, May 11, 2012 10:51 AM
>>>> *To:* user@cassandra.apache.org
>>>> *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?
>>>>
>>>
>>>
>>
>

Mime
View raw message