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

["Phabricator (JIRA)" <ji...@apache.org>]

     [ https://issues.apache.org/jira/browse/HIVE-5690?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Phabricator updated HIVE-5690:
------------------------------

    Attachment: D13791.1.patch

navis requested code review of "HIVE-5690 [jira] Support subquery for single sourced multi query".

Reviewers: JIRA

logs

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;

TEST PLAN
  EMPTY

REVISION DETAIL
  https://reviews.facebook.net/D13791

AFFECTED FILES
  build.properties
  ql/src/java/org/apache/hadoop/hive/ql/parse/FromClauseParser.g
  ql/src/java/org/apache/hadoop/hive/ql/parse/HiveParser.g
  ql/src/java/org/apache/hadoop/hive/ql/parse/QB.java
  ql/src/java/org/apache/hadoop/hive/ql/parse/QBParseInfo.java
  ql/src/java/org/apache/hadoop/hive/ql/parse/SemanticAnalyzer.java
  ql/src/test/queries/clientpositive/multi_insert_subquery.q
  ql/src/test/results/clientpositive/multi_insert_subquery.q.out

MANAGE HERALD RULES
  https://reviews.facebook.net/herald/view/differential/

WHY DID I GET THIS EMAIL?
  https://reviews.facebook.net/herald/transcript/41733/

To: JIRA, navis


> 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
>         Attachments: D13791.1.patch
>
>
> 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)