You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@hive.apache.org by sp...@apache.org on 2015/05/20 18:15:00 UTC
hive git commit: HIVE-10734: Remove COLUMNS_OLD table from a schema
definition file of PostgreSQL (Shinichi Yamashita, reviewed by Sergio Pena)
Repository: hive
Updated Branches:
refs/heads/master ed2f40e35 -> fc05556ce
HIVE-10734: Remove COLUMNS_OLD table from a schema definition file of PostgreSQL (Shinichi Yamashita, reviewed by Sergio Pena)
Project: http://git-wip-us.apache.org/repos/asf/hive/repo
Commit: http://git-wip-us.apache.org/repos/asf/hive/commit/fc05556c
Tree: http://git-wip-us.apache.org/repos/asf/hive/tree/fc05556c
Diff: http://git-wip-us.apache.org/repos/asf/hive/diff/fc05556c
Branch: refs/heads/master
Commit: fc05556ceb957a2cdefc0f54c2393ad2bf4b426f
Parents: ed2f40e
Author: Sergio Pena <se...@cloudera.com>
Authored: Wed May 20 11:14:09 2015 -0500
Committer: Sergio Pena <se...@cloudera.com>
Committed: Wed May 20 11:14:09 2015 -0500
----------------------------------------------------------------------
.../postgres/hive-schema-1.3.0.postgres.sql | 36 --------------------
1 file changed, 36 deletions(-)
----------------------------------------------------------------------
http://git-wip-us.apache.org/repos/asf/hive/blob/fc05556c/metastore/scripts/upgrade/postgres/hive-schema-1.3.0.postgres.sql
----------------------------------------------------------------------
diff --git a/metastore/scripts/upgrade/postgres/hive-schema-1.3.0.postgres.sql b/metastore/scripts/upgrade/postgres/hive-schema-1.3.0.postgres.sql
index d2e8a0e..3ab5b3e 100644
--- a/metastore/scripts/upgrade/postgres/hive-schema-1.3.0.postgres.sql
+++ b/metastore/scripts/upgrade/postgres/hive-schema-1.3.0.postgres.sql
@@ -36,19 +36,6 @@ CREATE TABLE "CDS" (
--
--- Name: COLUMNS_OLD; Type: TABLE; Schema: public; Owner: hiveuser; Tablespace:
---
-
-CREATE TABLE "COLUMNS_OLD" (
- "SD_ID" bigint NOT NULL,
- "COMMENT" character varying(256) DEFAULT NULL::character varying,
- "COLUMN_NAME" character varying(128) NOT NULL,
- "TYPE_NAME" character varying(4000) NOT NULL,
- "INTEGER_IDX" bigint NOT NULL
-);
-
-
---
-- Name: COLUMNS_V2; Type: TABLE; Schema: public; Owner: hiveuser; Tablespace:
--
@@ -623,14 +610,6 @@ ALTER TABLE ONLY "COLUMNS_V2"
--
--- Name: COLUMNS_pkey; Type: CONSTRAINT; Schema: public; Owner: hiveuser; Tablespace:
---
-
-ALTER TABLE ONLY "COLUMNS_OLD"
- ADD CONSTRAINT "COLUMNS_pkey" PRIMARY KEY ("SD_ID", "COLUMN_NAME");
-
-
---
-- Name: DATABASE_PARAMS_pkey; Type: CONSTRAINT; Schema: public; Owner: hiveuser; Tablespace:
--
@@ -959,13 +938,6 @@ CREATE INDEX "BUCKETING_COLS_N49" ON "BUCKETING_COLS" USING btree ("SD_ID");
--
--- Name: COLUMNS_N49; Type: INDEX; Schema: public; Owner: hiveuser; Tablespace:
---
-
-CREATE INDEX "COLUMNS_N49" ON "COLUMNS_OLD" USING btree ("SD_ID");
-
-
---
-- Name: DATABASE_PARAMS_N49; Type: INDEX; Schema: public; Owner: hiveuser; Tablespace:
--
@@ -1235,14 +1207,6 @@ ALTER TABLE ONLY "BUCKETING_COLS"
--
--- Name: COLUMNS_SD_ID_fkey; Type: FK CONSTRAINT; Schema: public; Owner: hiveuser
---
-
-ALTER TABLE ONLY "COLUMNS_OLD"
- ADD CONSTRAINT "COLUMNS_SD_ID_fkey" FOREIGN KEY ("SD_ID") REFERENCES "SDS"("SD_ID") DEFERRABLE;
-
-
---
-- Name: COLUMNS_V2_CD_ID_fkey; Type: FK CONSTRAINT; Schema: public; Owner: hiveuser
--