ignite-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Vladimir Ozerov (JIRA)" <j...@apache.org>
Subject [jira] [Created] (IGNITE-10306) SQL: Transform subqueries to JOINs when possible
Date Fri, 16 Nov 2018 17:43:00 GMT
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)

Mime
View raw message