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 <joels...@gmail.com>: > 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 <joels...@gmail.com> > wrote: > > > 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 SQL parser will treat the : in the query. > > > > > > > > > > Joel Bernstein > > http://joelsolr.blogspot.com/ > > > > On Thu, Aug 11, 2016 at 12:22 PM, Pablo Anzorena < > anzorena.f...@gmail.com> > > wrote: > > > >> 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. > >> > >> 2016-08-11 11:40 GMT-03:00 Pablo Anzorena <anzorena.f...@gmail.com>: > >> > >> > Excellent! > >> > > >> > Thanks Joel > >> > > >> > 2016-08-11 11:19 GMT-03:00 Joel Bernstein <joels...@gmail.com>: > >> > > >> >> 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: > >> >> https://github.com/apache/lucene-solr/blob/master/solr/solrj > >> >> /src/java/org/apache/solr/client/solrj/io/sql/StatementImpl.java > >> >> > >> >> The constructStream() method creates a SolrStream with the request. > >> >> > >> >> Joel Bernstein > >> >> http://joelsolr.blogspot.com/ > >> >> > >> >> On Thu, Aug 11, 2016 at 10:05 AM, Pablo Anzorena < > >> anzorena.f...@gmail.com > >> >> > > >> >> wrote: > >> >> > >> >> > 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$RemoteSolrE > >> xception: > >> >> > Error > >> >> > from server at http://tywin:8983/solr/testcol > >> lection1_shard1_replica1: > >> >> > Expected mime type application/octet-stream but got text/plain. > >> >> > {"result-set":{"docs":[ > >> >> > {"count(*)":5304,"d1":2}, > >> >> > {"count(*)":5160,"d1":1}, > >> >> > {"count(*)":5016,"d1":3}, > >> >> > {"count(*)":4893,"d1":4}, > >> >> > {"count(*)":4824,"d1":5}, > >> >> > {"EOF":true,"RESPONSE_TIME":11}]}} > >> >> > at > >> >> > org.apache.solr.client.solrj.impl.HttpSolrClient. > >> >> > executeMethod(HttpSolrClient.java:558) > >> >> > > >> >> > Then I tryed to implement a custom ResponseParser that override the > >> >> > getContentType() and returns "text/plain", but it returns another > >> error. > >> >> > > >> >> > So... Is it a way to get the sql response via this method? > >> >> > > >> >> > I make it works via Connection and ResultSets, but I need to use > the > >> >> other > >> >> > way (if possible). > >> >> > > >> >> > Thanks! > >> >> > > >> >> > >> > > >> > > >> > > > > >
