You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@ignite.apache.org by "Vladimir Ozerov (JIRA)" <ji...@apache.org> on 2018/11/16 17:43:00 UTC
[jira] [Created] (IGNITE-10306) SQL: Transform subqueries to JOINs
when possible
Vladimir Ozerov created IGNITE-10306:
----------------------------------------
Summary: SQL: Transform subqueries to JOINs when possible
Key: IGNITE-10306
URL: https://issues.apache.org/jira/browse/IGNITE-10306
Project: Ignite
Issue Type: Task
Components: sql
Reporter: Vladimir Ozerov
Fix For: 2.8
Currently subqueries are mostly not analyzed in any way. This makes our distributed execution plan more complex to analyze and execute. Moreover, we cannot extract partition information from such queries efficiently. We need to apply the simplest "JOIN conversion" optimization on early query analysis phase and try to transform our AST from subquery to join.
This should be done before partition extraction, pushdowns and splitter. See [1] for more information.
[1] https://cwiki.apache.org/confluence/display/IGNITE/IEP-24%3A+SQL+Partition+Pruning
--
This message was sent by Atlassian JIRA
(v7.6.3#76005)