CODEWITHSUNDEEP
hadoopapache-pig
sammyiitkgp
sammyiitkgp

Reputation: 259

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

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 ?

Upvotes: 5

Views: 3225

Answers (1)

Lorand Bendig
Lorand Bendig

Reputation: 10650

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

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

Upvotes: 2

Related Questions