[ 
https://issues.apache.org/jira/browse/HIVE-19741?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17874832#comment-17874832
 ] 

Shohei Okumiya commented on HIVE-19741:
---------------------------------------

(WIP) Checking changes.
h2. Hive 2.2.0
h3. Non-reserved

added: {-}{color:#FF0000}DETAIL{color}{-}, {color:#FF0000}-DOW-{color}, 
{color:#FF0000}DUMP{color}, {-}{color:#FF0000}EXPRESSION{color}{-}, 
{color:#FF0000}MATCHED{color}, {color:#FF0000}MERGE{color}, 
{-}{color:#FF0000}OPERATOR{color}{-}, QUARTER, {color:#FF0000}REPL{color}, 
{color:#FF0000}STATUS{color}, {color:#FF0000}-SUMMARY-{color}, 
{color:#FF0000}-VECTORIZATION-{color}, WEEK, YEARS, MONTHS, WEEKS, DAYS, HOURS, 
MINUTES, SECONDS
 * DETAIL, EXPRESSION, OPERATOR, SUMMARY, VECTORIZATION were added by 2.3.0
 * DOW didn't exist

h3. Reserved

added: DAYOFWEEK, {color:#FF0000}EXCEPT{color}, EXTRACT, FLOOR, INTEGER, 
PRECISION, VIEWS
h2. Hive 2.3.0
h3. Non-reserved

added: {color:#FF0000}DETAIL, EXPRESSION, OPERATOR, SUMMARY, VECTORIZATION, 
WAIT{color}
h2. Hive 3.0.0
h3. Non-reserved

removed: {color:#FF0000}PRETTY{color}

added: {color:#FF0000}ACTIVATE{color}, {color:#FF0000}ACTIVE{color}, 
{color:#FF0000}ALLOC_FRACTION{color}, {color:#FF0000}CHECK{color}, 
{color:#FF0000}DEFAULT{color}, {color:#FF0000}DO, ENFORCED, KILL, MANAGEMENT, 
MAPPING, MOVE, PATH, PLAN, PLANS, POOL, QUERY, QUERY_PARALLELISM, 
REOPTIMIZATION, RESOURCE, SCHEDULING_POLICY{color}, 
{-}{color:#FF0000}TIMESTAMPTZ{color}{-}, ZONE
 * TIMESTAMPTZ was replaced by TIMESTAMPLOCALTZ before the release

h3. Reserved

removed: {color:#FF0000}PARTIALSCAN{color}

added: {color:#FF0000}ANY{color}, {color:#FF0000}APPLICATION{color}, TIME, 
{color:#FF0000}TIMESTAMPLOCALTZ{color}, NUMERIC, SYNC
h2. Hive 4.0.0
h3. Non-reserved

added: {color:#FF0000}AST, AT, BRANCH, CBO, COST, CRON, DCPROPERTIES, DEBUG, 
DISABLED, DISTRIBUTED, ENABLED, EVERY, EXECUTE, EXECUTED, EXPIRE_SNAPSHOTS, 
IGNORE, JOINCOST, MANAGED, MANAGEDLOCATION, OPTIMIZE, REMOTE, RESPECT, RETAIN, 
RETENTION, SCHEDULED, SET_CURRENT_SNAPSHOT, SNAPSHOTS, SPEC, SYSTEM_TIME, 
SYSTEM_VERSION, TAG, TRANSACTIONAL, TRIM, TYPE, UNKNOWN, URL, WITHIN{color}
h3. Reserved

added: {color:#FF0000}COMPACTIONID, CONNECTOR, CONNECTORS, CONVERT, DDL, FORCE, 
LEADING, OLDER, PKFK_JOIN, PREPARE, QUALIFY, REAL, SOME, THAN, TRAILING{color}

> Update documentation to reflect list of reserved words
> ------------------------------------------------------
>
>                 Key: HIVE-19741
>                 URL: https://issues.apache.org/jira/browse/HIVE-19741
>             Project: Hive
>          Issue Type: Improvement
>          Components: Documentation
>            Reporter: Matt Burgess
>            Assignee: Shohei Okumiya
>            Priority: Minor
>
> The current list of non-reserved and reserved keywords is on the Hive wiki:
> https://cwiki.apache.org/confluence/display/Hive/LanguageManual+DDL#LanguageManualDDL-Keywords,Non-reservedKeywordsandReservedKeywords
> However it does not match the list in code (see the lexer rules here):
> https://github.com/apache/hive/blob/master/ql/src/java/org/apache/hadoop/hive/ql/parse/HiveLexer.g
> On particular example is the "application" keyword, which was discovered 
> while trying to create a table with a column named "application".
> This Jira proposes to align the documentation with the current set of 
> non-reserved and reserved keywords.



--
This message was sent by Atlassian Jira
(v8.20.10#820010)

Reply via email to