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: sylv...@datastax.com
> To: user@cassandra.apache.org
>
> On Fri, Oct 12, 2012 at 7:51 PM, Sridharan Kuppa
> <sridharan.ku...@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