How to get array/bag of elements from Hive group by operator?
The built in aggregate function collect_set (doumented here) gets you almost what you want. It would actually work on your example input:
SELECT F1, collect_set(F2)FROM sample_tableGROUP BY F1Unfortunately, it also removes duplicate elements and I imagine this isn't your desired behavior. I find it odd that collect_set exists, but no version to keep duplicates. Someone else apparently thought the same thing. It looks like the top and second answer there will give you the UDAF you need.
collect_set actually works as expected since a set as per definition is a collection of well defined and distinct objects i.e. objects occur exactly once or not at all within a set.