[jira] [Created] (DRILL-5611) Handling source data with null dates and times

["Joe Auty (JIRA)" <ji...@apache.org>]

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)