一、HQL写法 uv:  count(distinct)太影响性能，以下为改进： select tmp.shop,count(1) as uv from (select user_id,shop from second_visit group by user_id,shop)tmp group by shop; pv select shop,count(uid) from second_visit group by shop; 二、MR写法 待填坑 三、spark写法 val co