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

• Type: Bug
• Status: Closed
• Priority: Critical
• Resolution: Fixed
• Affects Version/s: 2.1.0, 2.2.0
• Fix Version/s: 2.1.0
• Component/s: Physical Optimizer
• Target Version/s: 2.1.0
• Assignee: Jesús Camacho Rodríguez
• Reporter: Jesús Camacho Rodríguez
• Created: 25/May/16 16:58
• Updated: 27/Feb/24 22:23
• Resolved: 30/May/16 23:08

Description

To reproduce:

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;

CC'ed ashutoshc, ekoifman