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
