Re: [EXTERNAL] RE: SASI queries- cqlsh vs java driver

2019-02-27 Thread Peter Heitman
Sean Durity >>> >>> >>> >>> *From:* Kenneth Brotman >>> *Sent:* Thursday, February 07, 2019 7:01 AM >>> *To:* user@cassandra.apache.org >>> *Subject:* [EXTERNAL] RE: SASI queries- cqlsh vs java driver >>> >>> >

Re: SASI queries- cqlsh vs java driver

2019-02-06 Thread Peter Heitman
ved=2ahUKEwi0n-nWzajgAhXnHzQIHf6jBJIQ6AEwAXoECAgQAQ#v=onepage&q=jeff%20carpenter%20chapter%205&f=false> > . > > > > Kenneth Brotman > > > > *From:* Peter Heitman [mailto:pe...@heitman.us] > *Sent:* Wednesday, February 06, 2019 6:33 PM > > > *To:*

Re: SASI queries- cqlsh vs java driver

2019-02-06 Thread Peter Heitman
se ALLOW FILTERING in the queries. That is not recommended. > > > > Kenneth Brotman > > > > *From:* Peter Heitman [mailto:pe...@heitman.us] > *Sent:* Wednesday, February 06, 2019 6:09 PM > *To:* user@cassandra.apache.org > *Subject:* Re: SASI queries- cqlsh vs java

Re: SASI queries- cqlsh vs java driver

2019-02-06 Thread Peter Heitman
> > Kenneth Brotman > > > > *From:* Peter Heitman [mailto:pe...@heitman.us] > *Sent:* Tuesday, February 05, 2019 6:59 PM > *To:* user@cassandra.apache.org > *Subject:* Re: SASI queries- cqlsh vs java driver > > > > The table and secondary indexes look generally lik

Re: SASI queries- cqlsh vs java driver

2019-02-05 Thread Peter Heitman
On Tue, Feb 5, 2019 at 3:33 PM Oleksandr Petrov wrote: > Could you post full table schema (names obfuscated, if required) with > index creation statements and queries? > > On Mon, Feb 4, 2019 at 10:04 AM Jacques-Henri Berthemet < > jacques-henri.berthe...@genesys.com> wrote: > &g

SASI queries- cqlsh vs java driver

2019-02-03 Thread Peter Heitman
When I create a SASI index on a secondary column, from cqlsh I can execute a query SELECT blah FROM foo WHERE IN ('mytext') ALLOW FILTERING; but not from the java driver: SELECT blah FROM foo WHERE IN :val ALLOW FILTERING Here I get an exception com.datastax.driver.core.exceptions.InvalidQue