Does anything exists already in solr 4.3 to meet this usecase scenario?
--
View this message in context:
http://lucene.472066.n3.nabble.com/filter-query-from-external-list-of-Solr-unique-IDs-tp1709060p4070874.html
Sent from the Solr - User mailing list archive at Nabble.com.
: Hoss mentioned a couple of ideas:
: 1) sub-classing query parser
: 2) Having the app query a database and somehow passing something
: to Solr or lucene for the filter query
The approach i was refering to is something one of my coworkers did a
while back (if he's still
I was actually thinking of some kind of custom Lucene/Solr component that
would for example take a query parameter such as lookitUp=123 and the
component might do a JDBC query against a database or kv store and return
results in some form that would be efficient for Solr/Lucene to process.
You could even
generalize the hell out of it so the SQL itself could be specified at
request time...
q=solrfq={!sql}SELECT ID FROM USER_MAP WHERE USER=1234 ORDER BY ID ASC
I think that's missing the need for an argument for what field in the solr
index to require to be within the values
Or an alternate simpler solution requiring the client to do more work, but
getting around the inefficienty and limit on clauses of a whole lot of OR
clauses: provide a qparser that accepts an in query.
fq={!in field=id}100,150,201,304,etc.
Could, it seems from Hoss et al's suggestions, be
Definitely interested in this.
The naive obvious approach would be just putting all the ID's in the query.
Like fq=(id:1 OR id:2 OR). Or making it another clause in the 'q'.
Can you outline what's wrong with this approach, to make it more clear what's
needed in a solution?
On Fri, Oct 15, 2010 at 11:49 AM, Burton-West, Tom tburt...@umich.edu wrote:
At the Lucene Revolution conference I asked about efficiently building a
filter query from an external list of Solr unique ids.
Yeah, I've thought about a special query parser and query to deal with
this (relatively)
-
From: Jonathan Rochkind [mailto:rochk...@jhu.edu]
Sent: Friday, October 15, 2010 1:07 PM
To: solr-user@lucene.apache.org
Subject: RE: filter query from external list of Solr unique IDs
Definitely interested in this.
The naive obvious approach would be just putting all the ID's
-Original Message-
From: Jonathan Rochkind [mailto:rochk...@jhu.edu]
Sent: Friday, October 15, 2010 1:07 PM
To: solr-user@lucene.apache.org
Subject: RE: filter query from external list of Solr unique IDs
Definitely interested in this.
The naive obvious approach would be just putting all
-Original Message-
From: ysee...@gmail.com [mailto:ysee...@gmail.com] On Behalf Of Yonik Seeley
Sent: Friday, October 15, 2010 1:19 PM
To: solr-user@lucene.apache.org
Subject: Re: filter query from external list of Solr unique IDs
On Fri, Oct 15, 2010 at 11:49 AM, Burton-West, Tom tburt
10 matches
Mail list logo