You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@hive.apache.org by we...@apache.org on 2016/12/06 18:55:54 UTC
hive git commit: HIVE-15362 : Add the missing fields for 2.2.0
upgrade scripts (Wei Zheng, reviewed by Eugene Koifman)
Repository: hive
Updated Branches:
refs/heads/master f9141094e -> 0c8edf053
HIVE-15362 : Add the missing fields for 2.2.0 upgrade scripts (Wei Zheng, reviewed by Eugene Koifman)
Project: http://git-wip-us.apache.org/repos/asf/hive/repo
Commit: http://git-wip-us.apache.org/repos/asf/hive/commit/0c8edf05
Tree: http://git-wip-us.apache.org/repos/asf/hive/tree/0c8edf05
Diff: http://git-wip-us.apache.org/repos/asf/hive/diff/0c8edf05
Branch: refs/heads/master
Commit: 0c8edf0537f61f876dfae330d0d90eb7c57dfce6
Parents: f914109
Author: Wei Zheng <we...@apache.org>
Authored: Tue Dec 6 10:55:42 2016 -0800
Committer: Wei Zheng <we...@apache.org>
Committed: Tue Dec 6 10:55:42 2016 -0800
----------------------------------------------------------------------
metastore/scripts/upgrade/derby/hive-txn-schema-2.2.0.derby.sql | 2 ++
metastore/scripts/upgrade/mssql/hive-schema-2.2.0.mssql.sql | 2 ++
metastore/scripts/upgrade/mysql/hive-txn-schema-2.2.0.mysql.sql | 2 ++
metastore/scripts/upgrade/oracle/hive-txn-schema-2.2.0.oracle.sql | 2 ++
.../scripts/upgrade/postgres/hive-txn-schema-2.2.0.postgres.sql | 2 ++
5 files changed, 10 insertions(+)
----------------------------------------------------------------------
http://git-wip-us.apache.org/repos/asf/hive/blob/0c8edf05/metastore/scripts/upgrade/derby/hive-txn-schema-2.2.0.derby.sql
----------------------------------------------------------------------
diff --git a/metastore/scripts/upgrade/derby/hive-txn-schema-2.2.0.derby.sql b/metastore/scripts/upgrade/derby/hive-txn-schema-2.2.0.derby.sql
index 11d86ca..b31ea6e 100644
--- a/metastore/scripts/upgrade/derby/hive-txn-schema-2.2.0.derby.sql
+++ b/metastore/scripts/upgrade/derby/hive-txn-schema-2.2.0.derby.sql
@@ -82,6 +82,7 @@ CREATE TABLE COMPACTION_QUEUE (
CQ_PARTITION varchar(767),
CQ_STATE char(1) NOT NULL,
CQ_TYPE char(1) NOT NULL,
+ CQ_TBLPROPERTIES varchar(2048),
CQ_WORKER_ID varchar(128),
CQ_START bigint,
CQ_RUN_AS varchar(128),
@@ -102,6 +103,7 @@ CREATE TABLE COMPLETED_COMPACTIONS (
CC_PARTITION varchar(767),
CC_STATE char(1) NOT NULL,
CC_TYPE char(1) NOT NULL,
+ CC_TBLPROPERTIES varchar(2048),
CC_WORKER_ID varchar(128),
CC_START bigint,
CC_END bigint,
http://git-wip-us.apache.org/repos/asf/hive/blob/0c8edf05/metastore/scripts/upgrade/mssql/hive-schema-2.2.0.mssql.sql
----------------------------------------------------------------------
diff --git a/metastore/scripts/upgrade/mssql/hive-schema-2.2.0.mssql.sql b/metastore/scripts/upgrade/mssql/hive-schema-2.2.0.mssql.sql
index 8735b50..fdb4004 100644
--- a/metastore/scripts/upgrade/mssql/hive-schema-2.2.0.mssql.sql
+++ b/metastore/scripts/upgrade/mssql/hive-schema-2.2.0.mssql.sql
@@ -863,6 +863,7 @@ CREATE TABLE COMPACTION_QUEUE(
CQ_PARTITION nvarchar(767) NULL,
CQ_STATE char(1) NOT NULL,
CQ_TYPE char(1) NOT NULL,
+ CQ_TBLPROPERTIES nvarchar(2048) NULL,
CQ_WORKER_ID nvarchar(128) NULL,
CQ_START bigint NULL,
CQ_RUN_AS nvarchar(128) NULL,
@@ -882,6 +883,7 @@ CREATE TABLE COMPLETED_COMPACTIONS (
CC_PARTITION nvarchar(767) NULL,
CC_STATE char(1) NOT NULL,
CC_TYPE char(1) NOT NULL,
+ CC_TBLPROPERTIES nvarchar(2048) NULL,
CC_WORKER_ID nvarchar(128) NULL,
CC_START bigint NULL,
CC_END bigint NULL,
http://git-wip-us.apache.org/repos/asf/hive/blob/0c8edf05/metastore/scripts/upgrade/mysql/hive-txn-schema-2.2.0.mysql.sql
----------------------------------------------------------------------
diff --git a/metastore/scripts/upgrade/mysql/hive-txn-schema-2.2.0.mysql.sql b/metastore/scripts/upgrade/mysql/hive-txn-schema-2.2.0.mysql.sql
index 369d6bb..58835cb 100644
--- a/metastore/scripts/upgrade/mysql/hive-txn-schema-2.2.0.mysql.sql
+++ b/metastore/scripts/upgrade/mysql/hive-txn-schema-2.2.0.mysql.sql
@@ -85,6 +85,7 @@ CREATE TABLE COMPACTION_QUEUE (
CQ_PARTITION varchar(767),
CQ_STATE char(1) NOT NULL,
CQ_TYPE char(1) NOT NULL,
+ CQ_TBLPROPERTIES varchar(2048),
CQ_WORKER_ID varchar(128),
CQ_START bigint,
CQ_RUN_AS varchar(128),
@@ -100,6 +101,7 @@ CREATE TABLE COMPLETED_COMPACTIONS (
CC_PARTITION varchar(767),
CC_STATE char(1) NOT NULL,
CC_TYPE char(1) NOT NULL,
+ CC_TBLPROPERTIES varchar(2048),
CC_WORKER_ID varchar(128),
CC_START bigint,
CC_END bigint,
http://git-wip-us.apache.org/repos/asf/hive/blob/0c8edf05/metastore/scripts/upgrade/oracle/hive-txn-schema-2.2.0.oracle.sql
----------------------------------------------------------------------
diff --git a/metastore/scripts/upgrade/oracle/hive-txn-schema-2.2.0.oracle.sql b/metastore/scripts/upgrade/oracle/hive-txn-schema-2.2.0.oracle.sql
index d39baab..57d3abd 100644
--- a/metastore/scripts/upgrade/oracle/hive-txn-schema-2.2.0.oracle.sql
+++ b/metastore/scripts/upgrade/oracle/hive-txn-schema-2.2.0.oracle.sql
@@ -83,6 +83,7 @@ CREATE TABLE COMPACTION_QUEUE (
CQ_PARTITION varchar(767),
CQ_STATE char(1) NOT NULL,
CQ_TYPE char(1) NOT NULL,
+ CQ_TBLPROPERTIES varchar(2048),
CQ_WORKER_ID varchar(128),
CQ_START NUMBER(19),
CQ_RUN_AS varchar(128),
@@ -103,6 +104,7 @@ CREATE TABLE COMPLETED_COMPACTIONS (
CC_PARTITION varchar(767),
CC_STATE char(1) NOT NULL,
CC_TYPE char(1) NOT NULL,
+ CC_TBLPROPERTIES varchar(2048),
CC_WORKER_ID varchar(128),
CC_START NUMBER(19),
CC_END NUMBER(19),
http://git-wip-us.apache.org/repos/asf/hive/blob/0c8edf05/metastore/scripts/upgrade/postgres/hive-txn-schema-2.2.0.postgres.sql
----------------------------------------------------------------------
diff --git a/metastore/scripts/upgrade/postgres/hive-txn-schema-2.2.0.postgres.sql b/metastore/scripts/upgrade/postgres/hive-txn-schema-2.2.0.postgres.sql
index 262b93e..63ce2ee 100644
--- a/metastore/scripts/upgrade/postgres/hive-txn-schema-2.2.0.postgres.sql
+++ b/metastore/scripts/upgrade/postgres/hive-txn-schema-2.2.0.postgres.sql
@@ -83,6 +83,7 @@ CREATE TABLE COMPACTION_QUEUE (
CQ_PARTITION varchar(767),
CQ_STATE char(1) NOT NULL,
CQ_TYPE char(1) NOT NULL,
+ CQ_TBLPROPERTIES varchar(2048),
CQ_WORKER_ID varchar(128),
CQ_START bigint,
CQ_RUN_AS varchar(128),
@@ -103,6 +104,7 @@ CREATE TABLE COMPLETED_COMPACTIONS (
CC_PARTITION varchar(767),
CC_STATE char(1) NOT NULL,
CC_TYPE char(1) NOT NULL,
+ CC_TBLPROPERTIES varchar(2048),
CC_WORKER_ID varchar(128),
CC_START bigint,
CC_END bigint,