[HIVE-5690] Support subquery for single sourced multi query

• Type: Improvement
• Status: Patch Available
• Priority: Critical
• Resolution: Unresolved
• Component/s: Query Processor
• Assignee: Navis Ryu
• Reporter: Navis Ryu
• Created: 30/Oct/13 02:14
• Updated: 09/May/15 00:11

Description

Single sourced multi (insert) query is very useful for various ETL processes but it does not allow subqueries included. For example,

explain from src 
insert overwrite table x1 select * from (select distinct key,value) b order by key
insert overwrite table x2 select * from (select distinct key,value) c order by value;

Issue Links

• relates to: HIVE-7641 INSERT ... SELECT with no source table leads to NPE
• links to: review board