[prev in list] [next in list] [prev in thread] [next in thread] 

List:       cassandra-dev
Subject:    Re: CQLsh assume command
From:       Vivek Mishra <vivek.mishra () yahoo ! com>
Date:       2013-08-25 17:36:11
Message-ID: 1377452171.89824.YahooMailNeo () web162402 ! mail ! bf1 ! yahoo ! com
[Download RAW message or body]


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



[prev in list] [next in list] [prev in thread] [next in thread]