I'm using PigLatin to filter some records.
User1 8 NYC
User1 9 NYC
User1 7 LA
User2 4 NYC
User2 3 DC
The script should remove the duplicate for users, and keep one of these records. Something like the unique command in linux.
The output should be:
User1 8 NYC
User2 4 NYC
Any suggestions?