数据处理

数据处理：

·统计最受欢迎的视频/文章的Top10访问次数 （video/article）

 

create table id_count as
select word,count(*) as cnt from
(select explode(split(mid,' ')) as word from data) w
group by word
order by cnt desc;

 

 

 

·按照地市统计最受欢迎的Top10课程 （ip）

 

create table count_ip as
select word,count(*) as cnt from
(select explode(split(mip,' ')) as word from data) w
group by word
order by cnt desc;

 

 

 

·按照流量统计最受欢迎的Top10课程 （traffic）

 

create table traffic_count as
select mid,sum(mt) as cnt from data group by mid order by cnt desc;