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 <piersc...@gmail.com> wrote: > 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 it also > worked with multivalued fields. > Is there any way to do it? working with the streaming expression I managed > to do it with the following expression: > > innerJoin( > sort( > cartesianProduct( > > > search(census_defence_system,q="*:*",fl="id,defence_system,description,supplier",sort="id > asc",qt="/select",rows="1000"), > supplier > ), > by="supplier asc" > ), > sort( > cartesianProduct( > > search(census_components,q="*:*",fl="id,compoenent_name,supplier",sort="id > asc",qt="/select",rows="10000"), > supplier > ), > by="supplier asc" > ), > on="supplier" > ) > > suplier of course is a multivalued field. > > Is there a way to do this with parallel sql, and if not can we plan a new > feature to add it? I could also work on it . > > (version 7.4) > > Thank you >
