Re: Parallel SQL join on multivalue fields

2020-07-01 Thread Piero Scrima
the reason why JOIN works is because of the Calcite framework. The parallel sql features leverages Calcite, which implements all the sql features, all you need is to provide the way for calcite to get the collection/table, in solr this is done by the SolrTable.java (package org.apache.solr.handler.

Re: Parallel SQL join on multivalue fields

2020-07-01 Thread Joel Bernstein
There isn't any real support for joins in Parallel SQL currently. I'm surprised that you're having some success doing them. Can you provide a sample SQL join that is working for you? Joel Bernstein http://joelsolr.blogspot.com/ On Fri, Jun 26, 2020 at 3:32 AM Piero Scrima wrote: > Hi, > > Al

Parallel SQL join on multivalue fields

2020-06-26 Thread Piero Scrima
Hi, Although there is no trace of join functionality in the official Solr documentation (https://lucene.apache.org/solr/guide/7_4/parallel-sql-interface.html), joining in parallel sql works in practice. It only works if the field is not a multivalued field. For my project it would be fantastic if

Parallel SQL join on multivalue fields

2020-06-25 Thread Piero Scrima
Dear all, Although there is no trace of join functionality in the official Solr documentation (https://lucene.apache.org/solr/guide/7_4/parallel-sql-interface.html), joining in parallel sql works in practice. It only works if the field is not a multivalued field. For my project it would be fantast