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

Posted to dev@hive.apache.org by "Jesus Camacho Rodriguez (JIRA)" <ji...@apache.org> on 2018/10/14 16:04:00 UTC

[jira] [Created] (HIVE-20744) Use SQL constraints to improve join reordering algorithm

Jesus Camacho Rodriguez created HIVE-20744:
----------------------------------------------

             Summary: Use SQL constraints to improve join reordering algorithm
                 Key: HIVE-20744
                 URL: https://issues.apache.org/jira/browse/HIVE-20744
             Project: Hive
          Issue Type: Bug
          Components: CBO
            Reporter: Jesus Camacho Rodriguez
            Assignee: Jesus Camacho Rodriguez


Till now, it was all based on stats stored for the base tables and their columns. Now the optimizer can rely on constraints. Hence, this patch is for the join reordering costing to use constraints, and if it does not find any, rely on old code path.



--
This message was sent by Atlassian JIRA
(v7.6.3#76005)