这个屌丝很懒，什么也没留下！

Hive 中 insert into 与with as连用_insert into with

作者：Li_阴宅 | 2024-08-07 12:13:12

insert into with

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

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

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

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

声明：本文内容由网友自发贡献，不代表【wpsshop博客】立场，版权归原作者所有，本站不承担相应法律责任。如您发现有侵权的内容，请联系我们。转载请注明出处：https://www.wpsshop.cn/w/Li_阴宅/article/detail/942465