hive-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Eugene Koifman <>
Subject Re: Error communicating with metastore
Date Tue, 04 Aug 2015 22:08:09 GMT
could you execute "set hive.txn.manager" and "set hive.metastore.uris" in Hive CLI to confirm
that your client is configured correctly?

From: Sarath Chandra <<>>
Reply-To: "<>" <<>>
Date: Monday, August 3, 2015 at 8:02 PM
To: "<>" <<>>
Subject: Re: Error communicating with metastore

Thanks Alan.

Yes I've run metastore scripts for oracle instance. Infact I've removed my previous metastore
and created a fresh one by running the schema creation script for 1.2.1. I've looked into
the new schema and able to see the table TXNS. I've also removed the hdfs location "/user/hive/warehouse"
and created a fresh one.

But still I'm facing this issue.

On Mon, Aug 3, 2015 at 8:59 PM, Alan Gates <<>>
Did you run the hive metastore upgrade scripts for your oracle instance?  This error message
usually means the transaction related tables have not been created in your database.  Somewhere
in your distribution there should be a set of upgrade scripts.  Look for scripts of the form:


You'll want to run all of the ones from 0.13 to 1.2 (0.13->0.14, 0.14->1.1, 1.1->1.2).
 The 0.13->0.14 scripts assume that you added the transaction tables as part of upgrading
to Hive 0.13.  If you did not you will need to first run
which will create the initial transaction tables.  You can determine whether this was done
by looking for a table named TXNS in the hive schema on your Oracle db.


Sarath Chandra<>
August 3, 2015 at 6:29
Hi All,

Earlier I was using hive 0.13.0 and now trying to migrate to latest version to utilize the
transaction support introduced from hive 0.14.0.

I downloaded hive 1.2.1, created a metastore in oracle database and provided all the required
configuration parameters in conf/hive-site.xml to enable transactions. For the parameter "hive.txn.manager"
given the value "org.apache.hadoop.hive.ql.lockmgr.DbTxnManager".

>From the hive prompt when I fire the command "show tables;" I'm getting the below exception
FAILED: Error in determining valid transactions: Error communicating with the metastore

But if disable the "hive.txn.manager" parameter in hive-site.xml then the command works fine.

Is there anything else to be configured which I'm missing?

Thanks & Regards,

View raw message