New to Pig UDF so requesting help to resolve the issue Created a Pig UDF to transform an input tuple and generate an transformed tuple. Executed a Store to save the transformed tuple into a file
B = FOREACH A GENERATE PackageName.MyMethod(); STORE B into 'output' USING PigStorage(); My question is that when sqoop export reads this data from output HDFS file and inserts into MYSQL table, the curly braces "(" and ")" are also saved into the first and the last column of mysql table. Is there a way to avoid curly braces for getting into MySQL column as part of first and last column? I tried to delimit to tabs explicitly in PigStorage() but that did not resolve the issue. Any help is appreciated. Thanks -Akash