[DATAFU-69] Create SelectFieldByName UDF - which, given a field who's value contains a field name, and *, returns the value of the field referenced by the field name

• Type: Bug
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 1.3.0
• Fix Version/s: 1.3.0
• Labels: features
• Assignee: Russell Jurney
• Reporter: Russell Jurney
• Created: 11/Sep/14 20:20
• Updated: 03/Nov/14 22:37
• Resolved: 03/Nov/14 22:16

Description

define SelectFieldByName datafu.pig.util.SelectFieldByName();

data = LOAD 'input' using PigStorage(',') AS (fieldName:chararray, text1:chararray, text2:chararray, text3:chararray);
data2 = FOREACH data GENERATE fieldName, SelectFieldByName(fieldName,*) as result;
data3 = FOREACH data2 GENERATE fieldName, result;
STORE data3 INTO 'output';