You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@hive.apache.org by jc...@apache.org on 2018/01/17 07:37:00 UTC
hive git commit: HIVE-18465: Hive metastore schema initialization
failing on postgres (Deepesh Khandelwal, reviewed by Jesus Camacho Rodriguez)
Repository: hive
Updated Branches:
refs/heads/master 798a17c67 -> 7942bc6c9
HIVE-18465: Hive metastore schema initialization failing on postgres (Deepesh Khandelwal, reviewed by Jesus Camacho Rodriguez)
Project: http://git-wip-us.apache.org/repos/asf/hive/repo
Commit: http://git-wip-us.apache.org/repos/asf/hive/commit/7942bc6c
Tree: http://git-wip-us.apache.org/repos/asf/hive/tree/7942bc6c
Diff: http://git-wip-us.apache.org/repos/asf/hive/diff/7942bc6c
Branch: refs/heads/master
Commit: 7942bc6c9a38e71ff3f8936508cc773a464b0d87
Parents: 798a17c
Author: Deepesh Khandelwal <de...@hotmail.com>
Authored: Tue Jan 16 23:35:14 2018 -0800
Committer: Jesus Camacho Rodriguez <jc...@apache.org>
Committed: Tue Jan 16 23:35:14 2018 -0800
----------------------------------------------------------------------
.../scripts/upgrade/postgres/hive-schema-3.0.0.postgres.sql | 6 +++---
1 file changed, 3 insertions(+), 3 deletions(-)
----------------------------------------------------------------------
http://git-wip-us.apache.org/repos/asf/hive/blob/7942bc6c/metastore/scripts/upgrade/postgres/hive-schema-3.0.0.postgres.sql
----------------------------------------------------------------------
diff --git a/metastore/scripts/upgrade/postgres/hive-schema-3.0.0.postgres.sql b/metastore/scripts/upgrade/postgres/hive-schema-3.0.0.postgres.sql
index 9e2dbc2..28cb016 100644
--- a/metastore/scripts/upgrade/postgres/hive-schema-3.0.0.postgres.sql
+++ b/metastore/scripts/upgrade/postgres/hive-schema-3.0.0.postgres.sql
@@ -665,9 +665,6 @@ CREATE TABLE "MV_CREATION_METADATA" (
"LAST_TRANSACTION_INFO" TEXT NOT NULL
);
-ALTER TABLE ONLY "MV_CREATION_METADATA"
- ADD CONSTRAINT "MV_CREATION_METADATA_FK" FOREIGN KEY ("TBL_ID") REFERENCES "TBLS"("TBL_ID") DEFERRABLE;
-
--
-- Name: BUCKETING_COLS_pkey; Type: CONSTRAINT; Schema: public; Owner: hiveuser; Tablespace:
--
@@ -1575,6 +1572,9 @@ ALTER TABLE ONLY "WM_MAPPING"
ALTER TABLE ONLY "WM_MAPPING"
ADD CONSTRAINT "WM_MAPPING_FK2" FOREIGN KEY ("POOL_ID") REFERENCES "WM_POOL" ("POOL_ID") DEFERRABLE;
+ALTER TABLE ONLY "MV_CREATION_METADATA"
+ ADD CONSTRAINT "MV_CREATION_METADATA_FK" FOREIGN KEY ("TBL_ID") REFERENCES "TBLS"("TBL_ID") DEFERRABLE;
+
--
-- Name: public; Type: ACL; Schema: -; Owner: hiveuser
--