hive-commits mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From sp...@apache.org
Subject hive git commit: HIVE-10734: Remove COLUMNS_OLD table from a schema definition file of PostgreSQL (Shinichi Yamashita, reviewed by Sergio Pena)
Date Wed, 20 May 2015 16:15:00 GMT
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 <sergio.pena@cloudera.com>
Authored: Wed May 20 11:14:09 2015 -0500
Committer: Sergio Pena <sergio.pena@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
 --
 


Mime
View raw message