hive-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Navis (JIRA)" <j...@apache.org>
Subject [jira] [Created] (HIVE-5690) Support subquery for single sourced multi query
Date Wed, 30 Oct 2013 02:15:25 GMT
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)

Mime
View raw message