Author: hashutosh
Date: Mon Mar 17 23:37:38 2014
New Revision: 1578664
URL: http://svn.apache.org/r1578664
Log:
HIVE-6666 : Metastore init scripts should always populate the version
information at the end (Prasad Mujumdar via Ashutosh Chauhan)
Modified:
hive/branches/branch-0.13/metastore/scripts/upgrade/derby/hive-schema-0.13.0.derby.sql
hive/branches/branch-0.13/metastore/scripts/upgrade/mysql/hive-schema-0.13.0.mysql.sql
hive/branches/branch-0.13/metastore/scripts/upgrade/oracle/hive-schema-0.13.0.oracle.sql
hive/branches/branch-0.13/metastore/scripts/upgrade/postgres/hive-schema-0.13.0.postgres.sql
Modified:
hive/branches/branch-0.13/metastore/scripts/upgrade/derby/hive-schema-0.13.0.derby.sql
URL:
http://svn.apache.org/viewvc/hive/branches/branch-0.13/metastore/scripts/upgrade/derby/hive-schema-0.13.0.derby.sql?rev=1578664&r1=1578663&r2=1578664&view=diff
==============================================================================
---
hive/branches/branch-0.13/metastore/scripts/upgrade/derby/hive-schema-0.13.0.derby.sql
(original)
+++
hive/branches/branch-0.13/metastore/scripts/upgrade/derby/hive-schema-0.13.0.derby.sql
Mon Mar 17 23:37:38 2014
@@ -314,8 +314,6 @@ ALTER TABLE "APP"."IDXS" ADD CONSTRAINT
ALTER TABLE "APP"."SDS" ADD CONSTRAINT "SQL110318025505550" CHECK
(IS_COMPRESSED IN ('Y','N'));
-INSERT INTO "APP"."VERSION" (VER_ID, SCHEMA_VERSION, VERSION_COMMENT) VALUES
(1, '0.13.0', 'Hive release version 0.13.0');
-
--
-----------------------------------------------------------------------------------------------------------------------------------------------
-- Transaction and Lock Tables
-- These are not part of package jdo, so if you are going to regenerate this
file you need to manually add the following section back to the file.
@@ -390,4 +388,8 @@ CREATE TABLE NEXT_COMPACTION_QUEUE_ID (
INSERT INTO NEXT_COMPACTION_QUEUE_ID VALUES(1);
+-- -----------------------------------------------------------------
+-- Record schema version. Should be the last step in the init script
+-- -----------------------------------------------------------------
+INSERT INTO "APP"."VERSION" (VER_ID, SCHEMA_VERSION, VERSION_COMMENT) VALUES
(1, '0.13.0', 'Hive release version 0.13.0');
Modified:
hive/branches/branch-0.13/metastore/scripts/upgrade/mysql/hive-schema-0.13.0.mysql.sql
URL:
http://svn.apache.org/viewvc/hive/branches/branch-0.13/metastore/scripts/upgrade/mysql/hive-schema-0.13.0.mysql.sql?rev=1578664&r1=1578663&r2=1578664&view=diff
==============================================================================
---
hive/branches/branch-0.13/metastore/scripts/upgrade/mysql/hive-schema-0.13.0.mysql.sql
(original)
+++
hive/branches/branch-0.13/metastore/scripts/upgrade/mysql/hive-schema-0.13.0.mysql.sql
Mon Mar 17 23:37:38 2014
@@ -794,8 +794,6 @@ CREATE TABLE IF NOT EXISTS `FUNC_RU` (
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
-INSERT INTO VERSION (VER_ID, SCHEMA_VERSION, VERSION_COMMENT) VALUES (1,
'0.13.0', 'Hive release version 0.13.0');
-
--
-----------------------------------------------------------------------------------------------------------------------------------------------
-- Transaction and Lock Tables
-- These are not part of package jdo, so if you are going to regenerate this
file you need to manually add the following section back to the file.
@@ -872,6 +870,11 @@ CREATE TABLE NEXT_COMPACTION_QUEUE_ID (
INSERT INTO NEXT_COMPACTION_QUEUE_ID VALUES(1);
+-- -----------------------------------------------------------------
+-- Record schema version. Should be the last step in the init script
+-- -----------------------------------------------------------------
+INSERT INTO VERSION (VER_ID, SCHEMA_VERSION, VERSION_COMMENT) VALUES (1,
'0.13.0', 'Hive release version 0.13.0');
+
/*!40101 SET character_set_client = @saved_cs_client */;
/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;
Modified:
hive/branches/branch-0.13/metastore/scripts/upgrade/oracle/hive-schema-0.13.0.oracle.sql
URL:
http://svn.apache.org/viewvc/hive/branches/branch-0.13/metastore/scripts/upgrade/oracle/hive-schema-0.13.0.oracle.sql?rev=1578664&r1=1578663&r2=1578664&view=diff
==============================================================================
---
hive/branches/branch-0.13/metastore/scripts/upgrade/oracle/hive-schema-0.13.0.oracle.sql
(original)
+++
hive/branches/branch-0.13/metastore/scripts/upgrade/oracle/hive-schema-0.13.0.oracle.sql
Mon Mar 17 23:37:38 2014
@@ -754,8 +754,6 @@ ALTER TABLE FUNC_RU ADD CONSTRAINT FUNC_
CREATE INDEX FUNC_RU_N49 ON FUNC_RU (FUNC_ID);
-INSERT INTO VERSION (VER_ID, SCHEMA_VERSION, VERSION_COMMENT) VALUES (1,
'0.13.0', 'Hive release version 0.13.0');
-
--
-----------------------------------------------------------------------------------------------------------------------------------------------
-- Transaction and Lock Tables
-- These are not part of package jdo, so if you are going to regenerate this
file you need to manually add the following section back to the file.
@@ -830,3 +828,8 @@ CREATE TABLE NEXT_COMPACTION_QUEUE_ID (
INSERT INTO NEXT_COMPACTION_QUEUE_ID VALUES(1);
+-- -----------------------------------------------------------------
+-- Record schema version. Should be the last step in the init script
+-- -----------------------------------------------------------------
+INSERT INTO VERSION (VER_ID, SCHEMA_VERSION, VERSION_COMMENT) VALUES (1,
'0.13.0', 'Hive release version 0.13.0');
+
Modified:
hive/branches/branch-0.13/metastore/scripts/upgrade/postgres/hive-schema-0.13.0.postgres.sql
URL:
http://svn.apache.org/viewvc/hive/branches/branch-0.13/metastore/scripts/upgrade/postgres/hive-schema-0.13.0.postgres.sql?rev=1578664&r1=1578663&r2=1578664&view=diff
==============================================================================
---
hive/branches/branch-0.13/metastore/scripts/upgrade/postgres/hive-schema-0.13.0.postgres.sql
(original)
+++
hive/branches/branch-0.13/metastore/scripts/upgrade/postgres/hive-schema-0.13.0.postgres.sql
Mon Mar 17 23:37:38 2014
@@ -1453,7 +1453,6 @@ 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');
--
-- PostgreSQL database dump complete
--
@@ -1532,4 +1531,8 @@ CREATE TABLE NEXT_COMPACTION_QUEUE_ID (
INSERT INTO NEXT_COMPACTION_QUEUE_ID VALUES(1);
+-- -----------------------------------------------------------------
+-- Record schema version. Should be the last step in the init script
+-- -----------------------------------------------------------------
+INSERT INTO "VERSION" ("VER_ID", "SCHEMA_VERSION", "VERSION_COMMENT") VALUES
(1, '0.13.0', 'Hive release version 0.13.0');
