Repository: hive Updated Branches: refs/heads/branch-3 72ebbff0e -> e01b45cd9
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/e01b45cd Tree: http://git-wip-us.apache.org/repos/asf/hive/tree/e01b45cd Diff: http://git-wip-us.apache.org/repos/asf/hive/diff/e01b45cd Branch: refs/heads/branch-3 Commit: e01b45cd9ed1d44a89b7affccafacb7b41c79c66 Parents: 72ebbff Author: Daniel Dai <dai...@gmail.com> Authored: Mon Jun 11 23:32:34 2018 -0700 Committer: Daniel Dai <dai...@gmail.com> Committed: Mon Jun 11 23:32:34 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 +- 2 files changed, 2 insertions(+), 2 deletions(-) ---------------------------------------------------------------------- http://git-wip-us.apache.org/repos/asf/hive/blob/e01b45cd/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/e01b45cd/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 64c97fc..4570201 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"); --