Re: IN restrictions are not supported on indexed columns

2018-03-24 Thread Dikang Gu
= 0.0 > > AND speculative_retry = '99PERCENTILE'; > > > > cqlsh:ks1> select * from t1 where key = 1 and col2 in (1) allow > filtering; > > > > 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
from t1 where key = 1 and col2 in (1) allow filtering; > > 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 >

IN restrictions are not supported on indexed columns

2018-03-23 Thread Dikang Gu
col2 in (1) allow filtering; 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