[ 
https://issues.apache.org/jira/browse/HIVE-8395?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14212955#comment-14212955
 ] 

Ashutosh Chauhan commented on HIVE-8395:
----------------------------------------

Currently, 
{code}
$ grep -R "hive.cbo.enable=false" ql/src/test/queries/ 
ql/src/test/queries//clientnegative/join_nonexistent_part.q:set 
hive.cbo.enable=false;
ql/src/test/queries//clientnegative/joinneg.q:set hive.cbo.enable=false;
ql/src/test/queries//clientpositive/annotate_stats_groupby.q:set 
hive.cbo.enable=false;
ql/src/test/queries//clientpositive/annotate_stats_groupby2.q:set 
hive.cbo.enable=false;
ql/src/test/queries//clientpositive/constprog2.q:set hive.cbo.enable=false;
ql/src/test/queries//clientpositive/correlationoptimizer8.q:set 
hive.cbo.enable=false;
ql/src/test/queries//clientpositive/filter_join_breaktask2.q:set 
hive.cbo.enable=false;
ql/src/test/queries//clientpositive/infer_bucket_sort.q:set 
hive.cbo.enable=false;
ql/src/test/queries//clientpositive/infer_bucket_sort_reducers_power_two.q:set 
hive.cbo.enable=false;
ql/src/test/queries//clientpositive/join12.q:set hive.cbo.enable=false;
ql/src/test/queries//clientpositive/list_bucket_dml_1.q:set 
hive.cbo.enable=false;
ql/src/test/queries//clientpositive/list_bucket_dml_10.q:set 
hive.cbo.enable=false;
ql/src/test/queries//clientpositive/list_bucket_dml_11.q:set 
hive.cbo.enable=false;
ql/src/test/queries//clientpositive/list_bucket_dml_12.q:set 
hive.cbo.enable=false;
ql/src/test/queries//clientpositive/list_bucket_dml_13.q:set 
hive.cbo.enable=false;
ql/src/test/queries//clientpositive/list_bucket_dml_14.q:set 
hive.cbo.enable=false;
ql/src/test/queries//clientpositive/list_bucket_dml_2.q:set 
hive.cbo.enable=false;
ql/src/test/queries//clientpositive/list_bucket_dml_3.q:set 
hive.cbo.enable=false;
ql/src/test/queries//clientpositive/list_bucket_dml_4.q:set 
hive.cbo.enable=false;
ql/src/test/queries//clientpositive/list_bucket_dml_5.q:set 
hive.cbo.enable=false;
ql/src/test/queries//clientpositive/list_bucket_dml_6.q:set 
hive.cbo.enable=false;
ql/src/test/queries//clientpositive/list_bucket_dml_7.q:set 
hive.cbo.enable=false;
ql/src/test/queries//clientpositive/list_bucket_dml_8.q:set 
hive.cbo.enable=false;
ql/src/test/queries//clientpositive/list_bucket_dml_9.q:set 
hive.cbo.enable=false;
ql/src/test/queries//clientpositive/list_bucket_query_multiskew_1.q:set 
hive.cbo.enable=false;
ql/src/test/queries//clientpositive/list_bucket_query_multiskew_2.q:set 
hive.cbo.enable=false;
ql/src/test/queries//clientpositive/list_bucket_query_multiskew_3.q:set 
hive.cbo.enable=false;
ql/src/test/queries//clientpositive/list_bucket_query_oneskew_1.q:set 
hive.cbo.enable=false;
ql/src/test/queries//clientpositive/list_bucket_query_oneskew_2.q:set 
hive.cbo.enable=false;
ql/src/test/queries//clientpositive/list_bucket_query_oneskew_3.q:set 
hive.cbo.enable=false;
ql/src/test/queries//clientpositive/optimize_nullscan.q:set 
hive.cbo.enable=false;
ql/src/test/queries//clientpositive/partition_wise_fileformat2.q:set 
hive.cbo.enable=false;
ql/src/test/queries//clientpositive/ppd_join3.q:set hive.cbo.enable=false;
ql/src/test/queries//clientpositive/ppd_outer_join4.q:set hive.cbo.enable=false;
ql/src/test/queries//clientpositive/ql_rewrite_gbtoidx.q:set 
hive.cbo.enable=false;
ql/src/test/queries//clientpositive/subquery_exists_explain_rewrite.q:set 
hive.cbo.enable=false;
ql/src/test/queries//clientpositive/subquery_in_explain_rewrite.q:set 
hive.cbo.enable=false;
ql/src/test/queries//clientpositive/test5.q:set hive.cbo.enable=false;
ql/src/test/queries//clientpositive/truncate_column_list_bucket.q:set 
hive.cbo.enable=false;
{code}
I am doing a quick survey of these queries to see if we can turn back cbo on 
for these ones.

> 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.patch
>
>




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

Reply via email to