Home / Hive

Apache Hive errors and exceptions

Common Apache Hive errors and exceptions with their exact messages, causes, ways to confirm them and fixes.

Resources and memory

• Hive: FAILED: Execution Error, return code 2 from TezTask or MapRedTaskThe query compiled but the job it launched failed. Return code 2 means the Tez DAG or MapReduce job failed at run time. The message itself carries no cause:…

Query compilation

• Hive: ParseException: cannot recognize input nearThe parser hit tokens it did not expect. The three tokens quoted after "near" show where parsing stopped; the mistake is at or just before them. Reserved…
• Hive: SemanticException [Error 10004]: Invalid table alias or column referenceHive could not resolve a column or alias in the query. The message names the reference and lists the columns that were available, which is usually enough to…

Metastore

• Hive: Unable to instantiate org.apache.hadoop.hive.ql.metadata.SessionHiveMetaStoreClientHive (or Spark with Hive support) could not create a metastore client. The class name is only the wrapper: the "Caused by" lines underneath say whether the…

Partitions

• Hive: Number of dynamic partitions created is N, which is more than 1000A dynamic-partition INSERT would create more partitions than hive.exec.max.dynamic.partitions (1000 by default). Before raising the limit, check whether the…