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! >> >> > >> >> >> > >> > >> > >