mihailom-db commented on code in PR #49213: URL: https://github.com/apache/spark/pull/49213#discussion_r1889742665
########## docs/sql-ref-ansi-compliance.md: ########## @@ -384,6 +384,8 @@ When ANSI mode is on, it throws exceptions for invalid operations. You can use t - `try_make_timestamp_ltz`: identical to the function `make_timestamp_ltz`, except that it returns `NULL` result instead of throwing an exception on error. - `try_make_timestamp_ntz`: identical to the function `make_timestamp_ntz`, except that it returns `NULL` result instead of throwing an exception on error. - `try_make_interval`: identical to the function `make_interval`, except that it returns `NULL` result instead of throwing an exception on invalid interval. + - `try_elt`: identical to the function `elt`, except that it returns `NULL` result instead of throwing an exception on index out of bounds. Review Comment: You are right, I was thinking about whether we need this one, but it turns out we can use `get` + `explode` as a workaround. ########## docs/sql-ref-ansi-compliance.md: ########## @@ -384,6 +384,8 @@ When ANSI mode is on, it throws exceptions for invalid operations. You can use t - `try_make_timestamp_ltz`: identical to the function `make_timestamp_ltz`, except that it returns `NULL` result instead of throwing an exception on error. - `try_make_timestamp_ntz`: identical to the function `make_timestamp_ntz`, except that it returns `NULL` result instead of throwing an exception on error. - `try_make_interval`: identical to the function `make_interval`, except that it returns `NULL` result instead of throwing an exception on invalid interval. + - `try_elt`: identical to the function `elt`, except that it returns `NULL` result instead of throwing an exception on index out of bounds. + - `try_get_array_item` Review Comment: Ditto. -- This is an automated message from the Apache Git Service. To respond to the message, please log on to GitHub and use the URL above to go to the specific comment. To unsubscribe, e-mail: [email protected] For queries about this service, please contact Infrastructure at: [email protected] --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
