[
https://issues.apache.org/jira/browse/DRILL-5611?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Joe Auty updated DRILL-5611:
----------------------------
Description:
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. The error message I'm getting:
SYSTEM ERROR: IllegalArgumentException: Invalid format: ""
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 was filed.
was:
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 was filed.
> 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. The error message I'm
> getting:
> SYSTEM ERROR: IllegalArgumentException: Invalid format: ""
> 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 was filed.
--
This message was sent by Atlassian JIRA
(v6.4.14#64029)
