[SPARK-37724] ANSI mode: disable ANSI reserved keywords by default

• Type: Task
• Status: Resolved
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 3.3.0
• Fix Version/s: 3.3.0
• Component/s: SQL
• Epic Link: ANSI enhancements in Spark 3.3
• Assignee: Gengliang Wang
• Reporter: Gengliang Wang
• Created: 23/Dec/21 08:03
• Updated: 11/Apr/22 12:50
• Resolved: 24/Dec/21 17:10

Description

The reserved keywords thing is a big stopper for many users that want to try ANSI mode. They have to update the SQL queries to pass the parser, which is nothing about data quality but just trouble.

By disabling the feature as default, I think we can get better adoption of the ANSI mode.

Issue Links

• links to: [Github] Pull Request #34996 (gengliangwang)
• links to: [Github] Pull Request #34996 (gengliangwang)