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