结论: 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
结果
image.png
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
结果
image.png
NULL 没有关联上
本文标题：Hive3.x测试_null跟null 关联问题
本文链接：https://www.haomeiwen.com/subject/bzyvxjtx.html
网友评论