hive sql引入全局自定义变量
set poi =
-- 输入id清单
123,321,11
-- 结束
;
set city =
'北京','上海','a城'
;
select
kp.dt
,kp.city_id
,kp.city_name
,count(distinct kp.poi_name) poi_cnt
from table_test kp
where kp.dt between $$begindatekey and $$enddatekey
-- and kp.poi_id in (${hiveconf:poi})
and kp.city_name in (${hiveconf:city})
group by 1,2,3