Marios Trivyzas created FLINK-24385:
---------------------------------------
Summary: Add TRY_CAST function to be able to handle errors
Key: FLINK-24385
URL: https://issues.apache.org/jira/browse/FLINK-24385
Project: Flink
Issue Type: Improvement
Components: Table SQL / API
Reporter: Marios Trivyzas
Currently, *CAST* is returning null when the conversion requested fails,
whereas normally in SQL it would just throw an error. Maybe it would be better
to change the implementation of *CAST* to throw errors on failed conversions,
and introduce *TRY_CAST* which would return null in such cases. Then with a
simple wrapping of a *TRY_CAST* expression with *COALESCE* the user can also
use an alternative default value to be returned instead of null. e..g:
{{}}{{SELECT COALESCE(TRY_CAST(col1 AS INT), -1) FROM test}}
--
This message was sent by Atlassian Jira
(v8.3.4#803005)
