统计用户各年龄段销量

（1）关联查询新用户信息表、用户评论表、手机销量表生成新 hive 表统计各年龄段的手机销量。生成的新表包含的字段：

用户年龄段、单品手机类型、销量数量

操作指令：

#新建中间表

（1）create table age_region_sail_info_middle row format delimited fields terminated by ',' as select u.age_region,u.age_region_alias,g.model,g.sail_count from (select user_id,age_region,age_region_alias from user_info_new_tb) u join (select goods_id,user_id from user_comment_info) c on u.user_id = c.user_id join  (select goods_id,model,sail_count from goods_sail_info) g on c.goods_id = g.goods_id;

#查询中间表，计算销量和存入结果表

 

（2）create table age_region_sail_info row format delimited fields terminated by ',' as select age_region_alias,model,sum(sail_count) from age_region_sail_info_middle group by age_region_alias,model;

（3）desc age_region_sail_info;

（4）select * from age_region_sail_info;