You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@hive.apache.org by ng...@apache.org on 2017/04/13 15:28:50 UTC
hive git commit: HIVE-16316 Add-on fix to change the upgrade path
from 2.2-->2.3 to 2.2-->2.3-->3.0
Repository: hive
Updated Branches:
refs/heads/master 3f681c227 -> a70042803
HIVE-16316 Add-on fix to change the upgrade path from 2.2-->2.3 to 2.2-->2.3-->3.0
Project: http://git-wip-us.apache.org/repos/asf/hive/repo
Commit: http://git-wip-us.apache.org/repos/asf/hive/commit/a7004280
Tree: http://git-wip-us.apache.org/repos/asf/hive/tree/a7004280
Diff: http://git-wip-us.apache.org/repos/asf/hive/diff/a7004280
Branch: refs/heads/master
Commit: a7004280301645ad4a5d750ba6f16b748e3fce2d
Parents: 3f681c2
Author: Naveen Gangam <ng...@apache.org>
Authored: Thu Apr 13 11:28:27 2017 -0400
Committer: Naveen Gangam <ng...@apache.org>
Committed: Thu Apr 13 11:28:27 2017 -0400
----------------------------------------------------------------------
.../scripts/upgrade/derby/upgrade-2.2.0-to-3.0.0.derby.sql | 3 ---
.../scripts/upgrade/derby/upgrade-2.3.0-to-3.0.0.derby.sql | 3 +++
metastore/scripts/upgrade/derby/upgrade.order.derby | 3 ++-
.../scripts/upgrade/mssql/upgrade-2.2.0-to-3.0.0.mssql.sql | 4 ----
.../scripts/upgrade/mssql/upgrade-2.3.0-to-3.0.0.mssql.sql | 4 ++++
metastore/scripts/upgrade/mssql/upgrade.order.mssql | 3 ++-
.../scripts/upgrade/mysql/upgrade-2.2.0-to-3.0.0.mysql.sql | 5 -----
.../scripts/upgrade/mysql/upgrade-2.3.0-to-3.0.0.mysql.sql | 5 +++++
metastore/scripts/upgrade/mysql/upgrade.order.mysql | 3 ++-
.../scripts/upgrade/oracle/upgrade-2.2.0-to-3.0.0.oracle.sql | 4 ----
.../scripts/upgrade/oracle/upgrade-2.3.0-to-3.0.0.oracle.sql | 4 ++++
metastore/scripts/upgrade/oracle/upgrade.order.oracle | 3 ++-
.../upgrade/postgres/upgrade-2.2.0-to-3.0.0.postgres.sql | 5 -----
.../upgrade/postgres/upgrade-2.3.0-to-3.0.0.postgres.sql | 5 +++++
metastore/scripts/upgrade/postgres/upgrade.order.postgres | 3 ++-
15 files changed, 31 insertions(+), 26 deletions(-)
----------------------------------------------------------------------
http://git-wip-us.apache.org/repos/asf/hive/blob/a7004280/metastore/scripts/upgrade/derby/upgrade-2.2.0-to-3.0.0.derby.sql
----------------------------------------------------------------------
diff --git a/metastore/scripts/upgrade/derby/upgrade-2.2.0-to-3.0.0.derby.sql b/metastore/scripts/upgrade/derby/upgrade-2.2.0-to-3.0.0.derby.sql
deleted file mode 100644
index 7a3fc76..0000000
--- a/metastore/scripts/upgrade/derby/upgrade-2.2.0-to-3.0.0.derby.sql
+++ /dev/null
@@ -1,3 +0,0 @@
--- Upgrade MetaStore schema from 2.2.0 to 3.0.0
-
-UPDATE "APP".VERSION SET SCHEMA_VERSION='3.0.0', VERSION_COMMENT='Hive release version 3.0.0' where VER_ID=1;
http://git-wip-us.apache.org/repos/asf/hive/blob/a7004280/metastore/scripts/upgrade/derby/upgrade-2.3.0-to-3.0.0.derby.sql
----------------------------------------------------------------------
diff --git a/metastore/scripts/upgrade/derby/upgrade-2.3.0-to-3.0.0.derby.sql b/metastore/scripts/upgrade/derby/upgrade-2.3.0-to-3.0.0.derby.sql
new file mode 100644
index 0000000..3bba523
--- /dev/null
+++ b/metastore/scripts/upgrade/derby/upgrade-2.3.0-to-3.0.0.derby.sql
@@ -0,0 +1,3 @@
+-- Upgrade MetaStore schema from 2.3.0 to 3.0.0
+
+UPDATE "APP".VERSION SET SCHEMA_VERSION='3.0.0', VERSION_COMMENT='Hive release version 3.0.0' where VER_ID=1;
http://git-wip-us.apache.org/repos/asf/hive/blob/a7004280/metastore/scripts/upgrade/derby/upgrade.order.derby
----------------------------------------------------------------------
diff --git a/metastore/scripts/upgrade/derby/upgrade.order.derby b/metastore/scripts/upgrade/derby/upgrade.order.derby
index 8a54163..d7091b5 100644
--- a/metastore/scripts/upgrade/derby/upgrade.order.derby
+++ b/metastore/scripts/upgrade/derby/upgrade.order.derby
@@ -12,4 +12,5 @@
1.2.0-to-2.0.0
2.0.0-to-2.1.0
2.1.0-to-2.2.0
-2.2.0-to-3.0.0
+2.2.0-to-2.3.0
+2.3.0-to-3.0.0
http://git-wip-us.apache.org/repos/asf/hive/blob/a7004280/metastore/scripts/upgrade/mssql/upgrade-2.2.0-to-3.0.0.mssql.sql
----------------------------------------------------------------------
diff --git a/metastore/scripts/upgrade/mssql/upgrade-2.2.0-to-3.0.0.mssql.sql b/metastore/scripts/upgrade/mssql/upgrade-2.2.0-to-3.0.0.mssql.sql
deleted file mode 100644
index 16883be..0000000
--- a/metastore/scripts/upgrade/mssql/upgrade-2.2.0-to-3.0.0.mssql.sql
+++ /dev/null
@@ -1,4 +0,0 @@
-SELECT 'Upgrading MetaStore schema from 2.2.0 to 3.0.0' AS MESSAGE;
-
-UPDATE VERSION SET SCHEMA_VERSION='3.0.0', VERSION_COMMENT='Hive release version 3.0.0' where VER_ID=1;
-SELECT 'Finished upgrading MetaStore schema from 2.2.0 to 3.0.0' AS MESSAGE;
http://git-wip-us.apache.org/repos/asf/hive/blob/a7004280/metastore/scripts/upgrade/mssql/upgrade-2.3.0-to-3.0.0.mssql.sql
----------------------------------------------------------------------
diff --git a/metastore/scripts/upgrade/mssql/upgrade-2.3.0-to-3.0.0.mssql.sql b/metastore/scripts/upgrade/mssql/upgrade-2.3.0-to-3.0.0.mssql.sql
new file mode 100644
index 0000000..94d18a3
--- /dev/null
+++ b/metastore/scripts/upgrade/mssql/upgrade-2.3.0-to-3.0.0.mssql.sql
@@ -0,0 +1,4 @@
+SELECT 'Upgrading MetaStore schema from 2.3.0 to 3.0.0' AS MESSAGE;
+
+UPDATE VERSION SET SCHEMA_VERSION='3.0.0', VERSION_COMMENT='Hive release version 3.0.0' where VER_ID=1;
+SELECT 'Finished upgrading MetaStore schema from 2.3.0 to 3.0.0' AS MESSAGE;
http://git-wip-us.apache.org/repos/asf/hive/blob/a7004280/metastore/scripts/upgrade/mssql/upgrade.order.mssql
----------------------------------------------------------------------
diff --git a/metastore/scripts/upgrade/mssql/upgrade.order.mssql b/metastore/scripts/upgrade/mssql/upgrade.order.mssql
index 3dda488..8623683 100644
--- a/metastore/scripts/upgrade/mssql/upgrade.order.mssql
+++ b/metastore/scripts/upgrade/mssql/upgrade.order.mssql
@@ -6,4 +6,5 @@
1.2.0-to-2.0.0
2.0.0-to-2.1.0
2.1.0-to-2.2.0
-2.2.0-to-3.0.0
+2.2.0-to-2.3.0
+2.3.0-to-3.0.0
http://git-wip-us.apache.org/repos/asf/hive/blob/a7004280/metastore/scripts/upgrade/mysql/upgrade-2.2.0-to-3.0.0.mysql.sql
----------------------------------------------------------------------
diff --git a/metastore/scripts/upgrade/mysql/upgrade-2.2.0-to-3.0.0.mysql.sql b/metastore/scripts/upgrade/mysql/upgrade-2.2.0-to-3.0.0.mysql.sql
deleted file mode 100644
index 2227363..0000000
--- a/metastore/scripts/upgrade/mysql/upgrade-2.2.0-to-3.0.0.mysql.sql
+++ /dev/null
@@ -1,5 +0,0 @@
-SELECT 'Upgrading MetaStore schema from 2.2.0 to 3.0.0' AS ' ';
-
-UPDATE VERSION SET SCHEMA_VERSION='3.0.0', VERSION_COMMENT='Hive release version 3.0.0' where VER_ID=1;
-SELECT 'Finished upgrading MetaStore schema from 2.2.0 to 3.0.0' AS ' ';
-
http://git-wip-us.apache.org/repos/asf/hive/blob/a7004280/metastore/scripts/upgrade/mysql/upgrade-2.3.0-to-3.0.0.mysql.sql
----------------------------------------------------------------------
diff --git a/metastore/scripts/upgrade/mysql/upgrade-2.3.0-to-3.0.0.mysql.sql b/metastore/scripts/upgrade/mysql/upgrade-2.3.0-to-3.0.0.mysql.sql
new file mode 100644
index 0000000..e5d82e1
--- /dev/null
+++ b/metastore/scripts/upgrade/mysql/upgrade-2.3.0-to-3.0.0.mysql.sql
@@ -0,0 +1,5 @@
+SELECT 'Upgrading MetaStore schema from 2.3.0 to 3.0.0' AS ' ';
+
+UPDATE VERSION SET SCHEMA_VERSION='3.0.0', VERSION_COMMENT='Hive release version 3.0.0' where VER_ID=1;
+SELECT 'Finished upgrading MetaStore schema from 2.3.0 to 3.0.0' AS ' ';
+
http://git-wip-us.apache.org/repos/asf/hive/blob/a7004280/metastore/scripts/upgrade/mysql/upgrade.order.mysql
----------------------------------------------------------------------
diff --git a/metastore/scripts/upgrade/mysql/upgrade.order.mysql b/metastore/scripts/upgrade/mysql/upgrade.order.mysql
index 8a54163..d7091b5 100644
--- a/metastore/scripts/upgrade/mysql/upgrade.order.mysql
+++ b/metastore/scripts/upgrade/mysql/upgrade.order.mysql
@@ -12,4 +12,5 @@
1.2.0-to-2.0.0
2.0.0-to-2.1.0
2.1.0-to-2.2.0
-2.2.0-to-3.0.0
+2.2.0-to-2.3.0
+2.3.0-to-3.0.0
http://git-wip-us.apache.org/repos/asf/hive/blob/a7004280/metastore/scripts/upgrade/oracle/upgrade-2.2.0-to-3.0.0.oracle.sql
----------------------------------------------------------------------
diff --git a/metastore/scripts/upgrade/oracle/upgrade-2.2.0-to-3.0.0.oracle.sql b/metastore/scripts/upgrade/oracle/upgrade-2.2.0-to-3.0.0.oracle.sql
deleted file mode 100644
index b41152c..0000000
--- a/metastore/scripts/upgrade/oracle/upgrade-2.2.0-to-3.0.0.oracle.sql
+++ /dev/null
@@ -1,4 +0,0 @@
-SELECT 'Upgrading MetaStore schema from 2.2.0 to 3.0.0' AS Status from dual;
-
-UPDATE VERSION SET SCHEMA_VERSION='3.0.0', VERSION_COMMENT='Hive release version 3.0.0' where VER_ID=1;
-SELECT 'Finished upgrading MetaStore schema from 2.2.0 to 3.0.0' AS Status from dual;
http://git-wip-us.apache.org/repos/asf/hive/blob/a7004280/metastore/scripts/upgrade/oracle/upgrade-2.3.0-to-3.0.0.oracle.sql
----------------------------------------------------------------------
diff --git a/metastore/scripts/upgrade/oracle/upgrade-2.3.0-to-3.0.0.oracle.sql b/metastore/scripts/upgrade/oracle/upgrade-2.3.0-to-3.0.0.oracle.sql
new file mode 100644
index 0000000..31c4f5d
--- /dev/null
+++ b/metastore/scripts/upgrade/oracle/upgrade-2.3.0-to-3.0.0.oracle.sql
@@ -0,0 +1,4 @@
+SELECT 'Upgrading MetaStore schema from 2.3.0 to 3.0.0' AS Status from dual;
+
+UPDATE VERSION SET SCHEMA_VERSION='3.0.0', VERSION_COMMENT='Hive release version 3.0.0' where VER_ID=1;
+SELECT 'Finished upgrading MetaStore schema from 2.3.0 to 3.0.0' AS Status from dual;
http://git-wip-us.apache.org/repos/asf/hive/blob/a7004280/metastore/scripts/upgrade/oracle/upgrade.order.oracle
----------------------------------------------------------------------
diff --git a/metastore/scripts/upgrade/oracle/upgrade.order.oracle b/metastore/scripts/upgrade/oracle/upgrade.order.oracle
index 73fbc53..a18b062 100644
--- a/metastore/scripts/upgrade/oracle/upgrade.order.oracle
+++ b/metastore/scripts/upgrade/oracle/upgrade.order.oracle
@@ -8,4 +8,5 @@
1.2.0-to-2.0.0
2.0.0-to-2.1.0
2.1.0-to-2.2.0
-2.2.0-to-3.0.0
+2.2.0-to-2.3.0
+2.3.0-to-3.0.0
http://git-wip-us.apache.org/repos/asf/hive/blob/a7004280/metastore/scripts/upgrade/postgres/upgrade-2.2.0-to-3.0.0.postgres.sql
----------------------------------------------------------------------
diff --git a/metastore/scripts/upgrade/postgres/upgrade-2.2.0-to-3.0.0.postgres.sql b/metastore/scripts/upgrade/postgres/upgrade-2.2.0-to-3.0.0.postgres.sql
deleted file mode 100644
index cb34c2e..0000000
--- a/metastore/scripts/upgrade/postgres/upgrade-2.2.0-to-3.0.0.postgres.sql
+++ /dev/null
@@ -1,5 +0,0 @@
-SELECT 'Upgrading MetaStore schema from 2.2.0 to 3.0.0';
-
-UPDATE "VERSION" SET "SCHEMA_VERSION"='3.0.0', "VERSION_COMMENT"='Hive release version 3.0.0' where "VER_ID"=1;
-SELECT 'Finished upgrading MetaStore schema from 2.2.0 to 3.0.0';
-
http://git-wip-us.apache.org/repos/asf/hive/blob/a7004280/metastore/scripts/upgrade/postgres/upgrade-2.3.0-to-3.0.0.postgres.sql
----------------------------------------------------------------------
diff --git a/metastore/scripts/upgrade/postgres/upgrade-2.3.0-to-3.0.0.postgres.sql b/metastore/scripts/upgrade/postgres/upgrade-2.3.0-to-3.0.0.postgres.sql
new file mode 100644
index 0000000..2dd9bb9
--- /dev/null
+++ b/metastore/scripts/upgrade/postgres/upgrade-2.3.0-to-3.0.0.postgres.sql
@@ -0,0 +1,5 @@
+SELECT 'Upgrading MetaStore schema from 2.3.0 to 3.0.0';
+
+UPDATE "VERSION" SET "SCHEMA_VERSION"='3.0.0', "VERSION_COMMENT"='Hive release version 3.0.0' where "VER_ID"=1;
+SELECT 'Finished upgrading MetaStore schema from 2.3.0 to 3.0.0';
+
http://git-wip-us.apache.org/repos/asf/hive/blob/a7004280/metastore/scripts/upgrade/postgres/upgrade.order.postgres
----------------------------------------------------------------------
diff --git a/metastore/scripts/upgrade/postgres/upgrade.order.postgres b/metastore/scripts/upgrade/postgres/upgrade.order.postgres
index 8a54163..d7091b5 100644
--- a/metastore/scripts/upgrade/postgres/upgrade.order.postgres
+++ b/metastore/scripts/upgrade/postgres/upgrade.order.postgres
@@ -12,4 +12,5 @@
1.2.0-to-2.0.0
2.0.0-to-2.1.0
2.1.0-to-2.2.0
-2.2.0-to-3.0.0
+2.2.0-to-2.3.0
+2.3.0-to-3.0.0