Convert array<string> to string [duplicate]

Question

I have a hive array of string and I want to convert it to string. Hive version is 1.2.1000.2.6.1.0-129.

create table a (arr array<string>);

create table b (str array<string>);

insert into table b
select * from a;

I tried:

concat_ws(',',collect_set(cast(arr as string))

collect_set(cast(arr as string))

cast(arr as string)

Thanks but not working for me

Vadim
– Vadim

2020-10-01 14:05:15 +00:00
Commented Oct 1, 2020 at 14:05 — Vadim
– Vadim, Commented Oct 1, 2020 at 14:05
What specifically goes wrong?

showdev
– showdev

2020-10-02 06:35:28 +00:00
Commented Oct 2, 2020 at 6:35 — showdev
– showdev, Commented Oct 2, 2020 at 6:35

leftjoin · Accepted Answer · 2020-10-01 11:08:30Z

0

concat_ws() function (concatenate with separator) concatenates array elements into string separated with specified separator (comma in this example):

concat_ws(',',arr) as result

answered Oct 1, 2020 at 11:08

leftjoin

38.5k8 gold badges64 silver badges126 bronze badges

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

Collectives™ on Stack Overflow

Convert array<string> to string [duplicate]

1 Answer 1

Comments

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Linked

Related