[
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)
