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:
scripts/metastore/upgrade/oracle/upgrade-0.13.0-to-0.14.0.oracle.sql
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 hive-txn-schema-0.13.0.oracle.sql 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.
Alan.
Sarath Chandra <mailto:sarathchandra.jos...@algofusiontech.com>
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,
Sarath.
