[jira] [Created] (SPARK-20964) Make some keywords reserved along with the ANSI/SQL standard

["Takeshi Yamamuro (JIRA)" <ji...@apache.org>]

Takeshi Yamamuro created SPARK-20964:
----------------------------------------

             Summary: Make some keywords reserved along with the ANSI/SQL standard
                 Key: SPARK-20964
                 URL: https://issues.apache.org/jira/browse/SPARK-20964
             Project: Spark
          Issue Type: Improvement
          Components: SQL
    Affects Versions: 2.1.1
            Reporter: Takeshi Yamamuro
            Priority: Minor


The current Spark has many non-reserved words that are essentially reserved in the ANSI/SQL standard (http://developer.mimer.se/validator/sql-reserved-words.tml). 
https://github.com/apache/spark/blob/master/sql/catalyst/src/main/antlr4/org/apache/spark/sql/catalyst/parser/SqlBase.g4#L709

This is because there are many datasources (for instance twitter4j) that unfortunately use reserved keywords for column names (See [~hvanhovell]'s comments: https://github.com/apache/spark/pull/18079#discussion_r118842186). We might fix this issue in future major releases.






--
This message was sent by Atlassian JIRA
(v6.3.15#6346)

---------------------------------------------------------------------
To unsubscribe, e-mail: issues-unsubscribe@spark.apache.org
For additional commands, e-mail: issues-help@spark.apache.org