HIVE-9199: Excessive exclusive lock used in some DDLs with DummyTxnManager (Chaoyu via Xuefu, reviewed by Alan)

git-svn-id: https://svn.apache.org/repos/asf/hive/trunk@1647855 13f79535-47bb-0310-9956-ffa450edef68