You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@hive.apache.org by "Prasanth Jayachandran (Jira)" <ji...@apache.org> on 2020/02/05 00:57:00 UTC
[jira] [Commented] (HIVE-22777) Sorted dynamic partition
optimization doesn't work if plan require implicit cast
[ https://issues.apache.org/jira/browse/HIVE-22777?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17030260#comment-17030260 ]
Prasanth Jayachandran commented on HIVE-22777:
----------------------------------------------
+1, lgtm.
> Sorted dynamic partition optimization doesn't work if plan require implicit cast
> --------------------------------------------------------------------------------
>
> Key: HIVE-22777
> URL: https://issues.apache.org/jira/browse/HIVE-22777
> Project: Hive
> Issue Type: Bug
> Components: Query Planning
> Reporter: Vineet Garg
> Assignee: Vineet Garg
> Priority: Major
> Labels: pull-request-available
> Attachments: HIVE-22777.1.patch, HIVE-22777.2.patch, HIVE-22777.3.patch, HIVE-22777.4.patch, HIVE-22777.5.patch
>
> Time Spent: 10m
> Remaining Estimate: 0h
>
> *Repro*
> set hive.stats.autogather=false;
> set hive.optimize.sort.dynamic.partition.threshold=1;
> set hive.optimize.bucketingsorting = true;
> {code:sql}
> drop table if exists t1_staging;
> create table t1_staging(
> a string,
> b int,
> c int,
> d string)
> partitioned by (e decimal(18,0))
> clustered by(a)
> into 256 buckets STORED AS TEXTFILE;
> load data local inpath '../../data/files/sortdp/000000_0' overwrite into table t1_staging partition (e=100);
> drop table t1_n147;
> create table t1_n147(
> a string,
> b decimal(6,0),
> c int,
> d string)
> partitioned by (e decimal(3,0))
> clustered by(a,b)
> into 10 buckets STORED AS ORC TBLPROPERTIES ('transactional'='true');
> set hive.stats.autogather=false;
> set hive.optimize.bucketingsorting = true;
> explain insert overwrite table t1_n147 partition(e) select a,b,c,d,e from t1_staging;
> {code}
--
This message was sent by Atlassian Jira
(v8.3.4#803005)