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 LinkedIn * https://www.linkedin.com/profile/view?id=AAEAAAAWh2gBxianrbJd6zP6AcPCCdOABUrV8Pw <https://www.linkedin.com/profile/view?id=AAEAAAAWh2gBxianrbJd6zP6AcPCCdOABUrV8Pw>* http://talebzadehmich.wordpress.com *Disclaimer:* Use it at your own risk. Any and all responsibility for any loss, damage or destruction of data or any other property which may arise from relying on this email's technical content is explicitly disclaimed. The author will in no case be liable for any monetary damages arising from such loss, damage or destruction. On 22 August 2016 at 16:27, Igor Kuzmenko <f1she...@gmail.com> wrote: > 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_HOST, > TC_TXNID, TC_DATABASE, TC_TABLE, TC_PARTITION > '78461824', 'a', '1471762974000', '1471768488000', 'storm', 'sorm-data03. > msk.mts.ru', '78461824', 'default', 'data_http', 'dt=20160821' > > > > At the same time: > > select * from TXNS, TXN_COMPONENTS > where 1=1 > and TXNS.TXN_ID = TXN_COMPONENTS.TC_TXNID > and TXNS.TXN_ID = 78461824 > ; > > > # TXN_ID, TXN_STATE, TXN_STARTED, TXN_LAST_HEARTBEAT, TXN_USER, TXN_HOST, > TC_TXNID, TC_DATABASE, TC_TABLE, TC_PARTITION > 78461824, a, 1471762974000, 1471768488000, storm, sorm-data03.msk.mts.ru, > 78461824, default, data_http, dt=20160821 > > > Txn 78461824 is in aborted state, but still keep lock on table > 'data_http'. How can I avoid this? What should I do to get rid of that > lock? > >
