You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@hive.apache.org by th...@apache.org on 2013/09/27 20:44:57 UTC
svn commit: r1527025 - in
/hive/branches/branch-0.12/metastore/scripts/upgrade/postgres:
014-HIVE-3764.postgres.sql hive-schema-0.12.0.postgres.sql
upgrade-0.11.0-to-0.12.0.postgres.sql
Author: thejas
Date: Fri Sep 27 18:44:56 2013
New Revision: 1527025
URL: http://svn.apache.org/r1527025
Log:
HIVE-5374: hive-schema-0.13.0.postgres.sql doesn't work (Kousuke Saruta via Ashutosh Chauhan)
Modified:
hive/branches/branch-0.12/metastore/scripts/upgrade/postgres/014-HIVE-3764.postgres.sql
hive/branches/branch-0.12/metastore/scripts/upgrade/postgres/hive-schema-0.12.0.postgres.sql
hive/branches/branch-0.12/metastore/scripts/upgrade/postgres/upgrade-0.11.0-to-0.12.0.postgres.sql
Modified: hive/branches/branch-0.12/metastore/scripts/upgrade/postgres/014-HIVE-3764.postgres.sql
URL: http://svn.apache.org/viewvc/hive/branches/branch-0.12/metastore/scripts/upgrade/postgres/014-HIVE-3764.postgres.sql?rev=1527025&r1=1527024&r2=1527025&view=diff
==============================================================================
--- hive/branches/branch-0.12/metastore/scripts/upgrade/postgres/014-HIVE-3764.postgres.sql (original)
+++ hive/branches/branch-0.12/metastore/scripts/upgrade/postgres/014-HIVE-3764.postgres.sql Fri Sep 27 18:44:56 2013
@@ -4,9 +4,8 @@
CREATE TABLE "VERSION" (
"VER_ID" bigint,
"SCHEMA_VERSION" character varying(127) NOT NULL,
- "VERSION_COMMENT" character varying(255) NOT NULL,
- PRIMARY KEY ("VER_ID")
+ "VERSION_COMMENT" character varying(255) NOT NULL
);
ALTER TABLE ONLY "VERSION" ADD CONSTRAINT "VERSION_pkey" PRIMARY KEY ("VER_ID");
-INSERT INTO VERSION (VER_ID, SCHEMA_VERSION, VERSION_COMMENT) VALUES (1, '', 'Initial value');
+INSERT INTO "VERSION" ("VER_ID", "SCHEMA_VERSION", "VERSION_COMMENT") VALUES (1, '', 'Initial value');
Modified: hive/branches/branch-0.12/metastore/scripts/upgrade/postgres/hive-schema-0.12.0.postgres.sql
URL: http://svn.apache.org/viewvc/hive/branches/branch-0.12/metastore/scripts/upgrade/postgres/hive-schema-0.12.0.postgres.sql?rev=1527025&r1=1527024&r2=1527025&view=diff
==============================================================================
--- hive/branches/branch-0.12/metastore/scripts/upgrade/postgres/hive-schema-0.12.0.postgres.sql (original)
+++ hive/branches/branch-0.12/metastore/scripts/upgrade/postgres/hive-schema-0.12.0.postgres.sql Fri Sep 27 18:44:56 2013
@@ -522,7 +522,6 @@ CREATE TABLE "VERSION" (
"VER_ID" bigint,
"SCHEMA_VERSION" character varying(127) NOT NULL,
"VERSION_COMMENT" character varying(255) NOT NULL,
- PRIMARY KEY ("VER_ID")
);
--
@@ -1400,7 +1399,7 @@ REVOKE ALL ON SCHEMA public FROM PUBLIC;
GRANT ALL ON SCHEMA public TO PUBLIC;
-INSERT INTO VERSION (VER_ID, SCHEMA_VERSION, VERSION_COMMENT) VALUES (1, '0.12.0', 'Hive release version 0.12.0');
+INSERT INTO "VERSION" ("VER_ID", "SCHEMA_VERSION", "VERSION_COMMENT") VALUES (1, '0.12.0', 'Hive release version 0.12.0');
--
-- PostgreSQL database dump complete
--
Modified: hive/branches/branch-0.12/metastore/scripts/upgrade/postgres/upgrade-0.11.0-to-0.12.0.postgres.sql
URL: http://svn.apache.org/viewvc/hive/branches/branch-0.12/metastore/scripts/upgrade/postgres/upgrade-0.11.0-to-0.12.0.postgres.sql?rev=1527025&r1=1527024&r2=1527025&view=diff
==============================================================================
--- hive/branches/branch-0.12/metastore/scripts/upgrade/postgres/upgrade-0.11.0-to-0.12.0.postgres.sql (original)
+++ hive/branches/branch-0.12/metastore/scripts/upgrade/postgres/upgrade-0.11.0-to-0.12.0.postgres.sql Fri Sep 27 18:44:56 2013
@@ -1,5 +1,5 @@
SELECT 'Upgrading MetaStore schema from 0.11.0 to 0.12.0';
\i 013-HIVE-3255.postgres.sql;
\i 014-HIVE-3764.postgres.sql;
-UPDATE VERSION SET SCHEMA_VERSION='0.12.0', VERSION_COMMENT='Hive release version 0.12.0' where VER_ID=1;
+UPDATE "VERSION" SET "SCHEMA_VERSION"='0.12.0', "VERSION_COMMENT"='Hive release version 0.12.0' where "VER_ID"=1;
SELECT 'Finished upgrading MetaStore schema from 0.11.0 to 0.12.0';