I want to update/delete some records in pig, I want to know how to achieve that in pig.
ID Name
1 A
2 B
3 C
4 D
5 E
I want to update value of ID = 3 and delete record with ID =5 so that my expected table will have records like :
ID NAME
1 A
2 B
3 Z
4 D
How to achieve the above result?