[
https://issues.apache.org/jira/browse/HIVE-12707?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15066178#comment-15066178
]
Cazen Lee commented on HIVE-12707:
----------------------------------
Reserved keywords by hive.support.sql11.reserved.keywords are as below i think
ALL, ALTER, ARRAY, AS, AUTHORIZATION, BETWEEN, BIGINT, BINARY, BOOLEAN
, BOTH, BY, CREATE, CUBE, CURRENT_DATE, CURRENT_TIMESTAMP, CURSOR, DATE,
DECIMAL, DELETE, DESCRIBE
, DOUBLE, DROP, EXISTS, EXTERNAL, FALSE, FETCH, FLOAT, FOR, FULL, GRANT
, GROUP, GROUPING, IMPORT, IN, INNER, INSERT, INT, INTERSECT, INTO, IS, LATERAL
, LEFT, LIKE, LOCAL, NONE, NULL, OF, ORDER, OUT, OUTER, PARTITION
, PERCENT, PROCEDURE, RANGE, READS, REVOKE, RIGHT
, ROLLUP, ROW, ROWS, SET, SMALLINT, TABLE, TIMESTAMP, TO, TRIGGER, TRUE
, TRUNCATE, UNION, UPDATE, USER, USING, VALUES, WITH
, REGEXP, RLIKE
Quoted Identifiers can be an alternative
{code}
CREATE TABLE cazenTest(`INTERVAL` STRING);
{code}
> ParseException for column name 'INTERVAL', even set
> hive.support.sql11.reserved.keywords = false
> -------------------------------------------------------------------------------------------------
>
> Key: HIVE-12707
> URL: https://issues.apache.org/jira/browse/HIVE-12707
> Project: Hive
> Issue Type: Bug
> Affects Versions: 1.2.1
> Reporter: Rajit Saha
>
> Any column name INTERVAL is causing ParseException , even we set
> hive.support.sql11.reserved.keywords = false
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
