You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@solr.apache.org by "Joel Bernstein (Jira)" <ji...@apache.org> on 2022/06/06 13:39:00 UTC
[jira] [Updated] (SOLR-16239) Add Join query plans to Solr SQL
[ 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 the Calcites join engine.
was:
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.
> 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 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