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 <alek...@yeschenko.com>
To: dev@cassandra.apache.org; Vivek Mishra <vivek.mis...@yahoo.com>
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 <mishra.v...@gmail.com (mailto:mishra.v...@gmail.com)>
> Date: Sun, Aug 25, 2013 at 12:58 AM
> Subject: CQLsh assume command
> To: u...@cassandra.apache.org (mailto:u...@cassandra.apache.org)
>
>
>
> 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
