[
https://issues.apache.org/jira/browse/DRILL-975?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Jacques Nadeau updated DRILL-975:
---------------------------------
Assignee: (was: Jacques Nadeau)
> Null-on-exception option for cast functions
> -------------------------------------------
>
> Key: DRILL-975
> URL: https://issues.apache.org/jira/browse/DRILL-975
> Project: Apache Drill
> Issue Type: Improvement
> Components: Functions - Drill
> Reporter: Steven Phillips
> Fix For: Future
>
> Attachments: DRILL-975.patch
>
>
> 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.3.4#6332)
