Hello, I am trying to create a full address and full location field in Pig by combining multiple fields.
file = LOAD 'file.txt' USING PigStorage() AS (house:chararray, predir:chararray, street:chararray, streettype:chararray, postdir:chararray city:chararray, state:chararray, zip:chararray) I need an output that is full address and full location: full_address == house + ' ' + predir + ' ' + street + ' ' + streettype + ' ' + postdir full_location == city + ' ' + state + ' ' + zip I can get two to merge with CONCAT using but am not able to add more or the spaces in between. Temp1 = FOREACH file GENERATE CONCAT (house,street) Any ideas? Thanks Scott
