This is an automated email from the ASF dual-hosted git repository.

dkuzmenko pushed a commit to branch branch-4.0
in repository https://gitbox.apache.org/repos/asf/hive.git


The following commit(s) were added to refs/heads/branch-4.0 by this push:
     new 16591ee67f2 HIVE-28307: Fast return when database exists and IF NOT 
EXISTS clause is enabled (#5292)(Wechar Yu, reviewed by Butao Zhang)
16591ee67f2 is described below

commit 16591ee67f22e6dca613492247239ef95bd6dade
Author: Wechar Yu <[email protected]>
AuthorDate: Thu Jun 20 23:21:48 2024 +0800

    HIVE-28307: Fast return when database exists and IF NOT EXISTS clause is 
enabled (#5292)(Wechar Yu, reviewed by Butao Zhang)
    
    (cherry picked from commit 1c9969a003b09abc851ae7e19631ad208d3b6066)
---
 .../hadoop/hive/ql/ddl/database/create/CreateDatabaseAnalyzer.java    | 4 ++++
 ql/src/test/results/clientpositive/llap/database.q.out                | 2 --
 2 files changed, 4 insertions(+), 2 deletions(-)

diff --git 
a/ql/src/java/org/apache/hadoop/hive/ql/ddl/database/create/CreateDatabaseAnalyzer.java
 
b/ql/src/java/org/apache/hadoop/hive/ql/ddl/database/create/CreateDatabaseAnalyzer.java
index e5041df1c46..ffa0ee72e11 100644
--- 
a/ql/src/java/org/apache/hadoop/hive/ql/ddl/database/create/CreateDatabaseAnalyzer.java
+++ 
b/ql/src/java/org/apache/hadoop/hive/ql/ddl/database/create/CreateDatabaseAnalyzer.java
@@ -90,6 +90,10 @@ public class CreateDatabaseAnalyzer extends 
BaseSemanticAnalyzer {
       }
     }
 
+    if (ifNotExists && getDatabase(databaseName, false) != null) {
+      return;
+    }
+
     CreateDatabaseDesc desc = null;
     Database database = new Database(databaseName, comment, locationUri, 
props);
     if (type.equalsIgnoreCase(DatabaseType.NATIVE.name())) {
diff --git a/ql/src/test/results/clientpositive/llap/database.q.out 
b/ql/src/test/results/clientpositive/llap/database.q.out
index 481aae02f51..842e075cdd3 100644
--- a/ql/src/test/results/clientpositive/llap/database.q.out
+++ b/ql/src/test/results/clientpositive/llap/database.q.out
@@ -17,10 +17,8 @@ default
 test_db
 PREHOOK: query: CREATE DATABASE IF NOT EXISTS test_db
 PREHOOK: type: CREATEDATABASE
-PREHOOK: Output: database:test_db
 POSTHOOK: query: CREATE DATABASE IF NOT EXISTS test_db
 POSTHOOK: type: CREATEDATABASE
-POSTHOOK: Output: database:test_db
 PREHOOK: query: SHOW DATABASES
 PREHOOK: type: SHOWDATABASES
 POSTHOOK: query: SHOW DATABASES

Reply via email to