You are viewing a plain text version of this content. The canonical link for it is here.

Posted to dev@hive.apache.org by "Navis (JIRA)" <ji...@apache.org> on 2013/10/30 03:15:25 UTC

[jira] [Created] (HIVE-5690) Support subquery for single sourced multi query

Navis created HIVE-5690:
---------------------------

             Summary: Support subquery for single sourced multi query
                 Key: HIVE-5690
                 URL: https://issues.apache.org/jira/browse/HIVE-5690
             Project: Hive
          Issue Type: Improvement
          Components: Query Processor
            Reporter: Navis
            Assignee: Navis
            Priority: Minor


Single sourced multi (insert) query is very useful for various ETL processes but it does not allow subqueries included. For example, 
{noformat}
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;
{noformat}



--
This message was sent by Atlassian JIRA
(v6.1#6144)