hive combing array<string> to one string

Question

I have a HIVE table as following:

id string

first_name array < string >

last_name array < string >

e.g.

id, first_name, last_name


1,   [A,B],     [C,D,E]

2,   [A],       [C,D]

How can I write a query to convert both first_name and last_name to string, as follows?

id, first_name, last_name

1,   A_B,       C_D_E

2,   A,         C_D

Thanks,

Vamsi Prabhala · Accepted Answer · 2019-07-09 18:12:29Z

1

Use concat_ws which takes accepts an array as input.

select id,concat_ws('_',first_name),concat_ws('_',last_name)
from tbl

answered Jul 9, 2019 at 18:12

Vamsi Prabhala

49.4k4 gold badges41 silver badges64 bronze badges

Sign up to request clarification or add additional context in comments.

1 Answer 1