Trying to convert the string to array type in hive using collect_set

Asked Mar 21 '20 at 06:03

Active Mar 22 '20 at 14:50

Viewed 274 times

I have two columns in my table (date,users) which are strings.

date               users
2019-01-01        '"U10000","U20000"'

I am trying to convert the users column to array<string>, and getting \ in values. I didn't find any spaces in string values, so why am I getting '\' in new array column?

this is my query and the result it produces:

Select date,collect_set(users)  as user_arr from mytable group by date

date                user_arr
2019-01-01      ["\"U10000\",\"U20000\""]

edited Mar 22 '20 at 14:50

mazaneicha

8,794
4
33
52

asked Mar 21 '20 at 06:03

Rahul

Checkout here : https://stackoverflow.com/a/3844602/4959282 – Kishan Mar 21 '20 at 06:17
Thanks @Kishan,I tried this, still not getting expected output – Rahul Mar 21 '20 at 06:34
i tried this ....... Select to_date(current_date()),collect_set("\"Hello\"") group by to_date(current_date()) – Rahul Mar 21 '20 at 06:35
Hope this can help Check this : https://stackoverflow.com/a/38618050/4959282 – Kishan Mar 21 '20 at 07:23

Trying to convert the string to array type in hive using collect_set

0 Answers0