hive with as，

hive with as，

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;