HIVE Transactions Configuration Failed

apurvm — Wed, 11 May 2016 19:56:05 GMT

I was trying to enable transaction support for hive.

I modified the configurations as follows using Ambari:

hive.support.concurrency – truehive.enforce.bucketing – truehive.exec.dynamic.partition.mode – nonstricthive.txn.manager – org.apache.hadoop.hive.ql.lockmgr.DbTxnManagerhive.compactor.initiator.on – truehive.compactor.worker.threads – 1

When I restart the hive service I get the following error

The stacktrace from hivemetastore.log

2016-05-11 12:38:50,770 ERROR [hdp-node1.localdomain-35]: compactor.Worker (Worker.java:run(181)) - Caught an exception in the main loop of compactor worker hdp-node1.localdomain-35, java.lang.AbstractMethodError: Method com/mysql/jdbc/ResultSet.isClosed()Z is abstract
at com.mysql.jdbc.ResultSet.isClosed(ResultSet.java)
at org.apache.hadoop.hive.metastore.txn.TxnHandler.close(TxnHandler.java:1024)
at org.apache.hadoop.hive.metastore.txn.TxnHandler.close(TxnHandler.java:1036)
at org.apache.hadoop.hive.metastore.txn.CompactionTxnHandler.findNextToCompact(CompactionTxnHandler.java:217)
at org.apache.hadoop.hive.ql.txn.compactor.Worker.run(Worker.java:81) 
2016-05-11 12:38:50,771 INFO  [Thread-5]: metastore.ObjectStore (ObjectStore.java:initialize(294)) - ObjectStore, initialize called 
2016-05-11 12:38:50,774 ERROR [hdp-node1.localdomain-36]: compactor.Worker (Worker.java:run(181)) - Caught an exception in the main loop of compactor worker hdp-node1.localdomain-36, java.lang.AbstractMethodError: Method com/mysql/jdbc/ResultSet.isClosed()Z is abstract
at com.mysql.jdbc.ResultSet.isClosed(ResultSet.java)
at org.apache.hadoop.hive.metastore.txn.TxnHandler.close(TxnHandler.java:1024)
at org.apache.hadoop.hive.metastore.txn.TxnHandler.close(TxnHandler.java:1036)
at org.apache.hadoop.hive.metastore.txn.CompactionTxnHandler.findNextToCompact(CompactionTxnHandler.java:217)
at org.apache.hadoop.hive.ql.txn.compactor.Worker.run(Worker.java:81)

Specifications:

Hive 1.2.1 HDP 2.4.0.0-169 Apache Ambari Version 2.2.1.0

Re: HIVE Transactions Configuration Failed

quadoss — Thu, 12 May 2016 01:10:15 GMT

@Apurv Mehra

What is the mysql driver version that you are using and the JDK version that is being used. It could be that the mysql driver is not compatible with the JDK. Can you please use the latest version of the mysql-connector-java*.jar file and see if this helps

Re: HIVE Transactions Configuration Failed

apurvm — Thu, 12 May 2016 17:07:43 GMT

@mbalakrishnan I updated the mysql connector jars in the cluster and the error was resolved. Thanks for the help.

question Re: HIVE Transactions Configuration Failed in Archives of Support Questions (Read Only)

HIVE Transactions Configuration Failed

Re: HIVE Transactions Configuration Failed

Re: HIVE Transactions Configuration Failed