hive-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Navis (JIRA)" <j...@apache.org>
Subject [jira] [Commented] (HIVE-5690) Support subquery for single sourced multi query
Date Mon, 15 Sep 2014 05:30:34 GMT

    [ https://issues.apache.org/jira/browse/HIVE-5690?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14133598#comment-14133598
] 

Navis commented on HIVE-5690:
-----------------------------

The top-level FROM clause(TOK_FROM_BASE) would be used for any missing "fromSource" in following
insert query.  In current implementation, join operation is not possible with missing "fromSource",
but can be implemented like above. Would it be too complex? 

> 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, HIVE-5690.10.patch.txt, HIVE-5690.11.patch.txt,
HIVE-5690.12.patch.txt, HIVE-5690.13.patch.txt, HIVE-5690.2.patch.txt, HIVE-5690.3.patch.txt,
HIVE-5690.4.patch.txt, HIVE-5690.5.patch.txt, HIVE-5690.6.patch.txt, HIVE-5690.7.patch.txt,
HIVE-5690.8.patch.txt, HIVE-5690.9.patch.txt
>
>
> 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.3.4#6332)

Mime
View raw message