[jira] [Updated] (DRILL-3513) Convert and cast are too sensitive/strict when dealing with empty string values

["Stefán Baxter (JIRA)" <ji...@apache.org>]

     [ https://issues.apache.org/jira/browse/DRILL-3513?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Stefán Baxter updated DRILL-3513:
---------------------------------
    Summary: Convert and cast are too sensitive/strict when dealing with empty string values  (was: Convert and cast are too sensitive/strict when dealing with empty values)

> Convert and cast are too sensitive/strict when dealing with empty string values
> -------------------------------------------------------------------------------
>
>                 Key: DRILL-3513
>                 URL: https://issues.apache.org/jira/browse/DRILL-3513
>             Project: Apache Drill
>          Issue Type: Bug
>          Components: Functions - Drill
>    Affects Versions: 1.1.0
>            Reporter: Stefán Baxter
>            Assignee: Daniel Barclay (Drill)
>
> Working with slightly imperfect data is a hassle in drill unless one gives up and stores all data as strings.
> CONVERT_TO and CAST both throw exception if one is trying to convert empty string into numbers. These functions should return null value if the input is essentially a null value (or a pure string representation there off).
>  



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)