with as 语句-hive

官网链接 ：https://cwiki.apache.org/confluence/display/Hive/Common+Table+Expression#app-switcher

-- 格式
-- 查询中使用
with t1 as (
     select 'vivo' as channel,'2021-09-02' as credit_date
),
t2 as (
     select 'oppo' as channel,'2021-09-01' as credit_date
)
select * from t1
union all
select * from t2;

-- create table 中使用
create table mdw_tmp.tmp_with_test_tab as
with t1 as (
     select 'vivo' as channel,'2021-09-02' as credit_date
),
t2 as (
     select 'oppo' as channel,'2021-09-01' as credit_date
)
select * from t1
union all
select * from t2;

-- insert into 中使用
with t1 as (
     select 'vivo' as channel,'2021-09-02' as credit_date
),
t2 as (
     select 'oppo' as channel,'2021-09-01' as credit_date
)
insert into mdw_tmp.tmp_with_test_tab
select * from t1
union all
select * from t2;