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

Posted to issues@hive.apache.org by "Jesus Camacho Rodriguez (JIRA)" <ji...@apache.org> on 2018/10/24 17:47:00 UTC

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

     [ https://issues.apache.org/jira/browse/HIVE-20744?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Work on HIVE-20744 started by Jesus Camacho Rodriguez.
------------------------------------------------------
> 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
>            Priority: Major
>         Attachments: HIVE-20744.patch
>
>
> 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)