I did post on user mailing list as well. I understand that, we can use these functions with each DDL/DML statement, but prior 2.0, ASSUME function should have worked as per provided definition.
Thanks for your reply. -Vivek ________________________________ From: Aleksey Yeschenko <[email protected]> To: [email protected]; Vivek Mishra <[email protected]> Sent: Sunday, August 25, 2013 7:37 PM Subject: Re: CQLsh assume command This is a wrong mailing list for this kind of questions. That aside, you should use CQL3 conversion functions instead, that work both for INSERT/UPDATE and SELECT. INSERT INTO default(id) VALUES (textAsBlob('1')); SELECT blobAsText(id) FROM default; ASSUME is gone in 2.0. -- AY On Sunday, August 25, 2013 at 10:05 AM, Vivek Mishra wrote: > Hi, > fyi. > > Cqlsh ASSUME command, does it work with INSERT statement? > > Any suggestions? > > -Vivek > > ---------- Forwarded message ---------- > From: Vivek Mishra <[email protected] (mailto:[email protected])> > Date: Sun, Aug 25, 2013 at 12:58 AM > Subject: CQLsh assume command > To: [email protected] (mailto:[email protected]) > > > > Hi, > i am trying to get CQL3 ASSUME command working, as it works with > Cassandra-cli. > > In my example, i have create a table as : > > create table > default(id blob PRIMARY KEY); > Then after connecting with CQLsh(version 3), i did execute: > assume default(id) values are text; > and then tried to insert a simple record as : > > > insert into default(id) values('1'); > > But still i am getting error as: > Bad Request: cannot parse '1' as hex bytes > > Any suggestion, what am i doing incorrect here? > > -Vivek
