hive 可以用with as的方法把表加入内存,其他语句可以随时使用。
with q1 as (select * from src where key= ‘5’),
q2 as (select * from src s2 where key = ‘4’)
select * from q1 union all select * from q2;
hive 可以用with as的方法把表加入内存,其他语句可以随时使用。
with q1 as (select * from src where key= ‘5’),
q2 as (select * from src s2 where key = ‘4’)
select * from q1 union all select * from q2;