[jira] [Commented] (ARROW-10115) [C++] CSV empty quoted string is treated as NULL

["Maciej (Jira)" <ji...@apache.org>]

    [ https://issues.apache.org/jira/browse/ARROW-10115?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17249031#comment-17249031 ] 

Maciej commented on ARROW-10115:
--------------------------------

What is the current state of this issue, do you think it will be fixed?

> [C++] CSV empty quoted string is treated as NULL
> ------------------------------------------------
>
>                 Key: ARROW-10115
>                 URL: https://issues.apache.org/jira/browse/ARROW-10115
>             Project: Apache Arrow
>          Issue Type: Improvement
>          Components: C++
>    Affects Versions: 1.0.1
>            Reporter: Maciej
>            Priority: Major
>
> When parsing my CSV I have set
> {color:#267f99}ConvertOptions{color}::s{color:#001080}trings_can_be_null{color} to true.
> Now as I have values:
> {code:java}
> 1234,"",345
> {code}
> the string value which is an empty string is treated as NULL.
> I've checked default valeus of {color:#267f99}ConvertOptions{color}::{color:#001080}null_values{color} and there is empty string considered null, but here we have empty quoted string which shouldn't be treated as NULL in my opinion. Similar behavior we have in Postgresql, empty quoted string is not treated as a NULL: https://www.postgresql.org/docs/12/sql-copy.html



--
This message was sent by Atlassian Jira
(v8.3.4#803005)