Mailing-List: contact user-help@cassandra.apache.org; run by ezmlm
Precedence: bulk
Reply-To: user@cassandra.apache.org
Received-SPF: pass (athena.apache.org: domain of samalgorai@gmail.com
 designates 74.125.82.172 as permitted sender)
MIME-Version: 1.0
In-Reply-To: 
 <CAMXPLPi61FntghO0NLmUY2ypmZdawLonuVMy0ogZ2HuG=YJy=g@mail.gmail.com>
References: 
 <CAMXPLPi61FntghO0NLmUY2ypmZdawLonuVMy0ogZ2HuG=YJy=g@mail.gmail.com>
Date: Tue, 22 May 2012 18:16:40 +0530
Message-ID: 
 <CAP=kKf8A=qs+R_dMFSLrYm+TiCF9wxMXXo-zN=h3=dDhr458vQ@mail.gmail.com>
Subject: Re: Cassandra 0.8.5: Column name mystery in create column family
 command
From: samal <samalgorai@gmail.com>
To: user@cassandra.apache.org
Content-Type: multipart/alternative; boundary=0016e6d9a2d4fea12204c09f68f2

--0016e6d9a2d4fea12204c09f68f2
Content-Type: text/plain; charset=UTF-8

Change your comparator to utf8type.
On 22-May-2012 4:32 PM, "Roshan Dawrani" <roshandawrani@gmail.com> wrote:

> Hi,
>
> I use Cassandra 0.8.5 and am suddenly noticing some strange behavior. I
> run a "create column family" command with some column meta-data and it runs
> fine, but when I do "describe keyspace", it shows me different column names
> for those index columns.
>
> a) Here is what I run:
> "create column family UserTemplate with comparator=BytesType and
> column_metadata=[{*column_name: userid*, validation_class: UTF8Type,
> index_type: KEYS, index_name: TemplateUserIdIdx}, {*column_name: type*,
> validation_class: UTF8Type, index_type: KEYS, index_name:
> TemplateTypeIdx}];"
>
> b) This is what "describe keyspace" shows:
>     ColumnFamily: UserTemplate
>       Key Validation Class: org.apache.cassandra.db.marshal.BytesType
>       ...
>       ...
>       Built indexes: [UserTemplate.TemplateTypeIdx,
> UserTemplate.TemplateUserIdIdx]
>       Column Metadata:
>         *Column Name: ffffff*
>           Validation Class: org.apache.cassandra.db.marshal.UTF8Type
>           Index Name: TemplateUserIdIdx
>           Index Type: KEYS
>         *Column Name: 0dfffaff*
>           Validation Class: org.apache.cassandra.db.marshal.UTF8Type
>           Index Name: TemplateTypeIdx
>           Index Type: KEYS
>
> Does anyone see why this must be happening? I have created many such
> column families before and never run into this issue.
>
> --
> Roshan
> http://roshandawrani.wordpress.com/
>
>

--0016e6d9a2d4fea12204c09f68f2
Content-Type: text/html; charset=UTF-8
Content-Transfer-Encoding: quoted-printable

<p>Change your comparator to utf8type.</p>
<div class=3D"gmail_quote">On 22-May-2012 4:32 PM, &quot;Roshan Dawrani&quo=
t; &lt;<a href=3D"mailto:roshandawrani@gmail.com">roshandawrani@gmail.com</=
a>&gt; wrote:<br type=3D"attribution"><blockquote class=3D"gmail_quote" sty=
le=3D"margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">
Hi,<div><br></div><div>I use Cassandra 0.8.5 and am suddenly noticing some =
strange behavior. I run a &quot;create column family&quot; command with som=
e column meta-data and it runs fine, but when I do &quot;describe keyspace&=
quot;, it shows me different column names for those index columns.</div>

<div><br></div><div>a) Here is what I run:=C2=A0</div><div>&quot;create col=
umn family UserTemplate with comparator=3DBytesType and column_metadata=3D[=
{<b>column_name: userid</b>, validation_class: UTF8Type, index_type: KEYS, =
index_name: TemplateUserIdIdx}, {<b>column_name: type</b>, validation_class=
: UTF8Type, index_type: KEYS, index_name: TemplateTypeIdx}];&quot;</div>

<div><br></div><div>b) This is what &quot;describe keyspace&quot; shows:</d=
iv><div><div>=C2=A0 =C2=A0 ColumnFamily: UserTemplate</div><div>=C2=A0 =C2=
=A0 =C2=A0 Key Validation Class: org.apache.cassandra.db.marshal.BytesType<=
/div><div>=C2=A0 =C2=A0 =C2=A0 ...</div>

<div>=C2=A0 =C2=A0 =C2=A0 ...</div><div>=C2=A0 =C2=A0 =C2=A0 Built indexes:=
 [UserTemplate.TemplateTypeIdx, UserTemplate.TemplateUserIdIdx]</div><div>=
=C2=A0 =C2=A0 =C2=A0 Column Metadata:</div><div>=C2=A0 =C2=A0 =C2=A0 =C2=A0=
 <b>Column Name: ffffff</b></div><div>=C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 Va=
lidation Class: org.apache.cassandra.db.marshal.UTF8Type</div>

<div>=C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 Index Name: TemplateUserIdIdx</div>=
<div>=C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 Index Type: KEYS</div><div>=C2=A0 =
=C2=A0 =C2=A0 =C2=A0 <b>Column Name: 0dfffaff</b></div><div>=C2=A0 =C2=A0 =
=C2=A0 =C2=A0 =C2=A0 Validation Class: org.apache.cassandra.db.marshal.UTF8=
Type</div><div>=C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 Index Name: TemplateTypeI=
dx</div>

<div>=C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 Index Type: KEYS</div><div><br></di=
v><div>Does anyone see why this must be happening? I have created many such=
 column families before and never run into this issue.</div><div><br></div>=
-- <br>Roshan<div><a href=3D"http://roshandawrani.wordpress.com/" target=3D=
"_blank">http://roshandawrani.wordpress.com/</a><br>

</div><br>
</div>
</blockquote></div>

--0016e6d9a2d4fea12204c09f68f2--