[jira] [Commented] (TAJO-1683) Improve join order optimization of a query involving multiple commutative joins and non-commutative joins

["Jihoon Son (JIRA)" <ji...@apache.org>]

    [ https://issues.apache.org/jira/browse/TAJO-1683?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14625909#comment-14625909 ] 

Jihoon Son commented on TAJO-1683:
----------------------------------

To address this problem, the query optimizer should first find the commutative join groups that consist of only commutative joins and thus joins can be enumerated in any order within a group.

> Improve join order optimization of a query involving multiple commutative joins and non-commutative joins
> ---------------------------------------------------------------------------------------------------------
>
>                 Key: TAJO-1683
>                 URL: https://issues.apache.org/jira/browse/TAJO-1683
>             Project: Tajo
>          Issue Type: Improvement
>          Components: planner/optimizer
>            Reporter: Jihoon Son
>
> TAJO-1352 is the issue to improve our join order optimization, but has a limitation. That is, when a query involves multiple commutative joins and non-commutative joins, the join order of commutative joins is fixed in an order of in an order of their occurrences in the query without optimization process. 
> This should be improved because the response time of a query will be highly increased due to the suboptimal join order as the query involves multiple joins.



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)