You are viewing a plain text version of this content. The canonical link for it is here.

Posted to dev@hive.apache.org by "Prasanth Jayachandran (JIRA)" <ji...@apache.org> on 2017/01/31 23:11:52 UTC

[jira] [Created] (HIVE-15771) CBO chooses wrong join order for TPC-DS query72

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)