Gengliang Wang created SPARK-35161:
--------------------------------------
Summary: Safe version SQL functions
Key: SPARK-35161
URL: https://issues.apache.org/jira/browse/SPARK-35161
Project: Spark
Issue Type: New Feature
Components: SQL
Affects Versions: 3.2.0
Reporter: Gengliang Wang
Create new safe version SQL functions for existing SQL functions/operators,
which returns NULL if overflow/error occurs. So that:
1. Users can manage to finish queries without interruptions
2. The result can be more reasonable. For example, the result of the following
operation is terrible
{code:java}
2147483647 + 2 => -2147483647
CAST(2147483648L AS INT) => -2147483648
{code}
Having the safe version SQL functions provides an alternative solution for
handling such cases
{code:java}
TRY_ADD(2147483647, 2) => null
TRY_CAST(2147483648L AS INT) => null
{code}
--
This message was sent by Atlassian Jira
(v8.3.4#803005)
---------------------------------------------------------------------
To unsubscribe, e-mail: issues-unsubscr...@spark.apache.org
For additional commands, e-mail: issues-h...@spark.apache.org
