[
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)
