Hive3.x测试_null跟null 关联问题

结论: hive当中null与null 无法进行关联

with tmp_A as (
select  null as id ,'a' name
union all
select  1 as id ,'b' name
    )
select * from tmp_A  t1 join tmp_A t2
on t1.id = t2.id

结果

NULL 没有关联上