[jira] [Created] (HIVE-22777) Sorted dynamic partition optimization doesn't work if plan require implicit cast

[Vineet Garg (Jira)]

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)