I didn't have a chance yet to fully formulate a strategy for using the
qparser plugins through the SQL interface.
In the initial release there is a back door that allows you tack on any
parameters you want, and they should be passed through to Solr. There are
no test cases for this, but I can add some to verify this is working. The
idea being that you can do this:
/sql?stmt=SELECT...&fq={!geofilt ...}
One of the main things I had in mind with this was allowing access control
lists to be passed in, because Alfresco supports document level access
control which would need to be supported through the SQL interface.
But any fq should get passed through. it's not clear right now whether
multiple fq's will be passed through, but due to changes that Erick
Erickson recently contributed, I believe they will. Again we need test
cases for this.
The JDBC driver should pass through any properties that are set on the
connection as well. Again I was mostly thinking about access control here
but other qparsers can be added as well.
This was not meant as the long term solution though. In future releases I
think we should roll out as many function queries and qparser plugins as
possible as SQL functions.
Joel Bernstein
http://joelsolr.blogspot.com/
On Sun, May 22, 2016 at 3:11 PM, Timothy Potter <thelabd...@gmail.com>
wrote:
> How would I do something like: find all docs using a geofilt, e.g.
>
> SELECT title_s
> FROM movielens
> WHERE location_p='{!geofilt d=90 pt=37.773972,-122.431297
> sfield=location_p}'
>
> This fails with:
>
> {"result-set":{"docs":[
> {"EXCEPTION":"java.util.concurrent.ExecutionException:
> java.io.IOException: -->
>
> http://ec2-54-165-55-141.compute-1.amazonaws.com:8984/solr/movielens_shard2_replica1/:Can't
> parse point '{!geofilt d=90 pt=37.773972,-122.431297
> sfield=location_p}' because: java.lang.NumberFormatException: For
> input string: \"{!geofilt d=90
> pt=37.773972\"","EOF":true,"RESPONSE_TIME":4}]}}
>
> In general, I wasn't able to find much about using functions with
> local params in the SQL syntax?
>
