Re: Hive transaction doesn't release lock.

...@gmail.com>> Reply-To: "user@hive.apache.org<mailto:user@hive.apache.org>" mailto:user@hive.apache.org>> Date: Wednesday, August 24, 2016 at 3:32 AM To: "user@hive.apache.org<mailto:user@hive.apache.org>" mailto:user@hive.apache.org>> Subject: Re: H

Re: Hive transaction doesn't release lock.

t * from HIVE_LOCKS” but the output is not from > HIVE_LOCKS. > What entries do you have in HIVE_LOCKS for this txn_id? > > If all you see is an entry in TXN table in ‘a’ state – that is OK. that > just mean that this transaction was aborted. > > Eugene > > From: I

Re: Hive transaction doesn't release lock.

uzmenko mailto:f1she...@gmail.com>> Reply-To: "user@hive.apache.org<mailto:user@hive.apache.org>" mailto:user@hive.apache.org>> Date: Monday, August 22, 2016 at 8:27 AM To: "user@hive.apache.org<mailto:user@hive.apache.org>" mailto:user@hive.apache.o

Re: Hive transaction doesn't release lock.

Hi Igor, I don't think so. Well I never raised one! HTH Dr Mich Talebzadeh LinkedIn * https://www.linkedin.com/profile/view?id=AAEWh2gBxianrbJd6zP6AcPCCdOABUrV8Pw * http://talebzadehmich.wordpress.com

Re: Hive transaction doesn't release lock.

Thanks for reply, Mich. Is there any open item in Jira? On Mon, Aug 22, 2016 at 9:28 PM, Mich Talebzadeh wrote: > there are issues with locks not being released even when the transaction > is aborted. There are still entries in hive_locks. > > I ended up deleting the row from hive_locks table ma

Re: Hive transaction doesn't release lock.

there are issues with locks not being released even when the transaction is aborted. There are still entries in hive_locks. I ended up deleting the row from hive_locks table manually. Not ideal but you know that the lock should not be there as the table is dropped. HTH Dr Mich Talebzadeh Link

Hive transaction doesn't release lock.

Hello, I'm using Apache Hive 1.2.1 and Apache Storm to stream data in hive table. After making some tests I tried to truncate my table, but sql execution doesn't complete because of the lock on table: select * from HIVE_LOCKS; # TXN_ID, TXN_STATE, TXN_STARTED, TXN_LAST_HEARTBEAT, TXN_USER, TXN_