The last term in this query is redundant. Any time column1 = 1, we may reasonably expect that it is also <= 2 as that's where 1 is found. If you remove the last term, you elimiate the error and non of the selection logic.
SELECT * FROM CF WHERE key='X' AND column1=1 AND column2=3 AND column3>4 AND column1<=2; On Thu, Jul 17, 2014 at 6:23 PM, Mike Heffner <m...@librato.com> wrote: > 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 <m...@librato.com> > Librato, Inc. > -- - michael dykman - mdyk...@gmail.com May the Source be with you.
