For <2> and <3> well, yes. To do _anything_ in Solr you need to index the data to Solr. It doesn't magically reach out into the DB and do stuff.
<3> you can either use DIH or a SolrJ program and yes, you do have to do some kind of mapping of database columns into Solr documents.... I want to caution you about this though. At first blush you're talking about just transferring your DB to Solr and pushing the search button. The ParallelSQL stuff builds SQL capabilities over _search_ so I'd advise spending some time thinking about how to leverage the _search_ bits rather than simply treating Solr as an RDBMS. Best, Erick On Mon, May 23, 2016 at 11:06 AM, Joel Bernstein <joels...@gmail.com> wrote: > The docs describe the current capabilities. So if it's not in the docs, > it's not supported yet. For example the docs don't mention joins or > intersections and they are not supported. Another example is that select > count(*) is supported, and select distinct is supported, but select > count(distinct) is not yet supported. So, give the docs a close read to > understand the current capabilities. > > Joel Bernstein > http://joelsolr.blogspot.com/ > > On Mon, May 23, 2016 at 5:54 PM, Steven White <swhite4...@gmail.com> wrote: > >> Hi everyone, >> >> I'm reading on Solr's Parallel SQL. I see some good examples but not much >> on how to set it up and what are the limitations. My reading on it is that >> I can use Parallel SQL to send to Solr SQL syntax to search in Solr, but: >> >> 1) Does this mean all of SQL's query statements are supported, no matter >> how complex? >> 2) If yes, doesn't this mean I have to index into Solr all of my tables in >> the DB? >> 3) If yes, how do I go about indexing my tables into Solr (i.e.: don't I >> have to map each table into a Solr document mapping each column into a Solr >> field, and what about the data-types)? >> >> Thanks. >> >> Steve >>
