Author: hashutosh
Date: Fri Sep 27 17:56:17 2013
New Revision: 1527007
URL: http://svn.apache.org/r1527007
Log:
HIVE-5374 : hive-schema-0.13.0.postgres.sql doesn't work (Kousuke Saruta via
Ashutosh Chauhan)
Modified:
hive/trunk/metastore/scripts/upgrade/postgres/014-HIVE-3764.postgres.sql
hive/trunk/metastore/scripts/upgrade/postgres/hive-schema-0.12.0.postgres.sql
hive/trunk/metastore/scripts/upgrade/postgres/hive-schema-0.13.0.postgres.sql
hive/trunk/metastore/scripts/upgrade/postgres/upgrade-0.11.0-to-0.12.0.postgres.sql
hive/trunk/metastore/scripts/upgrade/postgres/upgrade-0.12.0-to-0.13.0.postgres.sql
Modified:
hive/trunk/metastore/scripts/upgrade/postgres/014-HIVE-3764.postgres.sql
URL:
http://svn.apache.org/viewvc/hive/trunk/metastore/scripts/upgrade/postgres/014-HIVE-3764.postgres.sql?rev=1527007&r1=1527006&r2=1527007&view=diff
==============================================================================
--- hive/trunk/metastore/scripts/upgrade/postgres/014-HIVE-3764.postgres.sql
(original)
+++ hive/trunk/metastore/scripts/upgrade/postgres/014-HIVE-3764.postgres.sql
Fri Sep 27 17:56:17 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/trunk/metastore/scripts/upgrade/postgres/hive-schema-0.12.0.postgres.sql
URL:
http://svn.apache.org/viewvc/hive/trunk/metastore/scripts/upgrade/postgres/hive-schema-0.12.0.postgres.sql?rev=1527007&r1=1527006&r2=1527007&view=diff
==============================================================================
---
hive/trunk/metastore/scripts/upgrade/postgres/hive-schema-0.12.0.postgres.sql
(original)
+++
hive/trunk/metastore/scripts/upgrade/postgres/hive-schema-0.12.0.postgres.sql
Fri Sep 27 17:56:17 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/trunk/metastore/scripts/upgrade/postgres/hive-schema-0.13.0.postgres.sql
URL:
http://svn.apache.org/viewvc/hive/trunk/metastore/scripts/upgrade/postgres/hive-schema-0.13.0.postgres.sql?rev=1527007&r1=1527006&r2=1527007&view=diff
==============================================================================
---
hive/trunk/metastore/scripts/upgrade/postgres/hive-schema-0.13.0.postgres.sql
(original)
+++
hive/trunk/metastore/scripts/upgrade/postgres/hive-schema-0.13.0.postgres.sql
Fri Sep 27 17:56:17 2013
@@ -521,8 +521,7 @@ CREATE TABLE "TAB_COL_STATS" (
CREATE TABLE "VERSION" (
"VER_ID" bigint,
"SCHEMA_VERSION" character varying(127) NOT NULL,
- "COMMENT" character varying(255) NOT NULL,
- PRIMARY KEY ("VER_ID")
+ "VERSION_COMMENT" character varying(255) NOT NULL
);
--
@@ -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.13.0', 'Hive release version 0.13.0');
+INSERT INTO "VERSION" ("VER_ID", "SCHEMA_VERSION", "VERSION_COMMENT") VALUES
(1, '0.13.0', 'Hive release version 0.13.0');
--
-- PostgreSQL database dump complete
--
Modified:
hive/trunk/metastore/scripts/upgrade/postgres/upgrade-0.11.0-to-0.12.0.postgres.sql
URL:
http://svn.apache.org/viewvc/hive/trunk/metastore/scripts/upgrade/postgres/upgrade-0.11.0-to-0.12.0.postgres.sql?rev=1527007&r1=1527006&r2=1527007&view=diff
==============================================================================
---
hive/trunk/metastore/scripts/upgrade/postgres/upgrade-0.11.0-to-0.12.0.postgres.sql
(original)
+++
hive/trunk/metastore/scripts/upgrade/postgres/upgrade-0.11.0-to-0.12.0.postgres.sql
Fri Sep 27 17:56:17 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';
Modified:
hive/trunk/metastore/scripts/upgrade/postgres/upgrade-0.12.0-to-0.13.0.postgres.sql
URL:
http://svn.apache.org/viewvc/hive/trunk/metastore/scripts/upgrade/postgres/upgrade-0.12.0-to-0.13.0.postgres.sql?rev=1527007&r1=1527006&r2=1527007&view=diff
==============================================================================
---
hive/trunk/metastore/scripts/upgrade/postgres/upgrade-0.12.0-to-0.13.0.postgres.sql
(original)
+++
hive/trunk/metastore/scripts/upgrade/postgres/upgrade-0.12.0-to-0.13.0.postgres.sql
Fri Sep 27 17:56:17 2013
@@ -1,3 +1,3 @@
SELECT 'Upgrading MetaStore schema from 0.11.0 to 0.12.0';
-UPDATE VERSION SET SCHEMA_VERSION='0.13.0', VERSION_COMMENT='Hive release
version 0.13.0' where VER_ID=1;
+UPDATE "VERSION" SET "SCHEMA_VERSION"='0.13.0', "VERSION_COMMENT"='Hive
release version 0.13.0' where "VER_ID"=1;
SELECT 'Finished upgrading MetaStore schema from 0.11.0 to 0.12.0';
