[SPARK-37471] spark-sql support nested bracketed comment

• Type: Task
• Status: Resolved
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 3.2.0
• Fix Version/s: 3.2.1, 3.3.0
• Component/s: SQL
• Assignee: angerszhu
• Reporter: angerszhu
• Created: 26/Nov/21 07:26
• Updated: 03/Dec/21 16:21
• Resolved: 03/Dec/21 16:21

Description

/*
select  
select /* BROADCAST(b) */ 4\\;
*/
select  1
;

failed in spark-sql -f

/usr/share/spark-3.2/bin/spark-sql --verbose  -f test.sql

Spark master: yarn, Application Id: application_1632999510150_6968442
/* sielect /* BROADCAST(b) */ 4
Error in query:
mismatched input '4' expecting {'(', 'ADD', 'ALTER', 'ANALYZE', 'CACHE', 'CLEAR', 'COMMENT', 'COMMIT', 'CREATE', 'DELETE', 'DESC', 'DESCRIBE', 'DFS', 'DROP', 'EXPLAIN', 'EXPORT', 'FROM', 'GRANT', 'IMPORT', 'INSERT', 'LIST', 'LOAD', 'LOCK', 'MAP', 'MERGE', 'MSCK', 'REDUCE', 'REFRESH', 'REPLACE', 'RESET', 'REVOKE', 'ROLLBACK', 'SELECT', 'SET', 'SHOW', 'START', 'TABLE', 'TRUNCATE', 'UNCACHE', 'UNLOCK', 'UPDATE', 'USE', 'VALUES', 'WITH'}(line 1, pos 30)

== SQL ==
/* sielect /* BROADCAST(b) */ 4
------------------------------^^^

Issue Links

• links to: [Github] Pull Request #34721 (AngersZhuuuu)
• links to: [Github] Pull Request #34721 (AngersZhuuuu)