[jira] [Resolved] (IMPALA-3916) Reserve SQL:2016 keywords

["Tianyi Wang (JIRA)" <ji...@apache.org>]

     [ https://issues.apache.org/jira/browse/IMPALA-3916?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Tianyi Wang resolved IMPALA-3916.
---------------------------------
       Resolution: Fixed
    Fix Version/s: Impala 3.0

IMPALA-3916: Reserve SQL:2016 reserved words

This patch reserves SQL:2016 reserved words, excluding:
1. Impala builtin function names.
2. Time unit words(year, month, etc.).
3. An exception list based on a discussion.

Some test cases are modified to avoid these words. A impalad and
catalogd startup option reserved_words_version is added. The words are
reserved if the option is set to "3.0.0".

Change-Id: If1b295e6a77e840cf1b794c2eb73e1b9d2b8ddd6
Reviewed-on: http://gerrit.cloudera.org:8080/9096
Reviewed-by: Alex Behm <al...@cloudera.com>
Reviewed-by: Philip Zeyliger <ph...@cloudera.com>
Tested-by: Impala Public Jenkins

> Reserve SQL:2016 keywords
> -------------------------
>
>                 Key: IMPALA-3916
>                 URL: https://issues.apache.org/jira/browse/IMPALA-3916
>             Project: IMPALA
>          Issue Type: Task
>          Components: Frontend
>    Affects Versions: Impala 3.0
>            Reporter: Justin Erickson
>            Assignee: Tianyi Wang
>            Priority: Minor
>              Labels: include-in-v3, incompatibility
>             Fix For: Impala 3.0
>
>         Attachments: non-reserved-word.txt, reserved-word.txt
>
>
> Reserve common SQL keywords to match:
> * HIVE-6617
> * docs: http://www.cloudera.com/documentation/enterprise/latest/topics/impala_reserved_words.html
> Should be a configuration option that is on by default in the next compatibility breaking release



--
This message was sent by Atlassian JIRA
(v7.6.3#76005)