Use REPLACE in multicondition RegExp in Pig Latin

Question

I have this set of data: dump data; This is a sample output: (this dataset is almost a million rows long). ("0",60,0,1,"Fri") ("1",47,0,1,"Mon") ("1",23,1,0,"Tue") ("1",60,0,0,"Sat") ("1",50,1,1,"Fri") I want to replace the values: Sat, Fri, Mon to numbers of week, I know how to use REPLACE for change just 1 value at a time, but I have to repeat it multiple times in order to change all days of the week: data_day_of_week = FOREACH data GENERATE $0,$1,$2,$3,REPLACE($4, 'Mon', '1'); Is there any way to do this in only one statement? JavaScript questions and answers, JavaScript questions pdf, JavaScript question bank, JavaScript questions and answers pdf, mcq on JavaScript pdf, JavaScript questions and solutions, JavaScript mcq Test , Interview JavaScript questions, JavaScript Questions for Interview, JavaScript MCQ (Multiple Choice Questions)

Answer 1

You should use a CASE WHEN THEN statement data_day_of_week = FOREACH data GENERATE CASE WHEN $4 == 'Mon' THEN '1' WHEN $4 == 'Tue' THEN '2' ... WHEN $4 == 'Sun' THEN '7' END AS day_number; You should also name your relations so not to use $1, $2 etc. If you name $4 as day_number then when you declare the variable as day_number from the CASE statement it'll "overwrite" your prior data.