建表语句
create table user_tag_merge ( uid int, gender String, agegroup String, favor String ) row format delimited fields terminated by '\t'
导入数据
insert into user_tag_merge values(1,'M','90后','sm'); insert into user_tag_merge values(2,'M','70后','sj'); insert into user_tag_merge values(3,'M','90后','ms'); insert into user_tag_merge values(4,'F','80后','sj'); insert into user_tag_merge values(5,'F','90后','ms');
先看需求:
原表数据格式为
需要将其转化格式为
直接上Hql
Original: https://www.cnblogs.com/CYan521/p/16798370.html
Author: 再美不及姑娘你
Title: Hive中Hql关于行转列及列转行的综合应用
原创文章受到原创版权保护。转载请注明出处:https://www.johngo689.com/713631/
转载文章受原作者版权保护。转载请注明原作者出处!