[jira] [Created] (HIVE-13849) Wrong plan for hive.optimize.sort.dynamic.partition=true

["Jesus Camacho Rodriguez (JIRA)" <ji...@apache.org>]

Jesus Camacho Rodriguez created HIVE-13849:
----------------------------------------------

             Summary: Wrong plan for hive.optimize.sort.dynamic.partition=true
                 Key: HIVE-13849
                 URL: https://issues.apache.org/jira/browse/HIVE-13849
             Project: Hive
          Issue Type: Bug
          Components: Physical Optimizer
    Affects Versions: 2.1.0, 2.2.0
            Reporter: Jesus Camacho Rodriguez
            Assignee: Jesus Camacho Rodriguez
            Priority: Critical


To reproduce:

{noformat}
set hive.support.concurrency=true;
set hive.txn.manager=org.apache.hadoop.hive.ql.lockmgr.DbTxnManager;
set hive.exec.dynamic.partition.mode=nonstrict;
set hive.optimize.sort.dynamic.partition=true;

CREATE TABLE non_acid(key string, value string) PARTITIONED BY(ds string, hr int) CLUSTERED BY(key) INTO 2 BUCKETS STORED AS ORC;

explain insert into table non_acid partition(ds,hr) select * from srcpart sort by value;
{noformat}

CC'ed [~ashutoshc], [~ekoifman]



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