[Solved-1 Solution] How to refer to a field after a join and a group by in Pig ?
What is join ?
A Join simply brings together two data sets. These joins can happen in different ways in Pig - inner, outer, right, left, and outer joins. These however are simple joins and there are specialized joins supported by Pig
If you have this code in Pig (win, request and response are just tables loaded directly from filesystem):
Basically if you want to sum the bid_price after joining and grouping, but an error come:
When performing multiple joins we recommend using unique identifiers for above fields (e.g. for bid_id). Alternatively, we can also use the disambiguation operator '::', but that can get pretty hard.