[
https://issues.apache.org/jira/browse/SPARK-37471?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
angerszhu updated SPARK-37471:
------------------------------
Description:
{code}
/*
select
select /* BROADCAST(b) */ 4\\;
*/
select 1
;
{code}
failed in spark-sql
{code}
[info] 2021-11-25 23:30:18.727 - stderr>
[info] 2021-11-25 23:30:18.757 - stderr> Setting default log level to "WARN".
[info] 2021-11-25 23:30:18.758 - stderr> To adjust logging level use
sc.setLogLevel(newLevel). For SparkR, use setLogLevel(newLevel).
[info] 2021-11-25 23:30:28.226 - stderr> Spark master: local, Application Id:
local-1637911820513
[info] 2021-11-25 23:30:29.506 - stdout> spark-sql>
[info] 2021-11-25 23:30:29.535 - stdout> > /*
[info] 2021-11-25 23:30:29.566 - stdout> > SELECT /* BROADCAST(b) */
4;
[info] 2021-11-25 23:30:29.592 - stdout> /*
[info] 2021-11-25 23:30:29.592 - stdout> SELECT /* BROADCAST(b) */ 4
[info] 2021-11-25 23:30:30.239 - stderr> Error in query:
[info] 2021-11-25 23:30:30.239 - stderr> Unclosed bracketed comment(line 1,
pos 0)
[info] 2021-11-25 23:30:30.239 - stderr>
[info] 2021-11-25 23:30:30.24 - stderr> == SQL ==
[info] 2021-11-25 23:30:30.24 - stderr> /*
[info] 2021-11-25 23:30:30.24 - stderr> ^^^
[info] 2021-11-25 23:30:30.24 - stderr> SELECT /* BROADCAST(b) */ 4
[info] 2021-11-25 23:30:30.24 - stderr>
[info] 2021-11-25 23:30:30.28 - stdout> spark-sql> */
[info] 2021-11-25 23:30:30.308 - stdout> > SELECT 1
[info] 2021-11-25 23:30:30.336 - stdout> > ;
[info] 2021-11-25 23:30:30.337 - stdout> */
[info] 2021-11-25 23:30:30.337 - stdout> SELECT 1
[info] 2021-11-25 23:30:30.337 - stdout>
[info] 2021-11-25 23:30:30.339 - stderr> Error in query:
[info] 2021-11-25 23:30:30.339 - stderr> extraneous input '*/' 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 0)
[info] 2021-11-25 23:30:30.339 - stderr>
[info] 2021-11-25 23:30:30.339 - stderr> == SQL ==
[info] 2021-11-25 23:30:30.339 - stderr> */
[info] 2021-11-25 23:30:30.339 - stderr> ^^^
[info] 2021-11-25 23:30:30.339 - stderr> SELECT 1
[info] 2021-11-25 23:30:30.339 - stderr>
[info] 2021-11-25 23:30:30.368 - stdout> spark-sql>
[info] 2021-11-25 23:30:30.605 - stdout>
{code}
was:
{code}
/*
select
select /* BROADCAST(b) */ 4\\;
*/
select 1
;
{code}
failed in spark-sql
> spark-sql support nested bracketed comment
> ------------------------------------------
>
> Key: SPARK-37471
> URL: https://issues.apache.org/jira/browse/SPARK-37471
> Project: Spark
> Issue Type: Task
> Components: SQL
> Affects Versions: 3.2.0
> Reporter: angerszhu
> Priority: Major
>
> {code}
> /*
> select
> select /* BROADCAST(b) */ 4\\;
> */
> select 1
> ;
> {code}
> failed in spark-sql
> {code}
> [info] 2021-11-25 23:30:18.727 - stderr>
> [info] 2021-11-25 23:30:18.757 - stderr> Setting default log level to
> "WARN".
> [info] 2021-11-25 23:30:18.758 - stderr> To adjust logging level use
> sc.setLogLevel(newLevel). For SparkR, use setLogLevel(newLevel).
> [info] 2021-11-25 23:30:28.226 - stderr> Spark master: local, Application
> Id: local-1637911820513
> [info] 2021-11-25 23:30:29.506 - stdout> spark-sql>
> [info] 2021-11-25 23:30:29.535 - stdout> > /*
> [info] 2021-11-25 23:30:29.566 - stdout> > SELECT /* BROADCAST(b)
> */ 4;
> [info] 2021-11-25 23:30:29.592 - stdout> /*
> [info] 2021-11-25 23:30:29.592 - stdout> SELECT /* BROADCAST(b) */ 4
> [info] 2021-11-25 23:30:30.239 - stderr> Error in query:
> [info] 2021-11-25 23:30:30.239 - stderr> Unclosed bracketed comment(line 1,
> pos 0)
> [info] 2021-11-25 23:30:30.239 - stderr>
> [info] 2021-11-25 23:30:30.24 - stderr> == SQL ==
> [info] 2021-11-25 23:30:30.24 - stderr> /*
> [info] 2021-11-25 23:30:30.24 - stderr> ^^^
> [info] 2021-11-25 23:30:30.24 - stderr> SELECT /* BROADCAST(b) */ 4
> [info] 2021-11-25 23:30:30.24 - stderr>
> [info] 2021-11-25 23:30:30.28 - stdout> spark-sql> */
> [info] 2021-11-25 23:30:30.308 - stdout> > SELECT 1
> [info] 2021-11-25 23:30:30.336 - stdout> > ;
> [info] 2021-11-25 23:30:30.337 - stdout> */
> [info] 2021-11-25 23:30:30.337 - stdout> SELECT 1
> [info] 2021-11-25 23:30:30.337 - stdout>
> [info] 2021-11-25 23:30:30.339 - stderr> Error in query:
> [info] 2021-11-25 23:30:30.339 - stderr> extraneous input '*/' 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 0)
> [info] 2021-11-25 23:30:30.339 - stderr>
> [info] 2021-11-25 23:30:30.339 - stderr> == SQL ==
> [info] 2021-11-25 23:30:30.339 - stderr> */
> [info] 2021-11-25 23:30:30.339 - stderr> ^^^
> [info] 2021-11-25 23:30:30.339 - stderr> SELECT 1
> [info] 2021-11-25 23:30:30.339 - stderr>
> [info] 2021-11-25 23:30:30.368 - stdout> spark-sql>
> [info] 2021-11-25 23:30:30.605 - stdout>
> {code}
--
This message was sent by Atlassian Jira
(v8.20.1#820001)
---------------------------------------------------------------------
To unsubscribe, e-mail: issues-unsubscr...@spark.apache.org
For additional commands, e-mail: issues-h...@spark.apache.org
