create table tq_sport_search_jie_yao as select * from xxx；
use auto_hadoop_jobs;
insert overwrite local directory '/home/jie.yao/data/tools'
row format delimited
fields terminated by '\t'
select
mchnt_mcc,mchnt_tp,mchnt_cd,mchnt_name,mchnt_location,amt,cnt
from tq_sport_search_jie_yao
where
mchnt_name regexp '器材|器械|工具|用品|远山|蓝堡'
and
mchnt_name not regexp '健身'
order by amt desc;