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?
