[
https://issues.apache.org/jira/browse/CASSANDRA-2538?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13023432#comment-13023432
]
Cathy Daw commented on CASSANDRA-2538:
--------------------------------------
This is just a consistency thing, but the documentation is misleading.
The DELETE documentation shows you can use an 'IN' clause:
DELETE [COLUMNS] FROM <COLUMN FAMILY> [USING <CONSISTENCY>] WHERE KEY IN
(keyname1, keyname2);
The example for DELETE uses UPDATE, so I assumed 'IN' would work for
DELETE/UPDATE/SELECT.
UPDATE ... WHERE KEY IN (keyname1, keyname2)
> CQL: NPE running SELECT with an IN clause
> -----------------------------------------
>
> Key: CASSANDRA-2538
> URL: https://issues.apache.org/jira/browse/CASSANDRA-2538
> Project: Cassandra
> Issue Type: Bug
> Affects Versions: 0.8 beta 1
> Reporter: Cathy Daw
> Assignee: Eric Evans
> Priority: Minor
> Labels: cql
> Fix For: 0.8.0
>
> Attachments:
> v1-0001-CASSANDRA-2538-NPE-running-SELECT-with-an-IN-clause.txt
>
>
> *Test Case to Run*
> {noformat}
> cqlsh> select * from users where key in ('user2', 'user3');
> Internal application error
> {noformat}
> *Test Setup*
> {noformat}
> CREATE COLUMNFAMILY users (
> KEY varchar PRIMARY KEY,
> password varchar);
> INSERT INTO users (KEY, password) VALUES ('user1', 'ch@ngem3a');
> {noformat}
> *Log Files*
> {noformat}
> ERROR [RequestResponseStage:17] 2011-04-21 23:36:41,600
> AbstractCassandraDaemon.java (line 112) Fatal exception in thread
> Thread[RequestResponseStage:17,5,main]
> java.lang.AssertionError
> at
> org.apache.cassandra.service.ReadCallback.response(ReadCallback.java:127)
> at
> org.apache.cassandra.net.ResponseVerbHandler.doVerb(ResponseVerbHandler.java:49)
> at
> org.apache.cassandra.net.MessageDeliveryTask.run(MessageDeliveryTask.java:72)
> at
> java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1110)
> at
> java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:603)
> at java.lang.Thread.run(Thread.java:636)
> ERROR [RequestResponseStage:17] 2011-04-21 23:36:41,600
> AbstractCassandraDaemon.java (line 112) Fatal exception in thread
> Thread[RequestResponseStage:17,5,main]
> java.lang.AssertionError
> at
> org.apache.cassandra.service.ReadCallback.response(ReadCallback.java:127)
> at
> org.apache.cassandra.net.ResponseVerbHandler.doVerb(ResponseVerbHandler.java:49)
> at
> org.apache.cassandra.net.MessageDeliveryTask.run(MessageDeliveryTask.java:72)
> at
> java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1110)
> at
> java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:603)
> at java.lang.Thread.run(Thread.java:636)
> ERROR [pool-2-thread-5] 2011-04-21 23:37:12,026 Cassandra.java (line 4082)
> Internal error processing execute_cql_query
> java.lang.NullPointerException
> at org.apache.cassandra.cql.WhereClause.and(WhereClause.java:59)
> at org.apache.cassandra.cql.WhereClause.<init>(WhereClause.java:44)
> at org.apache.cassandra.cql.CqlParser.whereClause(CqlParser.java:816)
> at
> org.apache.cassandra.cql.CqlParser.selectStatement(CqlParser.java:502)
> at org.apache.cassandra.cql.CqlParser.query(CqlParser.java:191)
> at
> org.apache.cassandra.cql.QueryProcessor.getStatement(QueryProcessor.java:834)
> at
> org.apache.cassandra.cql.QueryProcessor.process(QueryProcessor.java:463)
> at
> org.apache.cassandra.thrift.CassandraServer.execute_cql_query(CassandraServer.java:1134)
> at
> org.apache.cassandra.thrift.Cassandra$Processor$execute_cql_query.process(Cassandra.java:4072)
> at
> org.apache.cassandra.thrift.Cassandra$Processor.process(Cassandra.java:2889)
> at
> org.apache.cassandra.thrift.CustomTThreadPoolServer$WorkerProcess.run(CustomTThreadPoolServer.java:187)
> at
> java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1110)
> at
> java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:603)
> at java.lang.Thread.run(Thread.java:636)
> {noformat}
--
This message is automatically generated by JIRA.
For more information on JIRA, see: http://www.atlassian.com/software/jira
