hive-dev mailing list archives

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

     [ 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)

Mime
View raw message