[SPARK-49757] SET CATALOG syntax doesn't support IDENTIFIER

• Type: Improvement
• Status: Resolved
• Priority: Minor
• Resolution: Fixed
• Affects Version/s: 4.0.0
• Fix Version/s: 4.0.0
• Component/s: SQL
• Labels: pull-request-available
• Assignee: Mikhail Nikoliukin
• Reporter: Mikhail Nikoliukin
• Created: 23/Sep/24 15:31
• Updated: 27/Sep/24 13:49
• Resolved: 27/Sep/24 13:49

Description

Since IDENTIFIER clause was added a lot of gaps remain. One of them is SET CATALOG syntax added in https://issues.apache.org/jira/browse/SPARK-36841

Now SET CATALOG IDENTIFIER('test') will fall with

[INVALID_SET_SYNTAX] Expected format is 'SET', 'SET key', or 'SET key=value'...

Parser can't match SET CATALOG with an identifier but can match next "setConfiguration" grammar, what makes the error even more confusing.

It would be nice to support identifier in this context as well.

 

Issue Links

• links to: GitHub Pull Request #48228