[jira] [Updated] (HIVE-15771) CBO chooses wrong join order for TPC-DS query72
[ https://issues.apache.org/jira/browse/HIVE-15771?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Pengcheng Xiong updated HIVE-15771: --- Target Version/s: 3.0.0 (was: 2.2.0) > CBO chooses wrong join order for TPC-DS query72 > --- > > Key: HIVE-15771 > URL: https://issues.apache.org/jira/browse/HIVE-15771 > Project: Hive > Issue Type: Bug > Components: CBO >Affects Versions: 2.2.0 >Reporter: Prasanth Jayachandran >Priority: Critical > Attachments: q72-explain.txt, q72-mod-explain.txt, q72-mod.svg, > q72.svg, query72-mod.sql, query72.sql > > > Query72 of TPC-DS on 1TB scale generates wrong join order resulting in > increased query execution time. It chooses fact-to-fact table join followed > by joins with dimension tables as opposed to doing map-join with dimension > tables first and doing the fact-to-fact table join at the last. > Please find attachment for the join order selected by CBO vs rewritten query > with expected join order. -- This message was sent by Atlassian JIRA (v6.3.15#6346)
[jira] [Updated] (HIVE-15771) CBO chooses wrong join order for TPC-DS query72
[ https://issues.apache.org/jira/browse/HIVE-15771?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Prasanth Jayachandran updated HIVE-15771: - Description: Query72 of TPC-DS on 1TB scale generates wrong join order resulting in increased query execution time. It chooses fact-to-fact table join followed by joins with dimension tables as opposed to doing map-join with dimension tables first and doing the fact-to-fact table join at the last. Please find attachment for the join order selected by CBO vs rewritten query with expected join order. was: Query72 of TPC-DS on 1TB scale generates wrong join order resulting in increased query execution time. It chooses fact-to-fact table join followed by joins with dimension tables as opposed to doing map-join with dimension tables first and doing the fact-to-fact table join at the last. Please find attachment for the join order selected by CBO vs rewritten query with correct join order. > CBO chooses wrong join order for TPC-DS query72 > --- > > Key: HIVE-15771 > URL: https://issues.apache.org/jira/browse/HIVE-15771 > Project: Hive > Issue Type: Bug > Components: CBO >Affects Versions: 2.2.0 >Reporter: Prasanth Jayachandran >Priority: Critical > Attachments: q72-explain.txt, q72-mod-explain.txt, q72-mod.svg, > q72.svg, query72-mod.sql, query72.sql > > > Query72 of TPC-DS on 1TB scale generates wrong join order resulting in > increased query execution time. It chooses fact-to-fact table join followed > by joins with dimension tables as opposed to doing map-join with dimension > tables first and doing the fact-to-fact table join at the last. > Please find attachment for the join order selected by CBO vs rewritten query > with expected join order. -- This message was sent by Atlassian JIRA (v6.3.15#6346)
[jira] [Updated] (HIVE-15771) CBO chooses wrong join order for TPC-DS query72
[ https://issues.apache.org/jira/browse/HIVE-15771?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Prasanth Jayachandran updated HIVE-15771: - Attachment: query72.sql query72-mod.sql q72.svg q72-mod.svg q72-mod-explain.txt q72-explain.txt > CBO chooses wrong join order for TPC-DS query72 > --- > > Key: HIVE-15771 > URL: https://issues.apache.org/jira/browse/HIVE-15771 > Project: Hive > Issue Type: Bug > Components: CBO >Affects Versions: 2.2.0 >Reporter: Prasanth Jayachandran >Priority: Critical > Attachments: q72-explain.txt, q72-mod-explain.txt, q72-mod.svg, > q72.svg, query72-mod.sql, query72.sql > > > Query72 of TPC-DS on 1TB scale generates wrong join order resulting in > increased query execution time. It chooses fact-to-fact table join followed > by joins with dimension tables as opposed to doing map-join with dimension > tables first and doing the fact-to-fact table join at the last. > Please find attachment for the join order selected by CBO vs rewritten query > with correct join order. -- This message was sent by Atlassian JIRA (v6.3.15#6346)