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)