CQL DELETE does not work

[Sridharan Kuppa <sr...@outlook.com>]

Hi,   I have created table schema using CQL, and I am able to insert and select from that table.  Everything works great but DELETE is not working.  When I execute the DELETE statement it throws "Bad Request: Failed parsing statement: [COL1, COL2, from TABLE1;] reason NullPointerException: null"  I tried without column names and with column names but always throws the same exception.
Thanks,-Sridharan 		 	   		  

RE: CQL DELETE does not work

[Sridharan Kuppa <sr...@outlook.com>]

Thank you for the reply.
I am using the CQL 2.0 with Cassandra 1.1.5.  The problem can be seen from cqlsh too.  The cqlsh commands are below,  If CQL delete is executed with where clause then it works.  Hope this helps,  
BTW, my environment is Windows 7, JDK 1.7, Cassandra 1.1.5, cqlsh using cygwin.
------------------------------------------- cqlsh  -------------------------------------------------------Connected to Test Cluster at localhost:9160.[cqlsh 2.2.0 | Cassandra 1.1.5 | CQL spec 2.0.0 | Thrift protocol 19.32.0]Use HELP for help.cqlsh>cqlsh> use demo1;cqlsh:demo1> create table user (id varchar primary key, fname varchar, lname varchar);cqlsh:demo1> insert into user (id, fname, lname) values (1, 'john', 'doe');cqlsh:demo1> insert into user (id, fname, lname) values (2, 'foo', 'bar');cqlsh:demo1> delete from user;Bad Request: Failed parsing statement: [delete from user;] reason: NullPointerException nullcqlsh:demo1> delete fname, lname from user;Bad Request: Failed parsing statement: [delete fname, lname from user;] reason: NullPointerException nullcqlsh:demo1> delete from user where id = 2;cqlsh:demo1>------------------------------------------- cqlsh  -------------------------------------------------------
Thanks,-Sridharan
> Date: Mon, 15 Oct 2012 10:39:08 +0200
> Subject: Re: CQL DELETE does not work
> From: sylvain@datastax.com
> To: user@cassandra.apache.org
> 
> On Fri, Oct 12, 2012 at 7:51 PM, Sridharan Kuppa
> <sr...@outlook.com> wrote:
> > Hi,
> >
> >   I have created table schema using CQL, and I am able to insert and select
> > from that table.  Everything works great but DELETE is not working.  When I
> > execute the DELETE statement it throws "Bad Request: Failed parsing
> > statement: [COL1, COL2, from TABLE1;] reason NullPointerException: null"  I
> > tried without column names and with column names but always throws the same
> > exception.
> 
> Please make sure you have tried against Cassandra 1.1.5 to be sure
> this haven't been fixed yet. But if that hasn't, to be able to help
> you we'll need:
> - An example query that triggers that this exception.
> - Which version of CQL you are using (2 or 3)
> 
> --
> Sylvain
 		 	   		  

Re: CQL DELETE does not work

[Sylvain Lebresne <sy...@datastax.com>]

On Fri, Oct 12, 2012 at 7:51 PM, Sridharan Kuppa
<sr...@outlook.com> wrote:
> Hi,
>
>   I have created table schema using CQL, and I am able to insert and select
> from that table.  Everything works great but DELETE is not working.  When I
> execute the DELETE statement it throws "Bad Request: Failed parsing
> statement: [COL1, COL2, from TABLE1;] reason NullPointerException: null"  I
> tried without column names and with column names but always throws the same
> exception.

Please make sure you have tried against Cassandra 1.1.5 to be sure
this haven't been fixed yet. But if that hasn't, to be able to help
you we'll need:
- An example query that triggers that this exception.
- Which version of CQL you are using (2 or 3)

--
Sylvain

Re: CQL DELETE does not work

[Vivek Mishra <mi...@gmail.com>]

Using cassandra version 1.1.x and cql3?

-Vivek

On Fri, Oct 12, 2012 at 11:21 PM, Sridharan Kuppa <
sridharan.kuppa@outlook.com> wrote:

> Hi,
>
>   I have created table schema using CQL, and I am able to insert and
> select from that table.  Everything works great but DELETE is not working.
>  When I execute the DELETE statement it throws "Bad Request: Failed parsing
> statement: [COL1, COL2, from TABLE1;] reason NullPointerException: null"  I
> tried without column names and with column names but always throws the same
> exception.
>
> Thanks,
> -Sridharan
>