Return-Path: Delivered-To: apmail-cassandra-user-archive@www.apache.org Received: (qmail 18099 invoked from network); 22 Mar 2010 19:50:24 -0000 Received: from unknown (HELO mail.apache.org) (140.211.11.3) by 140.211.11.9 with SMTP; 22 Mar 2010 19:50:24 -0000 Received: (qmail 2901 invoked by uid 500); 22 Mar 2010 19:50:23 -0000 Delivered-To: apmail-cassandra-user-archive@cassandra.apache.org Received: (qmail 2886 invoked by uid 500); 22 Mar 2010 19:50: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 2878 invoked by uid 99); 22 Mar 2010 19:50:23 -0000 Received: from athena.apache.org (HELO athena.apache.org) (140.211.11.136) by apache.org (qpsmtpd/0.29) with ESMTP; Mon, 22 Mar 2010 19:50:23 +0000 X-ASF-Spam-Status: No, hits=2.2 required=10.0 tests=FREEMAIL_FROM,HTML_MESSAGE,RCVD_IN_DNSWL_NONE,SPF_PASS,T_TO_NO_BRKTS_FREEMAIL X-Spam-Check-By: apache.org Received-SPF: pass (athena.apache.org: domain of jc.praud@gmail.com designates 209.85.220.216 as permitted sender) Received: from [209.85.220.216] (HELO mail-fx0-f216.google.com) (209.85.220.216) by apache.org (qpsmtpd/0.29) with ESMTP; Mon, 22 Mar 2010 19:50:18 +0000 Received: by fxm8 with SMTP id 8so941182fxm.25 for ; Mon, 22 Mar 2010 12:49:56 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=gamma; h=domainkey-signature:mime-version:received:in-reply-to:references :date:message-id:subject:from:to:content-type; bh=ZB/MkoLLwp0o+8vXGOnnCwf77u905yFWIRe8ZI9BAoU=; b=NxrQger4hnm4AIWfb6BHUaFkhVjEWtOKbGQrSq8LKrqMLq4Tv8JoxbYvekyirJLl4k XEH50EnQ0SH3XuT5FQGw9IfmO8/94c9GRIYZnF5MCtnCapb6sovFhJYK4xpz6L8yGGKh qr/Lfc/aOhe7zcwlsBKX92+XBcxnH0Bq9e5S8= DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=gamma; h=mime-version:in-reply-to:references:date:message-id:subject:from:to :content-type; b=YdRiRzkffdK++quPAlilylIiske9ZZHSNGJUr9ly6TZ/dXZmcN59D65cfGq8J/2PyI WdZDIZ09ybTg0LlW3vhYJC26ut/Q17/Z9GTHBkAIGA3+y2+H48WLsev3RtuHCjnl2O4n Klu5gQ1YcRKkBjBIdw+RUO2LW2V3JCsBNmqEI= MIME-Version: 1.0 Received: by 10.204.33.206 with SMTP id i14mr4507654bkd.52.1269287394416; Mon, 22 Mar 2010 12:49:54 -0700 (PDT) In-Reply-To: <94e911271003221243p6800dc34pe2c587345aac92c1@mail.gmail.com> References: <94e911271003221243p6800dc34pe2c587345aac92c1@mail.gmail.com> Date: Mon, 22 Mar 2010 20:49:54 +0100 Message-ID: Subject: Re: cassandra-cli 0.6 displays hashcodes instead of column names From: Jean-Christophe Praud To: user@cassandra.apache.org Content-Type: multipart/alternative; boundary=0003255579ea4319e50482690071 --0003255579ea4319e50482690071 Content-Type: text/plain; charset=ISO-8859-1 It's ok with the UTF8Type comparator. Thanks for your help On Mon, Mar 22, 2010 at 8:43 PM, Sandeep Kalidindi < deepu.kalidindi@gmail.com> wrote: > I guess this has been discussed before in the mailing list. > > @Jean-Christophe Praud - try changing the comparator in your column Family > tags from "BytesType" to "UTF8Type" in your storage-conf.yml and then > restart the cluster. > > Let us know if you can see the human readable column values after that > change. > > Cheers, > Deepu. > > > On Tue, Mar 23, 2010 at 12:50 AM, Jean-Christophe Praud wrote: > >> Hi all, >> >> I've got a problem since upgrading to Cassandra 0.6beta2/3. Instead of: >> >> cassandra> get test1.tags['5464'] >> => (column=width, value=500, timestamp=1268918427) >> => (column=transparent_color, value=000000, timestamp=1268918427) >> => (column=resolution, value=96x96, timestamp=1268918427) >> => (column=quality, value=75, timestamp=1268918427) >> => (column=interlace, value=None, timestamp=1268918427) >> => (column=height, value=333, timestamp=1268918427) >> => (column=compression, value=JPEG, timestamp=1268918427) >> => (column=colorspace, value=RGB, timestamp=1268918427) >> => (column=colordepth, value=8-bit, timestamp=1268918427) >> => (column=background_color, value=FFFFFF, timestamp=1268918427) >> >> I get: >> >> cassandra> get test1.tags['5464'] >> => (column=7769647468, value=500, timestamp=1268918427) >> => (column=7472616e73706172656e745f636f6c6f72, value=000000, >> timestamp=1268918427) >> => (column=7265736f6c7574696f6e, value=96x96, timestamp=1268918427) >> => (column=7175616c697479, value=75, timestamp=1268918427) >> => (column=696e7465726c616365, value=None, timestamp=1268918427) >> => (column=686569676874, value=333, timestamp=1268918427) >> => (column=636f6d7072657373696f6e, value=JPEG, timestamp=1268918427) >> => (column=636f6c6f727370616365, value=RGB, timestamp=1268918427) >> => (column=636f6c6f726465707468, value=8-bit, timestamp=1268918427) >> => (column=6261636b67726f756e645f636f6c6f72, value=FFFFFF, >> timestamp=1268918427) >> Returned 10 results. >> >> Both queries were run on the same cluster, with CLI 0.5.1 and 0.6 resp. >> The cluster is a 0.6 version, but the data were set in a version 0.5.1 >> before I upgraded the server to 0.6beta2. >> New columns I set have the same problem, too. >> >> Getting invidually each value works, but with the same display problem: >> >> cassandra> get test1.tags['5464']['compression'] >> => (column=636f6d7072657373696f6e, value=JPEG, timestamp=1268918427) >> >> >> Also I may have broken something, as I had to copy some missing jars from >> 0.5.1/lib to 0.6beta3/lib. >> >> I had the same problems with version 0.6beta2. >> >> >> >> Regards, >> >> >> >> -- >> Jean-Christophe Praud - http://shub-niggurath.com >> Ph'nglui mglw'nafh Cthulhu n'gah Bill R'lyeh Wgah'nagl fhtagn! >> > > -- Jean-Christophe Praud - http://shub-niggurath.com Ph'nglui mglw'nafh Cthulhu n'gah Bill R'lyeh Wgah'nagl fhtagn! --0003255579ea4319e50482690071 Content-Type: text/html; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable It's ok with the UTF8Type comparator.

Thanks for your help

On Mon, Mar 22, 2010 at 8:43 PM, Sandeep K= alidindi <deepu.kalidindi@gmail.com> wrote:
I guess this has = been discussed before in the mailing list.

@Jean-Christo= phe Praud - try changing the comparator in your column Family tags from &qu= ot;BytesType" to "UTF8Type" in your storage-conf.yml and the= n restart the cluster.

Let us know if you can see the human readable column va= lues after that change.

Cheers,
Deepu.


On Tue, Mar 23,= 2010 at 12:50 AM, Jean-Christophe Praud <jc@praud.com> wrote:
Hi all,

I&= #39;ve got a problem since upgrading to Cassandra 0.6beta2/3. Instead of:
cassandra> get test1.tags['5464']
=3D> (column=3Dwidth, value=3D500, timestamp=3D1268918427)
=3D> (c= olumn=3Dtransparent_color, value=3D000000, timestamp=3D1268918427)
=3D> (column=3Dresolution, value=3D96x96, timestamp=3D1268918427)
=3D= > (column=3Dquality, value=3D75, timestamp=3D1268918427)
=3D> (col= umn=3Dinterlace, value=3DNone, timestamp=3D1268918427)
=3D> (column= =3Dheight, value=3D333, timestamp=3D1268918427)
=3D> (column=3Dcompression, value=3DJPEG, timestamp=3D1268918427)
=3D= > (column=3Dcolorspace, value=3DRGB, timestamp=3D1268918427)
=3D> = (column=3Dcolordepth, value=3D8-bit, timestamp=3D1268918427)
=3D> (co= lumn=3Dbackground_color, value=3DFFFFFF, timestamp=3D1268918427)

I get:

cassandra> get test1.tags['5464']
=3D> (= column=3D7769647468, value=3D500, timestamp=3D1268918427)
=3D> (colum= n=3D7472616e73706172656e745f636f6c6f72, value=3D000000, timestamp=3D1268918= 427)
=3D> (column=3D7265736f6c7574696f6e, value=3D96x96, timestamp=3D= 1268918427)
=3D> (column=3D7175616c697479, value=3D75, timestamp=3D1268918427)
= =3D> (column=3D696e7465726c616365, value=3DNone, timestamp=3D1268918427)=
=3D> (column=3D686569676874, value=3D333, timestamp=3D1268918427)=3D> (column=3D636f6d7072657373696f6e, value=3DJPEG, timestamp=3D126891= 8427)
=3D> (column=3D636f6c6f727370616365, value=3DRGB, timestamp=3D1268918427= )
=3D> (column=3D636f6c6f726465707468, value=3D8-bit, timestamp=3D126= 8918427)
=3D> (column=3D6261636b67726f756e645f636f6c6f72, value=3DFFF= FFF, timestamp=3D1268918427)
Returned 10 results.

Both queries were run on the same cluster, with= CLI 0.5.1 and 0.6 resp.
The cluster is a 0.6 version, but the data wer= e set in a version 0.5.1 before I upgraded the server to 0.6beta2.
New columns I set have the same problem, too.

Getting invidually eac= h value works, but with the same display problem:

cassandra> get = test1.tags['5464']['compression']
=3D> (column=3D636f= 6d7072657373696f6e, value=3DJPEG, timestamp=3D1268918427)


Also I may have broken something, as I had to copy some missing jar= s from 0.5.1/lib to 0.6beta3/lib.

I had the same problems with vers= ion 0.6beta2.



Regards,



--
Jean-Christophe Praud =A0 =A0 =A0 =A0 - =A0 =A0 =A0http://shub-niggurath.com
Ph'ngl= ui mglw'nafh Cthulhu n'gah Bill R'lyeh Wgah'nagl fhtagn!




--
Jean-Christophe Praud = =A0 =A0 =A0 =A0 - =A0 =A0 =A0http://s= hub-niggurath.com
Ph'nglui mglw'nafh Cthulhu n'gah Bill = R'lyeh Wgah'nagl fhtagn!
--0003255579ea4319e50482690071--