今天在使用hive3.3的时候,hive语法报错
image.png报错场景
with tmp_1 as(select A from table_A ),
tmp_2 as((select B from table_B )
insert overwrite table_C partition (dt = '2024-03-01' )
selecet A from tmp_1
union all
selecet B from tmp_2
解决方法 后面加limit
with tmp_1 as(select A from table_A ),
tmp_2 as((select B from table_B )
insert overwrite table_C partition (dt = '2024-03-01' )
selecet A from tmp_1
union all
selecet B from tmp_2
limit 10000000
网友评论