Re: Solr 6.0 Parallel SQL

2016-05-23 Thread Erick Erickson
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 caut

Re: Solr 6.0 Parallel SQL

2016-05-23 Thread Joel Bernstein
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

Solr 6.0 Parallel SQL

2016-05-23 Thread Steven White
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 support