You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@spark.apache.org by "angerszhu (Jira)" <ji...@apache.org> on 2021/11/26 07:34:00 UTC
[jira] [Updated] (SPARK-37471) spark-sql support nested bracketed comment
[ 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-unsubscribe@spark.apache.org
For additional commands, e-mail: issues-help@spark.apache.org