[ https://issues.apache.org/jira/browse/BEAM-7685?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Alireza Samadianzakaria updated BEAM-7685: ------------------------------------------ Description: Query Parser does not reorder joins based on their costs. The fix is simple we need to include the rules that are related to reordering joins such as JoinCommuteRule. However, reordering joins may produce plans that has Cross Join or other not supported types of join. We should either rewrite those rules to consider that or return infinite cost for those types of joins so that they will not be selected (was: Query Parser does not reorder joins based on their costs. The fix is simple we need to include the rules that are related to reordering joins such as JoinCommuteRule.) > Join Reordering > --------------- > > Key: BEAM-7685 > URL: https://issues.apache.org/jira/browse/BEAM-7685 > Project: Beam > Issue Type: Bug > Components: dsl-sql > Reporter: Alireza Samadianzakaria > Assignee: Alireza Samadianzakaria > Priority: Major > > Query Parser does not reorder joins based on their costs. The fix is simple > we need to include the rules that are related to reordering joins such as > JoinCommuteRule. However, reordering joins may produce plans that has Cross > Join or other not supported types of join. We should either rewrite those > rules to consider that or return infinite cost for those types of joins so > that they will not be selected -- This message was sent by Atlassian JIRA (v7.6.3#76005)