__HIVE_DEFAULT_PARTITION__报错
insert into table A
select t1.date
from(select num,date from clauseA) t1
right join
(select num,date from clauseB) t2
on t1.a=t2.a;
由于表 t1 匹配数据均为空值,所以报错,解决方案,因为博主仍需要t1的空值数据,故更正如下
insert into table A
select t2.date
from(select num,date from clauseA) t1
right join
(select num,date from clauseB) t2
on t1.a=t2.a;
原文来自https://blog.csdn.net/u011204487/article/details/88954295
我将自己的错误案例补充