Member since
05-11-2016
2
Posts
0
Kudos Received
0
Solutions
05-12-2016
10:07 AM
@mbalakrishnan I updated the mysql connector jars in the cluster and the error was resolved. Thanks for the help.
... View more
05-11-2016
12:56 PM
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
... View more
Labels:
- Labels:
-
Apache Hive