[SPARK-37692] sql-migration-guide wrong description

• Type: Documentation
• Status: Resolved
• Priority: Trivial
• Resolution: Fixed
• Affects Version/s: 3.2.0
• Fix Version/s: 3.2.1, 3.3.0
• Component/s: Documentation
• Assignee: Max Gekk
• Reporter: JacobZheng
• Created: 20/Dec/21 08:47
• Updated: 12/Dec/22 18:11
• Resolved: 21/Dec/21 10:10

Description

Description in the documentation:

In Spark 3.2, the unit list interval literals can not mix year-month fields (YEAR and MONTH) and day-time fields (WEEK, DAY, …, MICROSECOND). For example, INTERVAL 1 day 1 hour is invalid in Spark 3.2. In Spark 3.1 and earlier, there is no such limitation and the literal returns value of CalendarIntervalType. To restore the behavior before Spark 3.2, you can set spark.sql.legacy.interval.enabled to true. 

”INTERVAL 1 day 1 hour is invalid in Spark 3.2.“ 

Is this example correct? According to the description of DayTimeIntervalType, INTERVAL 1 day 1 hour is valid in Spark 3.2

Issue Links

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