[SPARK-39432] element_at(*, 0) does not return INVALID_ARRAY_INDEX_IN_ELEMENT_AT

• Type: Sub-task
• Status: Resolved
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 3.3.0
• Fix Version/s: 3.4.0
• Component/s: Spark Core
• Assignee: Pan Bingkun
• Reporter: Serge Rielau
• Created: 09/Jun/22 23:30
• Updated: 27/Jun/22 06:36
• Resolved: 27/Jun/22 06:36

Description

spark-sql> SELECT element_at(array('a', 'b', 'c'), index) FROM VALUES(0), (2) AS T(index);

22/06/09 16:23:07 ERROR SparkSQLDriver: Failed in [SELECT element_at(array('a', 'b', 'c'), index) FROM VALUES(0), (2) AS T(index)]

java.lang.ArrayIndexOutOfBoundsException: SQL array indices start at 1

at org.apache.spark.sql.errors.QueryExecutionErrors$.sqlArrayIndexNotStartAtOneError(QueryExecutionErrors.scala:1206)

 

This should roll into INVALID_ARRAY_IN_ELEMENT_AT. Makes no sense to make a new error class 

Issue Links

• links to: [Github] Pull Request #36855 (panbingkun)
• links to: [Github] Pull Request #36855 (panbingkun)