Hi,
I have the following schema: raw3: {group: (field1: int,field2:
chararray,field3: chararray),raw2: {(field1: int,field2:
chararray,field4: chararray,field3: chararray,field5: boolean)}}
What I am trying to do is extract the most frequent value of field4 and
the most frequent of field field5 along with the group fields (field1,
field2, field3).
I know that GROUP BY is not allowed (yet) with FOREACH statements. How
can I accomplice the same functionality without writing a UDF?
Example:
input: ((1,2,3),
{(1,2,a,3,x),(1,2,b,3,x),(1,2,a,3,x),(1,2,v,3,x),(1,2,f,3,z),(1,2,a,3,z)})
output: (1,2,a,3,x)
Thank you,
Adam.
