[
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)
