left anti join
a left anti join b :在查询过程中,剔除a表中和b表有交集的部分。
select a.col
from a
left anti join b
on a.col= b.col;
相当于文章来源:https://www.toymoban.com/news/detail-569896.html
select a.col
from a
left anti join b
on a.col= b.col;
where b.col is null;
demo文章来源地址https://www.toymoban.com/news/detail-569896.html
select
a.col,b.col
from
(
Select explode (array(1,2,3,4,5)) AS col
) a
left anti join
(
Select explode (array(1,2,3)) AS col
) b
on a.col=b.col
到了这里,关于hive anti用法的文章就介绍完了。如果您还想了解更多内容,请在右上角搜索TOY模板网以前的文章或继续浏览下面的相关文章,希望大家以后多多支持TOY模板网!