【无标题】

__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.youkuaiyun.com/u011204487/article/details/88954295
我将自己的错误案例补充