hive-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Ashutosh Chauhan (JIRA)" <j...@apache.org>
Subject [jira] [Updated] (HIVE-8395) CBO: enable by default
Date Sat, 15 Nov 2014 02:47:34 GMT

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

Ashutosh Chauhan updated HIVE-8395:
-----------------------------------
    Attachment: HIVE-8395.23.withon.patch

Went through this list. Good news is in all of tests query results are correct. So, no correctness
issue. In most cases, plan changes looks benign so we can turn on cbo on for those. For some
plan changed for worse as some specific optimizations didnt fire. For those, we should file
follow-up jiras. Those jiras are :
* clientnegative/joinneg.q : Error message is incorrect.
* infer_bucket_sort.q : Inferred bucketing / sorting properties looks incorrect.
* join12.q : n-way join got disabled.
* partition_wise_fileformat2.q : partition pruning got disabled
* ppd_join3.q : n-way join got disabled
* ppd_outer_join4.q : n-way join got diabled

For rest of .q files, plan either stayed same (with column renames) or changed for better
(except for Select Operator HIVE-8435) for those we can turn on CBO.

I am attaching addendum patch which contains updated .q.out files with cbo turned on. [~sershe]
you can merge this in your patch.

> CBO: enable by default
> ----------------------
>
>                 Key: HIVE-8395
>                 URL: https://issues.apache.org/jira/browse/HIVE-8395
>             Project: Hive
>          Issue Type: Improvement
>          Components: CBO
>            Reporter: Sergey Shelukhin
>            Assignee: Sergey Shelukhin
>             Fix For: 0.15.0
>
>         Attachments: HIVE-8395.01.patch, HIVE-8395.02.patch, HIVE-8395.03.patch, HIVE-8395.04.patch,
HIVE-8395.05.patch, HIVE-8395.06.patch, HIVE-8395.07.patch, HIVE-8395.08.patch, HIVE-8395.09.patch,
HIVE-8395.10.patch, HIVE-8395.11.patch, HIVE-8395.12.patch, HIVE-8395.12.patch, HIVE-8395.13.patch,
HIVE-8395.13.patch, HIVE-8395.14.patch, HIVE-8395.15.patch, HIVE-8395.16.patch, HIVE-8395.17.patch,
HIVE-8395.18.patch, HIVE-8395.18.patch, HIVE-8395.19.patch, HIVE-8395.20.patch, HIVE-8395.21.patch,
HIVE-8395.22.patch, HIVE-8395.23.patch, HIVE-8395.23.withon.patch, HIVE-8395.patch
>
>




--
This message was sent by Atlassian JIRA
(v6.3.4#6332)

Mime
View raw message