Hive full join 对数排查异常数据

最新推荐文章于 2024-03-28 15:32:13 发布

二十六画生的博客

最新推荐文章于 2024-03-28 15:32:13 发布

阅读量527

点赞数

本文链接：https://blog.csdn.net/u010002184/article/details/117521652

版权

Hive Spark Hadoop MapReduce 专栏收录该内容

162 篇文章 2 订阅 ¥29.90 ¥99.00

订阅专栏

超级会员免费看

本文主要讨论了在使用Hive进行full join操作时遇到的对数异常数据排查过程。通过对一、二、三等关键步骤的分析，揭示了如何定位和解决这类问题。

摘要由CSDN通过智能技术生成

select 
t1.*,
t2.*
from (
select  1 as c1 , 'a' as c2 
union all 
select  2 as c1 , 'b' as c2 
union all 
select  3 as c1 , null as c2 
union all 
select  4 as c1 , 'd' as c2 
)t1 
full join 
(
select  2 as c1 , 'b' as c2 
union all 
select  3 as c1 , null as c2 
union all 
select  4 as c1 , 'd4' as c2 
union all 
select  5 as c1 , 'e' as c2 
)t2 
on t1.c1 = t2.c1 
order by coalesce(t1.c1 , t2.c1 ) ; -- 5条记录


select 
t1.*,
t2.*
from (
select  1 as c1 , 'a' as c2 
union all 
select  2 as c1 , 'b' as c2 
union all 
select  3 as c1 , null as c2 
union all 
select  4 as c1 , 'd' as c2 
)t1 
full join 
(
select  2 as c1 , 'b' as c2 
union all 
select  3 as c1 , null as

了解本专栏