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 <alanfga...@gmail.com> wrote: > 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 <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. > >
