业务背景
用户轨迹工程脚本最近经常报错,报错如下:
SLF4J: Actual binding is of type [org.slf4j.impl.Log4jLoggerFactory]
FAILED: Error in metadata: MetaException(message:java.lang.RuntimeException: commitTransaction was called but openTransactionCalls = 0. This probably indicates that there are unbalanced calls to openTransaction/commitTransaction)
FAILED: Execution Error, return code 1 from org.apache.hadoop.hive.ql.exec.DDLTask
搜了下发现,这是hive 0.10.0, 0.11.0, 0.12.0版本的bug,描述如下:
https://issues.apache.org/jira/browse/HIVE-4996
分析
查看了下集群上hive的配置文件,发现有这些:
$locate hive-site.xml
/etc/hive/conf.cloudera.hive/hive-site.xml
/etc/hive/conf.dist/hive-site.xml
/etc/hive/conf.dist/hive-site.xml_back
/etc/hive-hcatalog/conf.dist/proto-hive-site.xml
/home/pms/db_engine/apache-hive-0.13.1-bin/conf/hive-site.xml
/home/pms/db_engine/apache-hive-0.13.1-bin/hcatalog/etc/hcatalog/proto-hive-site