HIve replace

replace

select replace(a.f_value, ‘%20’, ’ ') f_value, a.vid
from (select replace(lower(v.f_value), ‘%7c’, ‘|’) f_value, v.vid
from mds_log_weblog_pageview v
where v.dt >= ‘2020-06-09’
and v.dt < ‘2020-06-10’
and v.site in (‘www’, ‘wap’, ‘app’)) a