Details
-
Bug
-
Status: Open
-
Major
-
Resolution: Unresolved
-
1.1.0
-
None
Description
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).