[Hive_add_3] Hive 进行简单数据处理

---

 0. 说明

　　通过 Hive 对 duowan 数据进行简单处理

 

 

---

1. 操作流程

　　1.1 建表

create table duowan(id int, name string, pass string, mail string, nickname string)
row format delimited
fields terminated by '\t' 
lines terminated by '\n' 
stored as textfile;

 

　　1.2 加载数据

load data inpath '/duowan_user.txt' into table duowan;

 

　　1.3 开始执行

select pass , count(*) as count from duowan group by pass order by count desc limit 10; 

 

　　1.4 设置 reduce 个数

set mapreduce.job.reduces=2;

 

 

 

---