Michael, So if I switch to:
SELECT * FROM CF WHERE key='X' AND column1=1 AND column2=3 AND column3>4 That doesn't include rows where column1=2, which breaks the original slice query. Maybe a better way to put it, I would like: SELECT * FROM CF WHERE key='X' AND column1>=1 AND column2>=3 AND column3>4 AND column1<=2; but that is rejected with: Bad Request: PRIMARY KEY part column2 cannot be restricted (preceding part column1 is either not restricted or by a non-EQ relation) Mike On Thu, Jul 17, 2014 at 6:37 PM, Michael Dykman <mdyk...@gmail.com> wrote: > 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. > -- Mike Heffner <m...@librato.com> Librato, Inc.
