Steven Phillips created DRILL-975:
-------------------------------------
Summary: Null-on-exception option for cast functions
Key: DRILL-975
URL: https://issues.apache.org/jira/browse/DRILL-975
Project: Apache Drill
Issue Type: Bug
Reporter: Steven Phillips
Currently, if a particular value cannot be cast to the target type, an
exception is thrown and the query fails. We should have a mode that will treat
the output of all cast functions as nullable, and return a null value if the
cast fails, rather than throwing an exception.
An important example where this is important is when using the Text reader. The
text reader always produces a single, RepeatedVarChar column. The columns are
then cast to the appropriate type. For the columns that are cast to numeric
types, if there is no value (i.e. it's an empty string), currently this will
throw NumberFormatException. What we really want is for it to produce a Null
value.
--
This message was sent by Atlassian JIRA
(v6.2#6252)
