Return-Path: X-Original-To: apmail-cassandra-user-archive@www.apache.org Delivered-To: apmail-cassandra-user-archive@www.apache.org Received: from mail.apache.org (hermes.apache.org [140.211.11.3]) by minotaur.apache.org (Postfix) with SMTP id 2F9E2D3A3 for ; Mon, 24 Sep 2012 06:29:31 +0000 (UTC) Received: (qmail 82155 invoked by uid 500); 24 Sep 2012 06:29:28 -0000 Delivered-To: apmail-cassandra-user-archive@cassandra.apache.org Received: (qmail 81768 invoked by uid 500); 24 Sep 2012 06:29:23 -0000 Mailing-List: contact user-help@cassandra.apache.org; run by ezmlm Precedence: bulk List-Help: List-Unsubscribe: List-Post: List-Id: Reply-To: user@cassandra.apache.org Delivered-To: mailing list user@cassandra.apache.org Received: (qmail 81725 invoked by uid 99); 24 Sep 2012 06:29:21 -0000 Received: from nike.apache.org (HELO nike.apache.org) (192.87.106.230) by apache.org (qpsmtpd/0.29) with ESMTP; Mon, 24 Sep 2012 06:29:21 +0000 X-ASF-Spam-Status: No, hits=1.5 required=5.0 tests=FSL_RCVD_USER,HTML_MESSAGE,RCVD_IN_DNSWL_LOW,SPF_PASS X-Spam-Check-By: apache.org Received-SPF: pass (nike.apache.org: domain of oleksandr.petrov@gmail.com designates 209.85.223.172 as permitted sender) Received: from [209.85.223.172] (HELO mail-ie0-f172.google.com) (209.85.223.172) by apache.org (qpsmtpd/0.29) with ESMTP; Mon, 24 Sep 2012 06:29:14 +0000 Received: by iec9 with SMTP id 9so11092898iec.31 for ; Sun, 23 Sep 2012 23:28:53 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20120113; h=mime-version:in-reply-to:references:date:message-id:subject:from:to :content-type; bh=9tb2vdIdcy7h/wcAysXulkmmFNHKthGD5liTxakKLQw=; b=nr6yAT/n/ijoBC0OHbTwfSo5Fe+rKGU7ZzJ3XaaUdo0t0ftIPujm86Cc1qHHdIF/yn NPjAto9MUQVHjEQep3B8JyWL8uwtwrRIZxMDKvKi8SbmA20SwUi5sesYO9vSI57f+8iC +g3Wl0gtpI1CyqXqN1jUbUN2kWV9+jNlgmXU/m7NOdNX0Lhno/ebe1kWMT+1YItNrA1Z U/V5Ov3ODDlAPTiqGEYODhmfxuJJeXhmFn0z59FM4XW2ivLy17RpgZtCqh74poqGXOC9 8bXcFELssBVb8NaOG7XTF0nFNZx1XXo4sBifN+GH2/K2FXSXqQx7d092CWNb7vYGC0HM aN8w== MIME-Version: 1.0 Received: by 10.50.207.9 with SMTP id ls9mr4348603igc.64.1348468133797; Sun, 23 Sep 2012 23:28:53 -0700 (PDT) Received: by 10.64.100.132 with HTTP; Sun, 23 Sep 2012 23:28:53 -0700 (PDT) In-Reply-To: References: Date: Mon, 24 Sep 2012 08:28:53 +0200 Message-ID: Subject: Re: CQL 2, CQL 3 and Thrift confusion From: Oleksandr Petrov To: user@cassandra.apache.org Content-Type: multipart/alternative; boundary=14dae9340a551b1efa04ca6cb4e1 --14dae9340a551b1efa04ca6cb4e1 Content-Type: text/plain; charset=ISO-8859-1 Yup, that was exactly the cause. Somehow I could not figure out why it was downcasing my keyspace name all the time. May be good to put it somewhere in reference material with a more detailed explanation. On Sun, Sep 23, 2012 at 9:30 PM, Sylvain Lebresne wrote: > In CQL3, names are case insensitive by default, while they were case > sensitive in CQL2. You can force whatever case you want in CQL3 > however using double quotes. So in other words, in CQL3, > USE "TestKeyspace"; > should work as expected. > > -- > Sylvain > > On Sun, Sep 23, 2012 at 9:22 PM, Oleksandr Petrov > wrote: > > Hi, > > > > I'm currently using Cassandra 1.1.5. > > > > When I'm trying to create a Keyspace from CQL 2 with a command (`cqlsh > -2`): > > > > CREATE KEYSPACE TestKeyspace WITH strategy_class = 'SimpleStrategy' AND > > strategy_options:replication_factor = 1 > > > > Then try to access it from CQL 3 (`cqlsh -3`): > > > > USE TestKeyspace; > > > > I get an error: Bad Request: Keyspace 'testkeyspace' does not exist > > > > Same thing is applicable to Thrift Interface. Somehow, I can only access > > keyspaces created from CQL 2 via Thrift Interface. > > > > Basically, I get same exact error: InvalidRequestException(why:There is > no > > ring for the keyspace: CascadingCassandraCql3) > > > > Am I missing some switch? Or maybe it is intended to work that way?... > > Thanks! > > > > -- > > alex p > -- alex p --14dae9340a551b1efa04ca6cb4e1 Content-Type: text/html; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable Yup, that was exactly the cause. Somehow I could not figure out why it was = downcasing my keyspace name all the time.
May be good to put it somewhe= re in reference material with a more detailed explanation.

On Sun, Sep 23, 2012 at 9:30 PM, Sylvain Lebresne <sylvain@datastax.com= > wrote:
In CQL3, names are case insensitive by default, while they were case
sensitive in CQL2. You can force whatever case you want in CQL3
however using double quotes. So in other words, in CQL3,
=A0 USE "TestKeyspace";
should work as expected.

--
Sylvain

On Sun, Sep 23, 2012 at 9:22 PM, Oleksandr Petrov
<oleksandr.petrov@gmail.co= m> wrote:
> Hi,
>
> I'm currently using Cassandra 1.1.5.
>
> When I'm trying to create a Keyspace from CQL 2 with a command (`c= qlsh -2`):
>
> =A0 CREATE KEYSPACE TestKeyspace WITH strategy_class =3D 'SimpleSt= rategy' AND
> strategy_options:replication_factor =3D 1
>
> Then try to access it from CQL 3 (`cqlsh -3`):
>
> =A0 USE TestKeyspace;
>
> I get an error: Bad Request: Keyspace 'testkeyspace' does not = exist
>
> Same thing is applicable to Thrift Interface. Somehow, I can only acce= ss
> keyspaces created from CQL 2 via Thrift Interface.
>
> Basically, I get same exact error: InvalidRequestException(why:There i= s no
> ring for the keyspace: CascadingCassandraCql3)
>
> Am I missing some switch? Or maybe it is intended to work that way?...=
> Thanks!
>
> --
> alex p



--
= alex p
--14dae9340a551b1efa04ca6cb4e1--