incubator-cassandra-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Deeter, Derek" <derek.dee...@digitalinsight.com>
Subject CQL query using 'OR' in WHERE clause
Date Mon, 15 Aug 2011 23:45:49 GMT
Hi,

We are using CQL to obtain data from Cassandra 0.8.1 using Hector and
getting an error when using 'OR' on a secondary index.  I get the same
error when using CQL 1.0.3.  All the items in the WHERE clause are
secondary indices and they are all UTF8Type validation.  The query works
when leaving out everything from 'OR' onwards.   Example:

cqlsh> SELECT '.id' , '.ipAddress' , '.userProduct' , '.offeringId' ,
'.appId', 'timeStamp', '.logType', '.tzOffset'  , '.id' , 'member' ,
'mfaEnrolled' , 'sessionId' , 'startPage' , 'timeStamp' FROM Audit_Log
USING CONSISTENCY ONE WHERE '.bcId' =  '01112' AND '.userProduct' =
'IB' AND 'timeStamp' >=  1312182000000 AND '.logType' = 'login' OR
'.logType' = 'badLogin';
Bad Request: line 1:336 mismatched input 'OR' expecting EOF

I also tried to use the 'IN' keyword to no avail:

cqlsh> SELECT '.id' , '.ipAddress' , '.userProduct' , '.offeringId' ,
'.appId', 'timeStamp', '.logType', '.tzOffset'  , '.id' , 'member' ,
'mfaEnrolled' , 'sessionId' , 'startPage' , 'timeStamp' FROM Audit_Log
USING CONSISTENCY ONE WHERE '.bcId' =  '01112' AND '.userProduct' =
'IB' AND 'timeStamp' >=  1312182000000 AND '.logType' IN ( 'login',
'badLogin');
Bad Request: line 1:326 mismatched input 'IN' expecting set null

I also tried simplifying the query WHERE clause to only "WHERE
'.logType' = 'login' OR '.logType' = 'badLogin';"  but get the same
'mismatched input' error.  Is there any way to set up a query on a set
of values such as the above?  Or do I have the syntax wrong?

	Thanks in advance,
	-Derek


Derek Deeter
Software Engineer, Sr
 <http://ifs.intuit.com/> 
o: 818-597-5932  |  m: 661-645-7842  |  f: 818-878-7555
This email may contain confidential and privileged material for the sole
use of the intended recipient. Any review or distribution by others is
strictly prohibited. If you are not the intended recipient, please
contact the sender and delete all copies.



Mime
View raw message