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 <[email protected]> Authored: Mon Jun 11 23:31:56 2018 -0700 Committer: Daniel Dai <[email protected]> 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"); --
