hive行转列，列转行实践

最新推荐文章于 2024-06-21 16:47:31 发布

民谣书生

最新推荐文章于 2024-06-21 16:47:31 发布

阅读量772

点赞数

分类专栏： hive

本文链接：https://blog.csdn.net/OYY_90/article/details/89534838

版权

hive 专栏收录该内容

9 篇文章 0 订阅

订阅专栏

drop table demo;
create table demo
(
test1 string,
test2 string,
id string
)
row format delimited fields terminated by '\t'
stored as textfile;


或者


1.建表

drop table demo;
create table demo
(
test1 string,
test2 string,
id string
)
row format delimited fields terminated by '\t'
stored as textfile;


load data local inpath '/home/carson/test.txt' into table demo;

https://blog.csdn.net/jiantianming2/article/details/79189672

select test1,test2,concat_ws(',',collect_set(cast(id as string))) as set 
from demo group by test1,test2

with temp as(select test1,test2,concat_ws(',',collect_set(cast(id as string))) as set 
from demo group by test1,test2)


select test1, test2, id from temp a 
lateral view explode(split(set,','))  b AS id