Re: IN restrictions are not supported on indexed columns

2018-03-24 Thread Dikang Gu
> > > > key | col1 | col2 | value > > -----+--+--+--- > >1 |1 |1 | 1 > >1 |2 |1 | 3 > > > > (2 rows) > > cqlsh:ks1> select * from t1 where key = 1 and col2 in (1, 2) allow > > filtering; > > *InvalidRequest: Error from server: code=2200 [Invalid query] message="IN > > restrictions are not supported on indexed columns"* > > cqlsh:ks1> > > = > > > > Thanks > > > > > > -- > > Dikang > > > -- Dikang

Re: IN restrictions are not supported on indexed columns

2018-03-23 Thread Benjamin Lerer
|1 | 3 > > (2 rows) > cqlsh:ks1> select * from t1 where key = 1 and col2 in (1, 2) allow > filtering; > *InvalidRequest: Error from server: code=2200 [Invalid query] message="IN > restrictions are not supported on indexed columns"* > cqlsh:ks1> > = > > Thanks > > > -- > Dikang >

IN restrictions are not supported on indexed columns

2018-03-23 Thread Dikang Gu
ol2 in (1, 2) allow filtering; *InvalidRequest: Error from server: code=2200 [Invalid query] message="IN restrictions are not supported on indexed columns"* cqlsh:ks1> = Thanks -- Dikang