jayzhan211 opened a new issue, #12904:
URL: https://github.com/apache/datafusion/issues/12904
### Describe the bug
As title, I would like to store null value in the csv table but couldn't.
### To Reproduce
Write a csv file to `datafusion/core/tests/data/data.csv` with
```csv
c1,c2
NULL,'a'
```
```
statement ok
CREATE EXTERNAL TABLE t (
c1 INT,
c2 VARCHAR,
)
STORED AS CSV
LOCATION '../core/tests/data/data.csv'
OPTIONS ('format.has_header' 'true');
query error DataFusion error: Arrow error: Parser error: Error while parsing
value NULL for column 0 at line 1
select * from t;
```
### Expected behavior
Successfully store nulls for non-string type
### Additional context
String is fine
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: [email protected]
For queries about this service, please contact Infrastructure at:
[email protected]
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]