Hive实验--将 查询结果保存到另一个表中

查询employee表，按部门分组，女性个数降序排序，将结果employee_res表中（字段为 部门id，女性个数）。

建表：

//创建表 employee
hive > create external table employee
	>(sid STRING, jdata STRING, name STRING, city STRING, m STRING, 
		cdata STRING, dep STRING)
	>ROW FORMAT DELIMTTED
	>FIELDS TERMINATED BY ',' ;
	
//载入数据：路径中需要有目标文件，路径在hdfs中，若在posix文件系统权限会有问题
hive > load data inpath '/user/xxxx/xxx.csv' overwrite into table employee;
 
hive > select * from employee limit 5;

//创建自己的表 employee_res
hive > create external table employee_res
	>(dep STRING, num BIGINT)
	>ROW FORMAT DELIMTTED
	>FIELDS TERMINATED BY ',' ;
hive > select * from employee;

cp:
hdfs dfs -cp /hadoop/examples/……… /user/you_login_id

//查询：
hive > select dep,count(*) num from employee where m='F' group by dep order by num desc;

//查询结果载入表employee_res中：
hive > insert into table employ_res select dep,count(*) num from employee where m='F' group by dep order by num desc;

hive > select * from employee_res;