locate(string substr, string str[, int pos])
返回substr在str中的位置,0为不包含。类似instr。
可用于模糊join
hive> select locate('uzi','Rnguzi');
OK
4
hive> select locate('uzi','RngUzi');
OK
0
select a.*,b.*
from
(select * from tb1 ) as a
join
(select * from tb2 ) as b on 1= 1
where locate(a.city_name,b.adress)>0