Re: Consume sql response using solrj

Thanks Joel, that's work perfectly well. I checked some cases and the data is consistent. 2016-08-11 14:17 GMT-03:00 Joel Bernstein : > Actually try this: > > select a from b where _query_='a:b' > > *This produces the query:* > > (_query_:"a:b") > > which should run. > > >

Re: Consume sql response using solrj

Actually try this: select a from b where _query_='a:b' *This produces the query:* (_query_:"a:b") which should run. Joel Bernstein http://joelsolr.blogspot.com/ On Thu, Aug 11, 2016 at 1:04 PM, Joel Bernstein wrote: > There are no test cases for this but you can try

Re: Consume sql response using solrj

There are no test cases for this but you can try this syntax: select a from b where _query_=(a:c AND d:f) This should get translated to: _query_:(a:c AND d:f) This link describes the behavior of _query_ https://lucidworks.com/blog/2009/03/31/nested-queries-in-solr/ Just not positive how the

Re: Consume sql response using solrj

Joel, one more thing. Is there anyway to use the sql and the lucene query syntax? The thing is that my bussiness application is tightly coupled with the lucene query syntax, so I need a way to use both the sql features (without the where clause) and the query syntax of lucene. Thanks.

Re: Consume sql response using solrj

Excellent! Thanks Joel 2016-08-11 11:19 GMT-03:00 Joel Bernstein : > There are two ways to do this with SolrJ: > > 1) Use the JDBC driver. > > 2) Use the SolrStream to send the request and then read() the Tuples. This > is what the JDBC driver does under the covers. The

Re: Consume sql response using solrj

There are two ways to do this with SolrJ: 1) Use the JDBC driver. 2) Use the SolrStream to send the request and then read() the Tuples. This is what the JDBC driver does under the covers. The sample code can be found here:

Consume sql response using solrj

Hey, I'm trying to get the response of solr via QueryResponse using QueryResponse queryResponse = client.query(solrParams); (where client is a CloudSolrClient) The error it thows is: org.apache.solr.client.solrj.impl.HttpSolrClient$RemoteSolrException: Error from server at