[
https://issues.apache.org/jira/browse/PIG-2470?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13267963#comment-13267963
]
Thejas M Nair commented on PIG-2470:
------------------------------------
CSVExcelStorage is supposed to follow the Excel conventions. I can't find any
official documentation on the convention, but it looks like excel CSV format
does not support null. I think empty fields is what most people would expect
for nulls. Having null string has its own issues, specially if the string null
is a legitimate column value. This change is less likely to break existing
scripts.
Changing the behavior of CSVLoader to return null for empty fields will be non
backward compatible change, that can break people's existing code.
> Issue with CSVEXcelStorage piggy bank function
> ----------------------------------------------
>
> Key: PIG-2470
> URL: https://issues.apache.org/jira/browse/PIG-2470
> Project: Pig
> Issue Type: Bug
> Components: piggybank
> Affects Versions: 0.9.0
> Reporter: Priya Karkele
> Assignee: Prashant Kommireddi
> Attachments: PIG-2470.patch
>
>
> CSVExcelStorage piggy bank function skips the record, which has 1 or more
> null column(s) in it. The record is not written to the file
--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators:
https://issues.apache.org/jira/secure/ContactAdministrators!default.jspa
For more information on JIRA, see: http://www.atlassian.com/software/jira
