Details
Description
The patch of HIVE-6734 added some DDL writetypes and checked DDL writetype in DbTxnManager.java.
We use DummyTxnManager as the default value of hive.txn.manager in hive-site.xml. We noticed that the operation of CREATE TEMPORARY FUNCTION has a DLL_NO_LOCK writetype but it requires a EXCLUSIVE lock. If we try to create a temporary function while there's a SELECT is processing at the same database, then the console will print 'conflicting lock present for default mode EXCLUSIVE' and the CREATE TEMPORARY FUNCTION operation won't get the lock until the SELECT is done. Maybe it's a good idea to check the DDL's writetype in DummyTxnManager too.
Attachments
Attachments
Issue Links
- is duplicated by
-
HIVE-9199 Excessive exclusive lock used in some DDLs with DummyTxnManager
- Resolved