hive-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Raj Bains (JIRA)" <j...@apache.org>
Subject [jira] [Commented] (HIVE-1398) Support union all without an outer select *
Date Tue, 02 Dec 2014 19:35:12 GMT

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

Raj Bains commented on HIVE-1398:
---------------------------------

Looks like it is fixed in Hive 0.14

hive> insert into table foo1 select a,b from foo1 union all select a,b from foo3;
Query ID = rbains_20141202142626_58807159-1762-4855-aa36-3fc3803b9ab7
Total jobs = 1
Launching Job 1 out of 1


Status: Running (application id: application_1414029100044_2856)

Map 1: -/-	Map 3: -/-
Status: Finished successfully
Loading data to table default.foo1
Table default.foo1 stats: [numFiles=4, numRows=0, totalSize=0, rawDataSize=0]
OK
Time taken: 2.575 seconds
hive> insert into table foo1 select a,b from foo1 union all select x as a,y as b from foo2;
Query ID = rbains_20141202143333_daaf52e4-7b15-413f-a0de-9b192cee2fcd
Total jobs = 1
Launching Job 1 out of 1


Status: Running (application id: application_1414029100044_2856)

Map 1: -/-	Map 3: -/-
Status: Finished successfully
Loading data to table default.foo1
Table default.foo1 stats: [numFiles=6, numRows=0, totalSize=0, rawDataSize=0]
OK
Time taken: 2.396 seconds
hive>


hive> insert into table foo1 select a,b from foo1 union all select x as a,y as b from foo2;
Query ID = rbains_20141202143333_daaf52e4-7b15-413f-a0de-9b192cee2fcd
Total jobs = 1
Launching Job 1 out of 1


Status: Running (application id: application_1414029100044_2856)

Map 1: -/-	Map 3: -/-
Status: Finished successfully
Loading data to table default.foo1
Table default.foo1 stats: [numFiles=6, numRows=0, totalSize=0, rawDataSize=0]
OK
Time taken: 2.396 seconds
hive>

> Support union all without an outer select *
> -------------------------------------------
>
>                 Key: HIVE-1398
>                 URL: https://issues.apache.org/jira/browse/HIVE-1398
>             Project: Hive
>          Issue Type: Improvement
>          Components: Query Processor
>            Reporter: Ashish Thusoo
>            Assignee: Ashish Thusoo
>              Labels: SQL
>
> In hive for union alls the query has to be wrapped in an sub query as shown below:
> select * from 
> (select c1 from t1
>   union all
>   select c2 from t2);
> This JIRA proposes to fix that to support
> select c1 from t1
> union all
> select c2 from t2;



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)

Mime
View raw message