hive 技巧

EXPLAIN  select user_id,count(1) as  cc from XXX  group by user_id;

检查语法是否有问题：用EXPLAIN。

select avg(cc)
from
(
   select user_id,count(1) as  cc
   from XXX
   group by user_id
)t;