You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@hive.apache.org by da...@apache.org on 2018/06/12 06:32:10 UTC

hive git commit: HIVE-19862: Postgres init script has a glitch around UNIQUE_DATABASE (Daniel Dai, reviewed by Alan Gates)

Repository: hive
Updated Branches:
  refs/heads/master 890256356 -> 53a146fbf


HIVE-19862: Postgres init script has a glitch around UNIQUE_DATABASE (Daniel Dai, reviewed by Alan Gates)


Project: http://git-wip-us.apache.org/repos/asf/hive/repo
Commit: http://git-wip-us.apache.org/repos/asf/hive/commit/53a146fb
Tree: http://git-wip-us.apache.org/repos/asf/hive/tree/53a146fb
Diff: http://git-wip-us.apache.org/repos/asf/hive/diff/53a146fb

Branch: refs/heads/master
Commit: 53a146fbf3ec46bece8480aee3eb5b7ec9f78136
Parents: 8902563
Author: Daniel Dai <da...@gmail.com>
Authored: Mon Jun 11 23:31:56 2018 -0700
Committer: Daniel Dai <da...@gmail.com>
Committed: Mon Jun 11 23:31:56 2018 -0700

----------------------------------------------------------------------
 .../src/main/sql/postgres/hive-schema-3.0.0.postgres.sql           | 2 +-
 .../src/main/sql/postgres/hive-schema-3.1.0.postgres.sql           | 2 +-
 .../src/main/sql/postgres/hive-schema-4.0.0.postgres.sql           | 2 +-
 3 files changed, 3 insertions(+), 3 deletions(-)
----------------------------------------------------------------------


http://git-wip-us.apache.org/repos/asf/hive/blob/53a146fb/standalone-metastore/src/main/sql/postgres/hive-schema-3.0.0.postgres.sql
----------------------------------------------------------------------
diff --git a/standalone-metastore/src/main/sql/postgres/hive-schema-3.0.0.postgres.sql b/standalone-metastore/src/main/sql/postgres/hive-schema-3.0.0.postgres.sql
index d210a55..97697f8 100644
--- a/standalone-metastore/src/main/sql/postgres/hive-schema-3.0.0.postgres.sql
+++ b/standalone-metastore/src/main/sql/postgres/hive-schema-3.0.0.postgres.sql
@@ -1024,7 +1024,7 @@ ALTER TABLE ONLY "TBLS"
 --
 
 ALTER TABLE ONLY "DBS"
-    ADD CONSTRAINT "UNIQUE_DATABASE" UNIQUE ("NAME");
+    ADD CONSTRAINT "UNIQUE_DATABASE" UNIQUE ("NAME", "CTLG_NAME");
 
 
 --

http://git-wip-us.apache.org/repos/asf/hive/blob/53a146fb/standalone-metastore/src/main/sql/postgres/hive-schema-3.1.0.postgres.sql
----------------------------------------------------------------------
diff --git a/standalone-metastore/src/main/sql/postgres/hive-schema-3.1.0.postgres.sql b/standalone-metastore/src/main/sql/postgres/hive-schema-3.1.0.postgres.sql
index 4bdad7a..36bab70 100644
--- a/standalone-metastore/src/main/sql/postgres/hive-schema-3.1.0.postgres.sql
+++ b/standalone-metastore/src/main/sql/postgres/hive-schema-3.1.0.postgres.sql
@@ -1030,7 +1030,7 @@ ALTER TABLE ONLY "TBLS"
 --
 
 ALTER TABLE ONLY "DBS"
-    ADD CONSTRAINT "UNIQUE_DATABASE" UNIQUE ("NAME");
+    ADD CONSTRAINT "UNIQUE_DATABASE" UNIQUE ("NAME", "CTLG_NAME");
 
 
 --

http://git-wip-us.apache.org/repos/asf/hive/blob/53a146fb/standalone-metastore/src/main/sql/postgres/hive-schema-4.0.0.postgres.sql
----------------------------------------------------------------------
diff --git a/standalone-metastore/src/main/sql/postgres/hive-schema-4.0.0.postgres.sql b/standalone-metastore/src/main/sql/postgres/hive-schema-4.0.0.postgres.sql
index fdb1f59..b73e1d1 100644
--- a/standalone-metastore/src/main/sql/postgres/hive-schema-4.0.0.postgres.sql
+++ b/standalone-metastore/src/main/sql/postgres/hive-schema-4.0.0.postgres.sql
@@ -1030,7 +1030,7 @@ ALTER TABLE ONLY "TBLS"
 --
 
 ALTER TABLE ONLY "DBS"
-    ADD CONSTRAINT "UNIQUE_DATABASE" UNIQUE ("NAME");
+    ADD CONSTRAINT "UNIQUE_DATABASE" UNIQUE ("NAME", "CTLG_NAME");
 
 
 --