...
Keywords | ||
---|---|---|
Non-reserved Keywords | Reserved Keywords | |
Hive 1.2.0 | ADD,ADMIN,AFTER,ANALYZE,ARCHIVE,ASC,BEFORE,BUCKET,BUCKETS,CASCADE, CHANGE,CLUSTER,CLUSTERED, CLUSTERSTATUS,COLLECTION,COLUMNS,COMMENT, COMPACT,COMPACTIONS,COMPUTE,CONCATENATE,CONTINUE, DATA,DATABASES, DATETIME,DAY,DBPROPERTIES,DEFERRED,DEFINED,DELIMITED,DEPENDENCY,DESC, DIRECTORIES, DIRECTORY,DISABLE,DISTRIBUTE,ELEM_TYPE,ENABLE,ESCAPED, EXCLUSIVE,EXPLAIN,EXPORT,FIELDS,FILE,FILEFORMAT, FIRST,FORMAT,FORMATTED, FUNCTIONS,HOLD_DDLTIME,HOUR,IDXPROPERTIES,IGNORE,INDEX,INDEXES,INPATH, INPUTDRIVER,INPUTFORMAT,ITEMS,JAR,KEYS,KEY_TYPE,LIMIT,LINES,LOAD, LOCATION,LOCK,LOCKS,LOGICAL,LONG, MAPJOIN,MATERIALIZED,METADATA, MINUS,MINUTE,MONTH,MSCK,NOSCAN,NO_DROP,OFFLINE,OPTION,OUTPUTDRIVER, OUTPUTFORMAT,OVERWRITE,OWNER,PARTITIONED,PARTITIONS,PLUS,PRETTY,PRINCIPALS, PROTECTION,PURGE, READ,READONLY,REBUILD,RECORDREADER,RECORDWRITER,REGEXP, RELOAD,RENAME,REPAIR,REPLACE,REPLICATION, RESTRICT,REWRITE,RLIKE,ROLE,ROLES, SCHEMA,SCHEMAS,SECOND,SEMI,SERDE,SERDEPROPERTIES,SERVER,SETS, SHARED,SHOW, SHOW_DATABASE,SKEWED,SORT,SORTED,SSL,STATISTICS,STORED,STREAMTABLE, STRING, STRUCT,TABLES,TBLPROPERTIES,TEMPORARY,TERMINATED,TINYINT,TOUCH, TRANSACTIONS,UNARCHIVE,UNDO, UNIONTYPE,UNLOCK,UNSET,UNSIGNED,URI,USE,UTC, UTCTIMESTAMP,VALUE_TYPE,VIEW,WHILE,YEAR , | |
Hive 2.0.0 | ||
Hive 2.1.0 | ||
Hive 2.2.0 |
Keywords
...
ALL,ALTER, |
...
AND |
...
,ARRAY,AS |
...
,AUTHORIZATION, |
...
BETWEEN, |
...
BIGINT,BINARY,BOOLEAN,BOTH, |
...
BY,CASE,CAST, |
...
CHAR |
...
, |
...
COLUMN |
...
, |
...
CONF |
...
,CREATE,CROSS,CUBE,CURRENT,CURRENT_DATE, CURRENT_TIMESTAMP,CURSOR, |
...
DATABASE |
...
,DATE |
...
, |
...
DECIMAL, |
...
DELETE |
...
, |
...
DESCRIBE |
...
, |
...
DISTINCT, |
...
DOUBLE,DROP, |
...
ELSE |
...
,END, |
...
EXCHANGE, |
...
EXISTS |
...
, |
...
EXTENDED,EXTERNAL,FALSE,FETCH |
...
,FLOAT, FOLLOWING,FOR, |
...
FROM,FULL,FUNCTION |
...
,GRANT,GROUP,GROUPING,HAVING, |
...
IF, |
...
IMPORT, IN |
...
, |
...
INNER |
...
, |
...
INSERT,INT,INTERSECT,INTERVAL,INTO,IS, |
...
JOIN |
...
,LATERAL,LEFT,LESS, |
...
LIKE |
...
, |
...
LOCAL, |
...
MACRO,MAP |
...
,MORE |
...
,NONE, |
...
NOT |
...
,NULL,OF, |
...
ON, |
...
OR,ORDER,OUT,OUTER |
...
,OVER, |
...
PARTIALSCAN, |
...
PARTITION, |
...
PERCENT |
...
,PRECEDING, |
...
PRESERVE, |
...
PROCEDURE, |
...
RANGE, |
...
READS, |
...
REDUCE, |
...
REVOKE, |
...
RIGHT, |
...
ROLLUP, |
...
ROW, |
...
ROWS, |
...
SELECT,SET,SMALLINT,TABLE,TABLESAMPLE, THEN,TIMESTAMP, |
...
TO |
...
, |
...
TRANSFORM,TRIGGER,TRUE, |
...
TRUNCATE, |
...
UNBOUNDED, |
...
UNION, |
...
UNIQUEJOIN, |
...
UPDATE, |
...
USER,USING,UTC_TMESTAMP, |
...
VALUES |
...
,VARCHAR, |
...
WHEN,WHERE, |
...
WINDOW,WITH |
...
Hive 2.0.0 | remove REGEXP, RLIKE | add REGEXP, RLIKE |
Hive 2.1.0 | add CONSTRAINT, FOREIGN, PRIMARY, REFERENCES | |
Hive 2.2.0 | add PRECISION |
Info | ||
---|---|---|
| ||
REGEXP and RLIKE are non-reserved keywords prior to Hive 2.0.0 and reserved keywords starting in Hive 2.0.0 (HIVE-11703). |
Non-reserved Keywords
Code Block | ||
---|---|---|
| ||
ADD,ADMIN,AFTER,ANALYZE,ARCHIVE,ASC,BEFORE,BUCKET,BUCKETS,CASCADE,CHANGE,CLUSTER,
CLUSTERED,CLUSTERSTATUS,COLLECTION,COLUMNS,COMMENT,COMPACT,COMPACTIONS,COMPUTE,
CONCATENATE,CONTINUE,DATA,DATABASES,DATETIME,DAY,DBPROPERTIES,DEFERRED,DEFINED,
DELIMITED,DEPENDENCY,DESC,DIRECTORIES,DIRECTORY,DISABLE,DISTRIBUTE,ELEM_TYPE,ENABLE,
ESCAPED,EXCLUSIVE,EXPLAIN,EXPORT,FIELDS,FILE,FILEFORMAT,FIRST,FORMAT,FORMATTED,
FUNCTIONS,HOLD_DDLTIME,HOUR,IDXPROPERTIES,IGNORE,INDEX,INDEXES,INPATH,INPUTDRIVER,
INPUTFORMAT,ITEMS,JAR,KEYS,KEY_TYPE,LIMIT,LINES,LOAD,LOCATION,LOCK,LOCKS,LOGICAL,LONG,
MAPJOIN,MATERIALIZED,MINUS,MINUTE,MONTH,MSCK,NOSCAN,NO_DROP,OFFLINE,OPTION,OUTPUTDRIVER,
OUTPUTFORMAT,OVERWRITE,OWNER,PARTITIONED,PARTITIONS,PLUS,PRETTY,PRINCIPALS,PROTECTION,
PURGE,READ,READONLY,REBUILD,RECORDREADER,RECORDWRITER,REGEXP (Hive 0.x.x and 1.x.x),
RELOAD,RENAME,REPAIR,REPLACE,RESTRICT,REWRITE,RLIKE (Hive 0.x.x and 1.x.x),ROLE,ROLES,
SCHEMA,SCHEMAS,SECOND,SEMI,SERDE,SERDEPROPERTIES,SERVER,SETS,SHARED,SHOW,SHOW_DATABASE,
SKEWED,SORT,SORTED,SSL,STATISTICS,STORED,STREAMTABLE,STRING,STRUCT,TABLES,TBLPROPERTIES,
TEMPORARY,TERMINATED,TINYINT,TOUCH,TRANSACTIONS,UNARCHIVE,UNDO,UNIONTYPE,UNLOCK,UNSET,
UNSIGNED,URI,USE,UTC,UTCTIMESTAMP,VALUE_TYPE,VIEW,VIEWS,WHILE,YEAR |
Info | ||
---|---|---|
| ||
REGEXP and RLIKE are non-reserved keywords prior to Hive 2.0.0 and reserved keywords starting in Hive 2.0.0 (HIVE-11703). |
Reserved Keywords
Code Block | ||
---|---|---|
| ||
ALL,ALTER,ARRAY,AS,AUTHORIZATION,BETWEEN,BIGINT,BINARY,BOOLEAN,BOTH,BY, CONSTRAINT(Hive 2.1.0 onward),CREATE,CUBE,CURRENT_DATE,CURRENT_TIMESTAMP, CURSOR,DATE,DECIMAL,DELETE,DESCRIBE,DOUBLE,DROP,EXISTS,EXTERNAL,FALSE,FETCH, FLOAT,FOR,FOREIGN(Hive 2.1.0 onward),FULL,GRANT,GROUP,GROUPING,IMPORT,IN,INNER, INSERT,INT,INTERSECT,INTO,IS,LATERAL,LEFT,LIKE,LOCAL,NONE,NULL,OF,ORDER, OUT,OUTER,PARTITION,PERCENT,PRECISION(Hive 2.2.0 onward),PRIMARY(Hive 2.1.0 onward), PROCEDURE,RANGE,READS,REFERENCES(Hive 2.1.0 onward),REGEXP(Hive 2.0.0 onward), REVOKE,RIGHT,RLIKE(Hive 2.0.0 onward),ROLLUP,ROW,ROWS,SET,SMALLINT,TABLE,TIMESTAMP, TO,TRIGGER,TRUE,TRUNCATE,UNION,UPDATE,USER,USING,VALUES,WITH |
Reserved keywords are permitted as identifiers if you quote them as described in Supporting Quoted Identifiers in Column Names (version 0.13.0 and later, see HIVE-6013). Most of the keywords are reserved through HIVE-6617 in order to reduce the ambiguity in grammar (version 1.2.0 and later). There are two ways if the user still would like to use those reserved keywords as identifiers: (1) use quoted identifiers, (2) set hive.support.sql11.reserved.keywords=false. (version 2.1.0 and earlier)
...