使用您的数据测试了此脚本：

-- load as four fields
a = LOAD 'data.txt' using PigStorage(',');

-- removes single quotes from second and third fields
b = foreach a generate $0 as id, REPLACE($1, '"', '') as firstname, REPLACE($2, '"', '') as lastname, $0 as address;

-- combines second and third field with a ',' in between
c = foreach b generate id,  CONCAT(firstname, ',', lastname) as name, address;

现在，测试结果：

test = foreach c generate name;
dump test;
(Amrit,kumar)
(Vaibhav,arora)
(Deepika,kumar)

将其加载到4个字段中，替换引号，在第2个字段后添加空格，最后在第2个和第3个字段处连接以在一个字段/列中获得全名。不需要外部jar。

A = LOAD 'File.csv.gz' USING PigStorage(',') AS (f1:int,f2:chararray,f3:chararray,f4:chararray);
B = FOREACH A GENERATE 
            f1,
            CONCAT(REPLACE(f2,'\\"',''),' ') as f2, -- replace beginning quote and add space at end
            REPLACE(f3,'\\"','') as f3,             -- replace ending quote
            f4;
C = FOREACH B GENERATE 
            f1 as id,
            CONCAT(f2,f3) as name,
            f4 as country;
DUMP C;