Support Questions
Find answers, ask questions, and share your expertise
Announcements
Alert: Welcome to the Unified Cloudera Community. Former HCC members be sure to read and learn how to activate your account here.

array?

Solved Go to solution

array?

New Contributor

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

1 ACCEPTED SOLUTION

Accepted Solutions

Re: array?

New Contributor

I was able to resolve using array_contains.

 

Thanks for your reply.

2 REPLIES 2

Re: array?

Contributor

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

 

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

 

https://cwiki.apache.org/confluence/display/Hive/LanguageManual+UDF#LanguageManualUDF-explode(array)

Re: array?

New Contributor

I was able to resolve using array_contains.

 

Thanks for your reply.