[
https://issues.apache.org/jira/browse/CASSANDRA-4831?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13478720#comment-13478720
]
Sylvain Lebresne commented on CASSANDRA-4831:
---------------------------------------------
The error message is clearly broken and we should fix that, but we don't
support delete queries without a where clause (as in, it's not a CQL limitation
or anything, Cassandra just doesn't implement a way to delete some columns for
all the keys).
> CQL DELETE can not be used without where clause
> -----------------------------------------------
>
> Key: CASSANDRA-4831
> URL: https://issues.apache.org/jira/browse/CASSANDRA-4831
> Project: Cassandra
> Issue Type: Bug
> Components: Core
> Affects Versions: 1.1.5
> Environment: CQLSH
> Reporter: Sridharan Kuppa
> Labels: cql, delete, nullpointer
>
> 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. But it works only if where is clause is specified. The problem
> can be easily visualize using the 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 null
> cqlsh:demo1> delete fname, lname from user;
> Bad Request: Failed parsing statement: [delete fname, lname from user;]
> reason: NullPointerException null
> cqlsh:demo1> delete from user where id = 2;
> cqlsh:demo1>
--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators
For more information on JIRA, see: http://www.atlassian.com/software/jira
