hive union all嵌套使用

2015/06/18 45166

清华大佬耗费三个月吐血整理的几百G的资源，免费分享！....>>>

?
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
select id from (
    select a.id from
    (
    select 1 as id from dua
    union all
    select 2 as id from dua
    ) a join
    (select 4 as id from dua) f on a.id =f.id
union all
    select b.id from
    (
    select 1 as id from dua
    union all
    select 2 as id from dua
    ) b join
    (select 3 as id from dua) e on b.id =e.id
) c