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 ... View more

Hello:   I came across table where i have to write HIVE query and table data is in a wierd way.   I have one table with 10 columns in HIVE where data is not on the same row. first 5 columns have data and second five columns are empty(blank).   Now to complete my result sets, i have to join in a such a way that i can get complete row of data with "no empty".   Want to know if any one had encounter this issue or how ican do that.   Thank you in advance. Thanks ... View more