hive-issues mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Jesus Camacho Rodriguez (JIRA)" <j...@apache.org>
Subject [jira] [Updated] (HIVE-20744) Use SQL constraints to improve join reordering algorithm
Date Tue, 06 Nov 2018 05:14:00 GMT

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

Jesus Camacho Rodriguez updated HIVE-20744:
-------------------------------------------
    Attachment: HIVE-20744.03.patch

> 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.01.patch, HIVE-20744.02.patch, HIVE-20744.03.patch, 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)

Mime
View raw message