hive：几种实现like的方式

LOCATE：

SELECT s.title,t.name
FROM (select * from bo.t_positions limit 1000) s
RIGHT JOIN resume.pf_basic_dic t
ON(TRUE)
WHERE LOCATE(s.title,t.name)>0

like：

SELECT s.position_name,t.senior_name FROM (select * from tmp.t_position_name_data_times_less300) s ,tmp.t_senior_function_data t 
WHERE t.senior_name LIKE CONCAT('%' ,s.position_name , '%') group by t.senior_name,s.position_name

rlike：

SELECT s.position_name,t.senior_name FROM (select * from tmp.t_position_name_data_times_less300 limit 100) s ,tmp.t_senior_function_data t 
WHERE t.senior_name rlike s.position_name group by t.senior_name,s.position_name

报错：

join：

select * from  (select * from bo.t_positions limit 200) s left j