I have a hive table with a column struct. I need to run a query to collect some rows of that column into array.
The end result should be array of struct<....>
I have tried "collect_set", but it is giving me an error that it cannot be used for complex types. I need some kind of "group_concat" as in mySSQL.
Do you have any idea, how i can achieve this (preferably without using any udf/udaf)??
Thanks.
UPDATE: I have a temporary solution by using UDAF. But I am wondering if it is possible with built-in functions.