I have many open transactions on table that i cant' delete.
Even if i delete the table, transactions are still open.
There is a way to rollback these transactions?
There is a way to kill pending locks?
Hive version : 1.2.1
In the short run you can always look at the metastore database (assuming you're using the db txn manager) and try to clear them manually from the tables there.
I don't recommend directly messing with the RDBMs. If you can't find any other way out and must make changes in the RDBMS, you should make sure to just switch the transactions states from open to aborted. Removing the transactions completely may have undesirable side effects.