question Re: array? in Archives of Support Questions (Read Only)

array?

HiveQ — Fri, 16 Sep 2022 12:47:45 GMT

Hello:

I have table where one column is type (array<string>)

elements of array varies in that column from 1 to 5 and more.

I want to explode all elements of array dynamically so that i can get one row.

I need help to see how i can achieve.

Any help is greatly appreciated.

Thank you in advance.

Thanks

David M. — Mon, 12 Feb 2018 02:38:14 GMT

I am sorry, but I do not understand the requirement.

However, perhaps you are looking for the 'explode' UDF:

HiveQ — Mon, 12 Feb 2018 02:48:57 GMT

I was able to resolve using array_contains.

Thanks for your reply.