SQL Joins in Parallel SQL Interface

["Aswath Srinivasan (TMS)" <as...@toyota.com>]

Hello,

I'm exploring the Parallel SQL. I don't see any SQL JOIN features available in the parallel SQL interface, in the documentation. Is it even possible to do SQL JOIN in the parallel SQL interface?

Was looking at streaming expression but looks like facets are not possible with it. Not even count(*) kind of operations?

Thank you,
Aswath NS

Re: SQL Joins in Parallel SQL Interface

[Joel Bernstein <jo...@gmail.com>]

Hi,

Parallel SQL does not yet support joins but Streaming Expressions does.

There are 4 types of aggregations in Streaming Expression currently. The
functions are:

facet: group by aggregations pushed down to the JSON facet API. Will not
work with joins.
https://cwiki.apache.org/confluence/display/solr/Streaming+Expressions#StreamingExpressions-facet

stats: aggregations without group by, pushed down to the stats component
https://cwiki.apache.org/confluence/display/solr/Streaming+Expressions#StreamingExpressions-stats

rollup: MapReduce group by aggregations which can be used with joins.
https://cwiki.apache.org/confluence/display/solr/Streaming+Expressions#StreamingExpressions-rollup

gatherNodes: graph query aggregations
https://cwiki.apache.org/confluence/display/solr/Graph+Traversal

Past discussion on rollup and joins:
http://lucene.472066.n3.nabble.com/Solr-6-Use-facet-with-Streaming-Expressions-LeftOuterJoin-td4290526.html



Joel Bernstein
http://joelsolr.blogspot.com/

On Wed, Sep 14, 2016 at 6:19 PM, Aswath Srinivasan (TMS) <
aswath.srinivasan@toyota.com> wrote:

> Hello,
>
> I'm exploring the Parallel SQL. I don't see any SQL JOIN features
> available in the parallel SQL interface, in the documentation. Is it even
> possible to do SQL JOIN in the parallel SQL interface?
>
> Was looking at streaming expression but looks like facets are not possible
> with it. Not even count(*) kind of operations?
>
> Thank you,
> Aswath NS
>
>