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 >