hive 如何将数组转成字符串,如何在Hive中将int数组的元素连接为字符串

I'm trying to concatenate the element of int array to one string in hive.

The function concat_ws works only for string arrays, so I tried cast(my_int_array as string) but it's not working.

Any suggestion?

解决方案

Try to transform using /bin/cat:

from mytable select transform(my_int_array) using '/bin/cat' as (my_int_array);

Second option is to alter table and replace delimiters:

1) ALTER TABLE mytable CHANGE COLUMN my_int_array = my_int_array_string string;

2) SELECT REPLACE(my_int_array_string, '\002', ', ') FROM mytable;