Prasanth Jayachandran created HIVE-15771: --------------------------------------------
Summary: 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 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)