[jira] [Created] (SOLR-16239) Add Join query plans to Solr SQL

["Joel Bernstein (Jira)" <ji...@apache.org>]

Joel Bernstein created SOLR-16239:
-------------------------------------

             Summary: Add Join query plans to Solr SQL
                 Key: SOLR-16239
                 URL: https://issues.apache.org/jira/browse/SOLR-16239
             Project: Solr
          Issue Type: New Feature
      Security Level: Public (Default Security Level. Issues are Public)
          Components: Parallel SQL
            Reporter: Joel Bernstein


This is an umbrella ticket for adding join query plans for Solr SQL.

Solr 9 has significant performance improvements to the export handler. These improvements were done in part to support fast distributed joins in Solr SQL. 

Streaming Expressions already supports hash joins and merge joins and has limited support for nested loop joins (fetch). What needs to be done is to add Rules to the Calcite planner that pushes the joins down to the SQL handler.

Calcite also has the ability to execute joins so part of this work will also be to gracefully fall back to the Calcites join engine. 



--
This message was sent by Atlassian Jira
(v8.20.7#820007)

---------------------------------------------------------------------
To unsubscribe, e-mail: issues-unsubscribe@solr.apache.org
For additional commands, e-mail: issues-help@solr.apache.org