You are viewing a plain text version of this content. The canonical link for it is here.

Posted to dev@drill.apache.org by "Stefán Baxter (JIRA)" <ji...@apache.org> on 2015/07/18 16:36:04 UTC

[jira] [Created] (DRILL-3513) Convert and cast are too sensitive for empty values

Stefán Baxter created DRILL-3513:
------------------------------------

             Summary: Convert and cast are too sensitive for empty 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)