I'm executing a hive query in which one of the fields an array and writing it to a file using:
INSERT OVERWRITE '/path/to/output' SELECT ... This query works well. I would like to load this data into pig, but I'm quite sure how to get the array properly into pig. My output file from the query doesn't look like it has any array notation when using the default ^A separator. Is there a way I can execute a query with an array field output that can then be directly loaded into pig as a tuple? Thank you.