Correction - it looks like the query uses \u002 to separate array elements
and \u001 to separate the other fields. The question is still similar
though in wondering how I can load that array into pig.
Note - If my data is formatted as a tsv with parentheses surrounding the
array:
(element1,element2,element3) anotherfield
This loads properly when I use LOAD '/my/tsvfile' USING PigStorage('\t') AS
(elements:tuple(),afield:chararray);
On Fri, Mar 21, 2014 at 8:38 AM, Jeff Storey <[email protected]> wrote:
> 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.
>