hive中判断这批文件是否存在另一批文件逻辑
数据
我有两列字符串,
判断第二列是否在第一列
被判断: id, 123456789
标准: id, 42562
建表语句
create table a (id string) row format delimited fields terminated by "/t";
load data local inpath "/root/a.txt" overwrite into table a;
create table b (id string) row format delimited fields terminated by "/t";
load data local inpath "/root/b.txt" overwrite into table b;
逻辑
select
t.aid ,
if(t.bid is not null,'Y','N')
from
(
select
a.id as aid,
b.id as bid
from
a left join b on a.id = b.id
)t ;