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)