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 <[email protected]> Authored: Wed May 20 11:14:09 2015 -0500 Committer: Sergio Pena <[email protected]> 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 --
