Mailing-List: contact user-help@cassandra.apache.org; run by ezmlm
Precedence: bulk
Reply-To: user@cassandra.apache.org
Received-SPF: pass (nike.apache.org: domain of the.wa.syndrome@gmail.com
 designates 209.85.216.51 as permitted sender)
MIME-Version: 1.0
In-Reply-To: 
 <CAK4eHaov7dpiGcEfk4xi_TJY+cKQZoSvf_h_z-+1N6wG+7tf4w@mail.gmail.com>
References: 
 <CAK4eHaov7dpiGcEfk4xi_TJY+cKQZoSvf_h_z-+1N6wG+7tf4w@mail.gmail.com>
Date: Mon, 5 Dec 2011 16:46:39 +0000
Message-ID: 
 <CABOR7TeKiFiHUrLHS7qeWH_-Q4+9kY2gdZxki4xzthwsNdUnxA@mail.gmail.com>
Subject: Re: Setting Key Validation Class
From: =?UTF-8?Q?Filipe_Gon=C3=A7alves?= <the.wa.syndrome@gmail.com>
To: user@cassandra.apache.org
Content-Type: text/plain; charset=UTF-8
Content-Transfer-Encoding: quoted-printable

Cassandra's data model is NOT table based. The key is not a column, it
is a separate value.  "index_type: KEYS" means you are creating an
index on that column, and that index can only be acessed in an
equality query ( column =3D x ).

You should probably read http://www.datastax.com/docs/1.0/ddl/index first.

2011/12/5 Dinusha Dilrukshi <sdddilrukshi@gmail.com>:
> Hi,
>
> I am using=C2=A0apache-cassandra-1.0.0 and I tried to insert/retrieve=C2=
=A0data in a
> column family using cassandra-jdbc program.
> Here is how I created 'USER' column family using cassandra-cli.
>
> create column family USER with comparator=3DUTF8Type
> and column_metadata=3D[{column_name: user_id, validation_class: UTF8Type,
> index_type: KEYS},
> {column_name: username, validation_class: UTF8Type, index_type: KEYS},
> {column_name: password, validation_class: UTF8Type}];
>
> But, when i try to insert data to USER column family it gives the error
> "java.sql.SQLException: Mismatched types: java.lang.String cannot be cast=
 to
> java.nio.ByteBuffer".
>
> Since I have set user_id as a KEY and it's=C2=A0validation_class as UTF8T=
ype, I
> was expected=C2=A0Key Validation Class as=C2=A0UTF8Type.
> But when I look at the meta-data of USER column family it shows as "Key
> Validation Class: org.apache.cassandra.db.marshal.BytesType" which has ca=
use
> for the above error.
>
> When I created USER column family as follows, it solves the above issue.
>
> create column family USER with comparator=3DUTF8Type and
> key_validation_class=3DUTF8Type
> and column_metadata=3D[{column_name: user_id, validation_class: UTF8Type,
> index_type: KEYS},
> {column_name: username, validation_class: UTF8Type, index_type: KEYS},
> {column_name: password, validation_class: UTF8Type}];
>
> Do we always need to define=C2=A0key_validation_class=C2=A0as in the abov=
e query ?
> Isn't it not enough to add validation classes for each column ?
>
> Regards,
> ~Dinusha~
>


--=20
Filipe Gon=C3=A7alves