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