Joe Auty created DRILL-5611:
-------------------------------
Summary: Handling source data with null dates and times
Key: DRILL-5611
URL: https://issues.apache.org/jira/browse/DRILL-5611
Project: Apache Drill
Issue Type: Bug
Reporter: Joe Auty
Priority: Minor
A query like the following is failing for me when there are null values in the
input:
SELECT CAST(columns[5] AS TIME) as `monday_open` FROM dfs.tmp.`sampledata.csv`
It appears that the to_time() and to_date() functions fail too. My use case is
trying to create parquet files from CSV input.
I have set:
ALTER SYSTEM SET `drill.exec.functions.cast_empty_string_to_null` = true
Is this a bug/hole, or is there some other way I can negotiate these null
values?
My apologies if there are any problems with how this report is filed.
--
This message was sent by Atlassian JIRA
(v6.4.14#64029)
