Re: Reading tables will lock entire database in Hive 0.13

2015-08-31 Thread Jim Green
I found the answer…hive.txn.manager is added starting in hive 0.13. Thanks all. On Mon, Aug 31, 2015 at 3:54 PM, Jim Green wrote: > Hi Team, > > This issue only happens on hive 0.13, not in Hive 0.12. > Does anybody know what is the change between 0.12 and 0.13 which caused > this issue? > > Tha

Re: Reading tables will lock entire database in Hive 0.13

2015-08-31 Thread Jim Green
Hi Team, This issue only happens on hive 0.13, not in Hive 0.12. Does anybody know what is the change between 0.12 and 0.13 which caused this issue? Thanks. On Sat, Feb 28, 2015 at 3:47 AM, Chaoyu Tang wrote: > It was fixed for DummyTxnManager. DbTxnManager should not have this issue. > > Than

Re: Reading tables will lock entire database in Hive 0.13

2015-02-28 Thread Chaoyu Tang
It was fixed for DummyTxnManager. DbTxnManager should not have this issue. Thanks On Thu, Feb 26, 2015 at 1:52 PM, Jim Green wrote: > Hi Chaoyu, > > Thanks for the information. > Actually by default, if we set hive.support.concurrency=true in Hive 0.13: > > hive.lock.manager=org.apache.hadoop.h

Re: Reading tables will lock entire database in Hive 0.13

2015-02-26 Thread Jim Green
Hi Chaoyu, Thanks for the information. Actually by default, if we set hive.support.concurrency=true in Hive 0.13: hive.lock.manager=org.apache.hadoop.hive.ql.lockmgr.zookeeper.ZooKeeperHiveLockManager hive.txn.manager=org.apache.hadoop.hive.ql.lockmgr.DummyTxnManager Hive-9199 mentioned it is fix

Re: Reading tables will lock entire database in Hive 0.13

2015-02-26 Thread Chaoyu Tang
If you are using DummyTxnManager, please see HIVE-9199 which should resolve the issue. Thanks Chaoyu On Wed, Feb 25, 2015 at 11:57 PM, Alan Gates wrote: > What lock manager are you using? > > Alan. > > Jim Green > February 25, 2015 at 17:24 > Hi Team, > > Here is old thread about this issu

Re: Reading tables will lock entire database in Hive 0.13

2015-02-25 Thread Alan Gates
What lock manager are you using? Alan. Jim Green February 25, 2015 at 17:24 Hi Team, Here is old thread about this issue: http://qnalist.com/questions/5091386/doubt-about-locking-mechanism-in-hive I met the same issue that when reading one table in session A, we

Reading tables will lock entire database in Hive 0.13

2015-02-25 Thread Jim Green
Hi Team, Here is old thread about this issue: http://qnalist.com/questions/5091386/doubt-about-locking-mechanism-in-hive I met the same issue that when reading one table in session A, we can not create a table in the same database in session B. Basically it causes database level lock in Hive 0.13