Appendix C - Impala Reserved Words
The following are the reserved words for Cloudera Impala 1.4.0. A reserved word is one that cannot be used directly as an identifier; you must quote it with backticks. For example, a statement CREATE TABLE select (x INT) fails, while CREATE TABLE `select` (x INT) succeeds. Impala does not reserve the names of aggregate or scalar built-in functions. (Formerly, Impala did reserve the names of some aggregate functions.)
Because different database systems have different sets of reserved words, and the reserved words change from release to release, carefully consider database, table, and column names to ensure maximum compatibility between products and versions.
add aggregate all alter and api_version as asc avro between bigint binary boolean by cached case cast change char class close_fn column columns comment compute create cross data database databases date datetime decimal delimited desc describe distinct div double drop else end escaped exists explain external false fields fileformat finalize_fn first float format formatted from full function functions group having if in init_fn inner inpath insert int integer intermediate interval into invalidate is join last left like limit lines load location merge_fn metadata not null nulls offset on or order outer overwrite parquet parquetfile partition partitioned partitions prepare_fn produced rcfile real refresh regexp rename replace returns right rlike row schema schemas select semi sequencefile serdeproperties serialize_fn set show smallint stats stored straight_join string symbol table tables tblproperties terminated textfile then timestamp tinyint to true uncached union update_fn use using values view when where with