How to add a column to an already existing table in apache pig

Question

I already have a table created using Pig. Now I want to add a random number with every row(record) to give me a new table with this added column.

Is this possible and how ?

Answer 1

You may use the RANDOM UDF for this purpose.
E.g:

A = ...
B = foreach A generate (int)(RANDOM()*100.0) as rnd, [other fields...]