Hi, IMO, 'org.apache.hadoop.hive.ql.lockmgr.DbTxnManager' is used for hive native acid table, not for Iceberg table. The lock mechanism in Iceberg table is controlled by HMS Catalog or other Iceberg Catalog(JDBC catalog, etc). So 'org.apache.hadoop.hive.ql.lockmgr.DbTxnManager' should not be used in your case(insert overwrite iceberg table).
Thanks, Butao Zhang On 2025/03/26 04:54:33 박근형 wrote: > 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. >