[SPARK-34905] Enable ANSI intervals in SQLQueryTestSuite

• Type: Sub-task
• Status: Resolved
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 3.2.0
• Fix Version/s: 3.2.0
• Component/s: Tests
• Assignee: Max Gekk
• Reporter: Max Gekk
• Created: 30/Mar/21 11:17
• Updated: 12/Apr/21 09:26
• Resolved: 12/Apr/21 09:26

Description

Remove the following code from SQLQueryTestSuite:

    localSparkSession.conf.set(SQLConf.LEGACY_INTERVAL_ENABLED.key, true)

and use the ANSI interval where it is possible.

Probably, this depends on casting intervals to strings.

Issue Links

• is blocked by: SPARK-34667 Support casting of year-month intervals to strings
• is blocked by: SPARK-34668 Support casting of day-time intervals to strings
• is blocked by: SPARK-34984 ANSI intervals formatting in hive results
• links to: [Github] Pull Request #32099 (MaxGekk)
• links to: [Github] Pull Request #32099 (MaxGekk)