I am experiencing a possible deadlock issue while working with Hive version 4.1.0. The issue occurs when an 'insert overwrite' query is executed on an Iceberg table. Specifically, I have found that if the 'hive.txn.manager' setting is 'org.apache.hadoop.hive.ql.lockmgr.DbTxnManager', a deadlock seems to happen.
I would like to know whether this is a bug or a limitation. Is it that 'org.apache.hadoop.hive.ql.lockmgr.DbTxnManager' should not be used in this case? I greatly appreciate any guidance or information on this issue.
