Vineet Garg created HIVE-22777: ---------------------------------- Summary: 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
*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)