hive中如何替换反斜杠:
select title from bo.t_positions where title rlike '\\\\' limit 10
替换后:
select regexp_replace(title,'\\\\','/') title from bo.t_positions where title rlike '\\\\' limit 10
sparksql中如何替换反斜杠:
select position_name,code,senior_name,parent_code,level from position_name_data pnd right join senior_function_data sfd on regexp_replace(sfd.senior_name,'\\\\','/') like concat('%',regexp_replace(pnd.position_name,'\\\\','/'),'%') where senior_name is not null group by position_name,code,senior_name,parent_code,level
参考: