You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@spark.apache.org by "Maxim Gekk (Jira)" <ji...@apache.org> on 2020/06/09 19:21:00 UTC
[jira] [Commented] (SPARK-26905) Revisit reserved/non-reserved
keywords based on the ANSI SQL standard
[ https://issues.apache.org/jira/browse/SPARK-26905?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17129730#comment-17129730 ]
Maxim Gekk commented on SPARK-26905:
------------------------------------
Spark's ANSI Non-Reserved keywords are actually reserved keywords in SQL2016:
{code:scala}
+-----------+
|value |
+-----------+
|ALTER |
|GLOBAL |
|INTERVAL |
|ROLLBACK |
|WINDOW |
|INSERT |
|TRIM |
|SHOW |
|DESCRIBE |
|AT |
|LIKE |
|OF |
|IMPORT |
|RANGE |
|ROWS |
|DELETE |
|TRUE |
|MERGE |
|DROP |
|START |
|BY |
|OVERLAY |
|SUBSTRING |
|COMMIT |
|EXTERNAL |
|OUT |
|SET |
|TRUNCATE |
|LOCAL |
|PARTITION |
|EXISTS |
|VALUES |
|ARRAY |
|TABLESAMPLE|
|UPDATE |
|POSITION |
|REVOKE |
|ROLLUP |
|LATERAL |
|FUNCTION |
|ROW |
|NO |
|CUBE |
|EXTRACT |
|CURRENT |
|BETWEEN |
|GROUPING |
|OVER |
+-----------+
{code}
> Revisit reserved/non-reserved keywords based on the ANSI SQL standard
> ---------------------------------------------------------------------
>
> Key: SPARK-26905
> URL: https://issues.apache.org/jira/browse/SPARK-26905
> Project: Spark
> Issue Type: Sub-task
> Components: SQL
> Affects Versions: 3.0.0
> Reporter: Xiao Li
> Priority: Major
> Attachments: spark-ansiNonReserved.txt, spark-keywords-list.txt, spark-nonReserved.txt, spark-strictNonReserved.txt, sql2016-02-nonreserved.txt, sql2016-02-reserved.txt, sql2016-09-nonreserved.txt, sql2016-09-reserved.txt, sql2016-14-nonreserved.txt, sql2016-14-reserved.txt
>
>
--
This message was sent by Atlassian Jira
(v8.3.4#803005)
---------------------------------------------------------------------
To unsubscribe, e-mail: issues-unsubscribe@spark.apache.org
For additional commands, e-mail: issues-help@spark.apache.org