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.sriniva...@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 > >
