Shulou(Shulou.com)05/31 Report--

This article mainly shows you "hive how to achieve column change", the content is easy to understand, clear, hope to help you solve your doubts, the following let the editor lead you to study and learn "hive how to achieve column change" this article.

First, problems

How does hive put

A b 1

A b 2

A b 3

C d 4

C d 5

C d 6

Change to:

A b 1,2,3

C d 4,5,6

2. Data

Test.txt

A b 1

A b 2

A b 3

C d 4

C d 5

C d 6

3. Answer

1. Build 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

two。 Deal with

Select col1,col2,concat_ws (',', collect_set (col3))

From tmp_jiangzl_test

Group by col1,col2

The above is all the content of the article "how to convert columns to rows in hive". Thank you for reading! I believe we all have a certain understanding, hope to share the content to help you, if you want to learn more knowledge, welcome to follow the industry information channel!

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.