drill-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Joe Auty (JIRA)" <j...@apache.org>
Subject [jira] [Created] (DRILL-5611) Handling source data with null dates and times
Date Tue, 27 Jun 2017 21:06:00 GMT
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)

Mime
View raw message