Hive实现类似不等连接的方式
left join
(
select c1,c2,c3
from table
where ds = '${yyyyMMdd,-1d}'
group by c1,c2,c3
) t1
on (TRUE)
WHERe LOCATE(t.c1,t1.c1)>0
and LOCATE(t.c2,t1.c2)>0
and t.c3 = t1.c3
Hive实现类似不等连接的方式
left join
(
select c1,c2,c3
from table
where ds = '${yyyyMMdd,-1d}'
group by c1,c2,c3
) t1
on (TRUE)
WHERe LOCATE(t.c1,t1.c1)>0
and LOCATE(t.c2,t1.c2)>0
and t.c3 = t1.c3
名师互学网 版权所有 (c)2021-2022 ICP备案号：晋ICP备2021003244-6号
