[
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-unsubscr...@spark.apache.org
For additional commands, e-mail: issues-h...@spark.apache.org
