[SPARK-40044] Incorrect target interval type in cast overflow errors

• Type: Sub-task
• Status: Resolved
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 3.4.0
• Fix Version/s: 3.4.0
• Component/s: SQL
• Assignee: Max Gekk
• Reporter: Max Gekk
• Created: 11/Aug/22 05:32
• Updated: 11/Aug/22 05:51
• Resolved: 11/Aug/22 05:51

Description

The example below shows the issue:

spark-sql> select CAST(9223372036854775807L AS INTERVAL YEAR TO MONTH);
org.apache.spark.SparkArithmeticException: [CAST_OVERFLOW] The value 9223372036854775807L of the type "BIGINT" cannot be cast to "INTERVAL MONTH" due to an overflow.

The target type "INTERVAL MONTH" is incorrect.

Issue Links

• links to: [Github] Pull Request #37470 (MaxGekk)