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 jonathan.haddad@gmail.com
 designates 209.85.220.52 as permitted sender)
Sender: Jon Haddad <jonathan.haddad@gmail.com>
From: Jon Haddad <jon@jonhaddad.com>
Content-Type: multipart/alternative;
 boundary="Apple-Mail=_8CFEE23A-CE3B-4C97-82F1-EA1743DB7351"
Message-Id: <61E7EDCF-0F8D-4C4C-8D35-DF7808B24136@jonhaddad.com>
Mime-Version: 1.0 (Mac OS X Mail 6.5 \(1508\))
Subject: Re: CQL & Thrift
Date: Fri, 30 Aug 2013 10:45:06 -0700
References: 
 <CANJo1uA6_-SEQ1Qu-CB89aahpEYuDYe_-Q-Q3X725TY8Qsyf4w@mail.gmail.com>
To: user@cassandra.apache.org
In-Reply-To: 
 <CANJo1uA6_-SEQ1Qu-CB89aahpEYuDYe_-Q-Q3X725TY8Qsyf4w@mail.gmail.com>


--Apple-Mail=_8CFEE23A-CE3B-4C97-82F1-EA1743DB7351
Content-Transfer-Encoding: quoted-printable
Content-Type: text/plain;
	charset=iso-8859-1

If you're going to work with CQL, work with CQL.  If you're going to =
work with Thrift, work with Thrift.  Don't mix.

On Aug 30, 2013, at 10:38 AM, Vivek Mishra <mishra.vivs@gmail.com> =
wrote:

> Hi,
> If i a create a table with CQL3 as=20
>=20
> create table user(user_id text PRIMARY KEY, first_name text, last_name =
text, emailid text);
>=20
> and create index as:
> create index on user(first_name);
>=20
> then inserted some data as:
> insert into user(user_id,first_name,last_name,"emailId") =
values('@mevivs','vivek','mishra','vivek.mishra@impetus.co.in');
>=20
>=20
> Then if update same column family using Cassandra-cli as:
>=20
> update column family user with key_validation_class=3D'UTF8Type' and =
column_metadata=3D[{column_name:last_name, validation_class:'UTF8Type', =
index_type:KEYS},{column_name:first_name, validation_class:'UTF8Type', =
index_type:KEYS}];
>=20
>=20
> Now if i connect via cqlsh and explore user table, i can see column =
first_name,last_name are not part of table structure anymore. Here is =
the output:
>=20
> CREATE TABLE user (
>   key text PRIMARY KEY
> ) WITH
>   bloom_filter_fp_chance=3D0.010000 AND
>   caching=3D'KEYS_ONLY' AND
>   comment=3D'' AND
>   dclocal_read_repair_chance=3D0.000000 AND
>   gc_grace_seconds=3D864000 AND
>   read_repair_chance=3D0.100000 AND
>   replicate_on_write=3D'true' AND
>   populate_io_cache_on_flush=3D'false' AND
>   compaction=3D{'class': 'SizeTieredCompactionStrategy'} AND
>   compression=3D{'sstable_compression': 'SnappyCompressor'};
>=20
> cqlsh:cql3usage> select * from user;
>=20
>  user_id
> ---------
>  @mevivs
>=20
>=20
>=20
>=20
>=20
> I understand that, CQL3 and thrift interoperability is an issue. But =
this looks to me a very basic scenario.
>=20
>=20
>=20
> Any suggestions? Or If anybody can explain a reason behind this?
>=20
> -Vivek
>=20
>=20
>=20
>=20


--Apple-Mail=_8CFEE23A-CE3B-4C97-82F1-EA1743DB7351
Content-Transfer-Encoding: 7bit
Content-Type: text/html;
	charset=iso-8859-1

<html><head><meta http-equiv="Content-Type" content="text/html charset=iso-8859-1"></head><body style="word-wrap: break-word; -webkit-nbsp-mode: space; -webkit-line-break: after-white-space; "><div>If you're going to work with CQL, work with CQL. &nbsp;If you're going to work with Thrift, work with Thrift. &nbsp;Don't mix.</div><br><div><div>On Aug 30, 2013, at 10:38 AM, Vivek Mishra &lt;<a href="mailto:mishra.vivs@gmail.com">mishra.vivs@gmail.com</a>&gt; wrote:</div><br class="Apple-interchange-newline"><blockquote type="cite"><div dir="ltr">Hi,<div style="">If i a create a table with CQL3 as&nbsp;</div><div style=""><div><br></div><div>create table user(user_id text PRIMARY KEY, first_name text, last_name text, emailid text);</div><div><br></div><div style="">
and create index as:</div><div style=""><div>create index on user(first_name);</div><div><br></div><div style="">then inserted some data as:</div><div style="">insert into user(user_id,first_name,last_name,"emailId") values('@mevivs','vivek','mishra','<a href="mailto:vivek.mishra@impetus.co.in">vivek.mishra@impetus.co.in</a>');<br>
</div><div style=""><br></div><div style=""><br></div><div style="">Then if update same column family using Cassandra-cli as:</div><div style=""><br></div><div style="">update column family user with key_validation_class='UTF8Type' and column_metadata=[{column_name:last_name, validation_class:'UTF8Type', index_type:KEYS},{column_name:first_name, validation_class:'UTF8Type', index_type:KEYS}];<br>
</div><div style=""><br></div><div style=""><br></div><div style="">Now if i connect via cqlsh and explore user table, i can see column first_name,last_name are not part of table structure anymore. Here is the output:</div><div style="">
<br></div><div style=""><div>CREATE TABLE user (</div><div>&nbsp; key text PRIMARY KEY</div><div>) WITH</div><div>&nbsp; bloom_filter_fp_chance=0.010000 AND</div><div>&nbsp; caching='KEYS_ONLY' AND</div><div>&nbsp; comment='' AND</div>
<div>&nbsp; dclocal_read_repair_chance=0.000000 AND</div><div>&nbsp; gc_grace_seconds=864000 AND</div><div>&nbsp; read_repair_chance=0.100000 AND</div><div>&nbsp; replicate_on_write='true' AND</div><div>&nbsp; populate_io_cache_on_flush='false' AND</div>
<div>&nbsp; compaction={'class': 'SizeTieredCompactionStrategy'} AND</div><div>&nbsp; compression={'sstable_compression': 'SnappyCompressor'};</div><div><br></div><div>cqlsh:cql3usage&gt; select * from user;</div>
<div><br></div><div>&nbsp;user_id</div><div>---------</div><div>&nbsp;@mevivs</div><div><br></div></div><div style=""><br></div><div style=""><br></div><div style=""><br></div><div style=""><br></div><div style="">I understand that, CQL3 and thrift interoperability is an issue. But this looks to me a very basic scenario.</div>
<div style=""><br></div><div style=""><br></div><div style=""><br></div><div style="">Any suggestions? Or If anybody can explain a reason behind this?</div><div style=""><br></div><div style="">-Vivek</div><div style=""><br></div><div style=""><br>
</div><div style=""><br></div></div><div><br></div></div></div>
</blockquote></div><br></body></html>
--Apple-Mail=_8CFEE23A-CE3B-4C97-82F1-EA1743DB7351--