Actually, this does not sound like a federated search. It sounds like you want to pre-filter possible records with SQL query before doing the rest of the search in Solr. The simple option would be to see if Solr alone can handle it and avoid the complicated integration..
But if not, a custom search component (to inject pre-checked list of IDs as an FQ) or a custom Query Parser to provide the ids might be able to do the trick. If you are ok with post-filtering against SQL, so the Solr has to do a full search and you just save on re-hydrating and shipping the records, then you also have post-filters or upcoming xjoin https://issues.apache.org/jira/browse/SOLR-7341 . But yes, a custom translator of some sort looks inevitable if you want to implement your use case as described. Regards, Alex. ---- Newsletter and resources for Solr beginners and intermediates: http://www.solr-start.com/ On 31 December 2015 at 22:18, Mark Horninger <mhornin...@grayhairsoftware.com> wrote: > Thanks for the response, Alex. > > I am trying to accomplish a Federated search of SQL Server and Solr. I guess > I should have given more detail on this. > > The overall plan is to do the following: > 1. SSIS ETL data from multiple sources into SQL Server > 2. SSIS call to update Solr Indexing. > 3. SQL standard "=" matching when possible to reduce the candidate data set. > 4. Dismax match based on a rule set Joining SQL Server candidate dataset > against Solr indexing set using a join operator. > 5. Cache possible matches in SQL Server for a given record in order for a > human to disposition them. > > From what I read, Carrot is great for Solr clustering, but once you get into > RDBMS, you're out of luck. > > > > -----Original Message----- > From: Alexandre Rafalovitch [mailto:arafa...@gmail.com] > Sent: Thursday, December 31, 2015 12:44 AM > To: solr-user <solr-user@lucene.apache.org> > Subject: Re: Teiid with Solr - using any other engine except the > SolrDefaultQueryEngine > > Are you trying to do federated search? What about carrot? Not the one that > ships with Solr, the parent project. > > Regards, > Alex > On 31 Dec 2015 12:21 am, "Mark Horninger" <mhornin...@grayhairsoftware.com> > wrote: > >> I have gotten Teiid and Solr wired up, but it seems like the only way >> to query is with the default Solr Query Engine, and nothing else. In >> asking Dr. Google, this is a data black hole. The more I look at it, >> the more I think I'm going to end up having to write a custom >> translator. Is there anyone else out there who has had this >> challenge, and if so, how did you overcome it? >> >> Thanks In Advance! >> >> -Mark H. >>
