Hive 中 insert into 与with as连用

写法如下,注意insert into的位置

with a as (select * from few_ints where x = 2)
insert
into few_ints
select *
from a;

如下写法是会报错的

insert into few_ints
with a as (select * from few_ints where x = 2)
select *
from a;

报错信息如下

org.apache.hadoop.hive.ql.parse.ParseException:
line 2:0 cannot recognize input near 'with' 'a' 'as' in statement

参考

Hive踩过的坑-Hive的insert与with as 语句搭配 – 记忆角落