统计用户各年龄段销量
(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; |