[SPARK-32257] [SQL Parser] Report Error for invalid usage of SET command

• Type: Improvement
• Status: Resolved
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 3.0.0
• Fix Version/s: 3.1.0
• Component/s: SQL
• Assignee: Takeshi Yamamuro
• Reporter: Xiao Li
• Created: 09/Jul/20 17:06
• Updated: 03/Aug/20 13:00
• Resolved: 03/Aug/20 13:00

Description

SET spark.sql.ansi.enabled true

The above SQL command does not change the conf value and it just tries to display the value of conf "spark.sql.ansi.enabled true".

We can disallow using the space in the conf name and issue a user friendly error instead. In the error message, we should tell users a workaround to use the quote if they still needs to specify a conf with a space. 

 

Issue Links

• links to: [Github] Pull Request #29146 (maropu)