[jira] Commented: (PIG-529) Want support for loading CSV files

[Tom White (JIRA)]

[ 
https://issues.apache.org/jira/browse/PIG-529?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12647772#action_12647772
 ] 

Tom White commented on PIG-529:
---

Lots of existing data is in CSV format, and it uses double quotes to escape 
fields with commas:

{noformat}
a,"b,c",d
{noformat}

There are some other rules too; see 
http://en.wikipedia.org/wiki/Comma-separated_values. Pig should have a load 
function that understands this format.

> Want support for loading CSV files
> --
>
> Key: PIG-529
> URL: https://issues.apache.org/jira/browse/PIG-529
> Project: Pig
>  Issue Type: New Feature
>  Components: data
>Reporter: Tom White
>
> Want to be able to load CSV data into Pig. This needs to handle quoting 
> correctly.

-- 
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.

[jira] Commented: (PIG-529) Want support for loading CSV files

[Alan Gates (JIRA)]

[ 
https://issues.apache.org/jira/browse/PIG-529?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12647769#action_12647769
 ] 

Alan Gates commented on PIG-529:


You're saying you want a load function that parsers:

a,'b,c',d 

as a / b,c / d

and not as 

a / b / c / d

is that correct?  Does it have to be done with quotes.  Could it be done with 
an escape character instead, such as:

a,b\,c,d

?

> Want support for loading CSV files
> --
>
> Key: PIG-529
> URL: https://issues.apache.org/jira/browse/PIG-529
> Project: Pig
>  Issue Type: New Feature
>  Components: data
>Reporter: Tom White
>
> Want to be able to load CSV data into Pig. This needs to handle quoting 
> correctly.

-- 
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.