hive-模糊匹配like的用法

查询带有某个字词字段的全部信息

select * from bishow.MKT_DTL_Q_PROCESS_INFO_SUB_DAY where title like concat('%','密码','%')

select count(*) from bishow.MKT_DTL_Q_PROCESS_INFO_SUB_DAY