Convert hive columns to rows (collect_set ())

I. Problems

How does hive

A B 1
A B 2
A B 3
C d 4
C d 5
C d 6

Changed:

A B 1, 2, 3
C d 4, 5, 6

Ii. Data

Test.txt

A B 1
A B 2
A B 3
C d 4
C d 5
C d 6

Iii. Answer

1. Create a table

Drop table tmp_jiangzl_test;
Create Table tmp_jiangzl_test
(
Col1 string,
Col2 string,
Col3 string
)
Row format delimited fields terminated by '\ t'
Stored as textfile;


Load data local inpath '/home/jiangzl/Shell/test.txt' into Table tmp_jiangzl_test;

2. Processing

Select col1, col2, concat_ws (',', collect_set (col3 ))
From tmp_jiangzl_test
Group by col1, col2;

4. About us

Author: Jiang Zhonglian, one of the pioneers of data

QQ: 248087140

Motto:

You are awesome in your field,

And with a group of white ones,

Others will respect you from the heart.

-- Click to join us.

Group blog address: http://my.oschina.net/dataRunner/blog/295960