Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

 

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
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, RLIKERLIKEadd AUTOCOMMIT, ISOLATION, LEVEL, OFFSET, SNAPSHOT, TRANSACTION, WORK, WRITE
add COMMIT, ONLY, REGEXP, RLIKE, ROLLBACK, START

Hive 2.1.0

 

add
ABORT, KEY, LAST, NORELY, NOVALIDATE, NULLS, RELY, VALIDATE
add
CACHE,
add
 CONSTRAINT, FOREIGN, PRIMARY, 
REFERENCES

Hive

2.2.0

 
add PRECISION

...

add
DETAIL, DOW, EXPRESSION, OPERATOR, QUARTER, SUMMARY, VECTORIZATION, WEEK
add
DAYOFWEEK, EXTRACT, FLOOR, PRECISION, VIEWS
Info
titleVersion information

REGEXP and RLIKE are non-reserved keywords prior to Hive 2.0.0 and reserved keywords starting in Hive 2.0.0 (HIVE-11703).

...