cassandra-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Mike Heffner <m...@librato.com>
Subject How to column slice with CQL + 1.2
Date Thu, 17 Jul 2014 22:23:17 GMT
What is the proper way to perform a column slice using CQL with 1.2?

I have a CF with a primary key X and 3 composite columns (A, B, C). I'd
like to find records at:

key=X
columns > (A=1, B=3, C=4) AND
   columns <= (A=2)

The Query:

SELECT * FROM CF WHERE key='X' AND column1=1 AND column2=3 AND column3>4
AND column1<=2;

fails with:

DoGetMeasures: column1 cannot be restricted by both an equal and an inequal
relation

This is against Cassandra 1.2.16.

What is the proper way to perform this query?


Cheers,

Mike

-- 

  Mike Heffner <mike@librato.com>
  Librato, Inc.

Mime
View raw message