[
https://issues.apache.org/jira/browse/HIVE-19741?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17874832#comment-17874832
]
Shohei Okumiya edited comment on HIVE-19741 at 8/20/24 3:38 AM:
----------------------------------------------------------------
(WIP) Still checking changes.
h2. Hive 1.2.0
h3. Non-reserved
added: ..., {-}{color:#ff0000}ELEM_TYPE{color}{-}, ...,
{-}{color:#ff0000}KEY_TYPE{color}{-}, ..., ...,
{-}{color:#FF0000}UTCTIMESTAMP{color}{-}, {color:#FF0000}UTC_TMESTAMP{color},
..., -{color:#FF0000}VALUE_TYPE{color}-
* ELEM_TYPE is not a keyword. KW_ELEM_TYPE = $ELEM$
* before the release
* KEY_TYPE is not a keyword. KW_KEY_TYPE = $KEY$
* UTCTIMESTAMP
* VALUE_TYPE is not a keyword. KW_VALUE_TYPE = $VALUE$
* KW_UTCTIMESTAMP = UTC_TMESTAMP
h2. Hive 2.2.0
h3. Non-reserved
removed: {color:#FF0000}HOLD_DDLTIME, NO_DROP, OFFLINE, PROTECTION,
READONLY{color}
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
* HOLD_DDLTIME was removed by HIVE-12224
* NO_DROP, OFFLINE, PROTECTION, OFFLINE, READONLY were removed by HIVE-11145
* 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}{-}, {color:#ff0000}WORKLOAD{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}
was (Author: okumin):
(WIP) Still checking changes.
h2. Hive 1.2.0
h3. Non-reserved
added: ..., {-}{color:#ff0000}ELEM_TYPE{color}{-}, ...,
{-}{color:#ff0000}HOLD_DDLTIME{color}{-}, ...,
{-}{color:#ff0000}KEY_TYPE{color}{-}, ..., {-}{color:#ff0000}NO_DROP{color}{-},
..., {-}{color:#ff0000}OFFLINE{color}{-}, ...,
{-}{color:#ff0000}PROTECTION{color}{-}, ..., PROTECTION, READONLY,
UTCTIMESTAMP, ..., VALUE_TYPE
* ELEM_TYPE is not a keyword. KW_ELEM_TYPE = $ELEM$
* HOLD_DDLTIME was removed by HIVE-12224 before the release
* KEY_TYPE is not a keyword. KW_KEY_TYPE = $KEY$
* NO_DROP and OFFLINE were removed by HIVE-11145 before the release
* PROTECTION: ???
* READONLY
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}{-}, {color:#ff0000}WORKLOAD{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)
