hive报错信息不明确的情况汇总

hive报错信息不明确的情况汇总

code 1

Error: Error while processing statement: FAILED: Execution Error, return code 1 from org.apache.hadoop.hive.ql.exec.MoveTask. Exception when loading 1 in table uniaction1 with loadPath=*********************************

这种报错可能出现在insert select中，也可能直接load中报错出现，对于tez引擎和mr引擎，这个报错可能会有不同的原因 需要读者自行分辨

• 文件格式与要插入的数据格式不同 ，csv与text
• 表有其他的进程在占用，会导致select出结果但最终结果load步骤报错
• 分区字段为空或中文字段，总之分区字段报错导致落地的hdfs分区目录会有问题

code [2] exit(2)

org.apache.tez.dag.api.SessionNotRunning: TezSession has already shutdown. No cluster diagnostics found.

ERROR : FAILED: Execution Error, return code 1 from org.apache.hadoop.hive.ql.exec.tez.TezTask
INFO : Completed executing command(queryId=hive_20221018074224_172b6c79-9a2b-4af0-a992-b6db1380daf2); Time taken: 5.112 seconds
Error: Error while processing statement: FAILED: Execution Error, return code 1 from org.apache.hadoop.hive.ql.exec.tez.TezTask (state=08S01,code=1)
Intercepting System.exit(2)
Failing Oozie Launcher, Main class [org.apache.oozie.action.hadoop.Hive2Main], exit code [2]

这种报错有可能是锁表，例如hive3中有事务，一读一写就会有这种问题

code1 MoveTask

Error while processing statement: FAILED: Execution Error, return code 1 from org.apache.hadoop.hive.ql.exec.MoveTask. Exception updating metastore for acid table database.table1 with partitions
这个一般是动态分区时报的错，或者传参过多导致的

解决方案：
hive.direct.sql.max.elements.values.clause=200
hive.direct.sql.max.elements.in.clause=200

Ensure called on an unitialized

Error while processing statement: FAILED: Execution Error, return code -101 from org.apache.hadoop.hive.ql.exec.tez.TezTask. Ensure called on an unitialized (or closed) session 352a2d91-16c8-44bd-a296-8a8eab91a2d0

解决办法：频繁登录导致的session错乱，注销hue 等待一段时间 重新登录。