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 <[email protected]> Authored: Tue Dec 6 10:55:42 2016 -0800 Committer: Wei Zheng <[email protected]> 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,
