viirya commented on a change in pull request #30297:
URL: https://github.com/apache/spark/pull/30297#discussion_r521518487
##########
File path:
sql/catalyst/src/main/scala/org/apache/spark/sql/catalyst/expressions/collectionOperations.scala
##########
@@ -1906,8 +1906,10 @@ case class ArrayPosition(left: Expression, right:
Expression)
@ExpressionDescription(
usage = """
_FUNC_(array, index) - Returns element of array at given (1-based) index.
If index < 0,
- accesses elements from the last to the first. Returns NULL if the index
exceeds the length
- of the array.
+ accesses elements from the last to the first. The function returns NULL
+ if the index exceeds the length of the array and
`spark.sql.ansi.enabled` is set to false.
+ If `spark.sql.ansi.enabled` is set to true, it throws
ArrayIndexOutOfBoundsException
+ for invalid indices.
_FUNC_(map, key) - Returns value for given key, or NULL if the key is not
contained in the map
Review comment:
Do we want to make `ElementAt`behavior consistent on map type?
----------------------------------------------------------------
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.
For queries about this service, please contact Infrastructure at:
[email protected]
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
