Thanks Sharath for your reply. I'm specifying these parameters already. I've followed the documentation at https://cwiki.apache.org/confluence/display/Hive/Hive+Transactions
But it still throws me this error On Mon, Aug 3, 2015 at 8:45 PM, Sharath Punreddy <srpunre...@gmail.com> wrote: > Here is another one: > > http://stackoverflow.com/questions/28867368/hive-transactions-are-crashing > > On Mon, Aug 3, 2015 at 10:13 AM, Sharath Punreddy <srpunre...@gmail.com> > wrote: > >> Check out: >> http://docs.hortonworks.com/HDPDocuments/HDP2/HDP-2.1.1/bk_dataintegration/content/ch_using-hive-transactions.html >> >> You need to specify the following properties as well: >> >> - >> >> hive.txn.driver >> - >> >> hive.compactor.initiator.on >> - >> >> hive.compactor.worker.threads >> >> >> On Mon, Aug 3, 2015 at 8:29 AM, Sarath Chandra < >> sarathchandra.jos...@algofusiontech.com> wrote: >> >>> 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. >>> >> >> >> >> -- >> >> >> >> *Sharath Punreddy* >> *Phone:626-470-7867 <626-470-7867>* >> > > > > -- > > > > *Sharath Punreddy* > *Phone:626-470-7867* >
