hive经典案例额---行转列汇总计数

案例 3 
数据如下：
uid,event
u01,ad_click 
u01,ad_show  
u01,favor_sku
u01,ad_click 
u01,pageview
u01,search
u02,ad_click
u02,ad_show
u02,favor_sku
u02,addcart
u02,pageview
u02,pageview
要求：
需求1：假如数据中的事件类型是已知且固定的，求如下报表：

+------+-----------+----------+------------+-----------+----------+----------+
| uid  | ad_click  | ad_show  | favor_sku  | pageview  | searchs  | addcart  |
+------+-----------+----------+------------+-----------+----------+----------+
| u01  | 2         | 1        | 1          | 1         | 1        | 0        |
| u02  | 1         | 1        | 1          | 2         | 0        | 1        |
+------+-----------+----------+------------+-----------+----------+----------+

-------------------------------------------------------------------

select uid,
       sum(case when event = 'ad_click' then 1 else 0 end),
       sum(case when event = 'ad_show' then 1 else 0 end),
       sum(case when event = 'favor_sku' then 1 else 0 end),
       sum(case when event = 'pageview' then 1 else 0 end),
       sum(case when event = 'searchs' then 1 else 0 end),
       sum(case when event = 'addcart' then 1 else 0 end)
from test03
group by uid;