[
https://issues.apache.org/jira/browse/SOLR-16239?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Joel Bernstein updated SOLR-16239:
----------------------------------
Description:
This is an umbrella ticket for adding join query plans for Solr SQL.
Solr 9 adds 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 Calcite's join engine.
was:
This is an umbrella ticket for adding join query plans for Solr SQL.
Solr 9 adds 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.
> 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
> Priority: Major
> Labels: RobustSQL
>
> This is an umbrella ticket for adding join query plans for Solr SQL.
> Solr 9 adds 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 Calcite's join engine.
--
This message was sent by Atlassian Jira
(v8.20.7#820007)
---------------------------------------------------------------------
To unsubscribe, e-mail: issues-unsubscr...@solr.apache.org
For additional commands, e-mail: issues-h...@solr.apache.org
