You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@hive.apache.org by ga...@apache.org on 2018/05/01 19:57:45 UTC
hive git commit: HIVE-19120 catalog not properly set for some tables
in SQL upgrade scripts (Alan Gates, reviewed by Thejas Nair)
Repository: hive
Updated Branches:
refs/heads/master bdbdf0d18 -> cf8592326
HIVE-19120 catalog not properly set for some tables in SQL upgrade scripts (Alan Gates, reviewed by Thejas Nair)
Project: http://git-wip-us.apache.org/repos/asf/hive/repo
Commit: http://git-wip-us.apache.org/repos/asf/hive/commit/cf859232
Tree: http://git-wip-us.apache.org/repos/asf/hive/tree/cf859232
Diff: http://git-wip-us.apache.org/repos/asf/hive/diff/cf859232
Branch: refs/heads/master
Commit: cf8592326398bdfdb3fbc8c035ef16aeeabf4fb3
Parents: bdbdf0d
Author: Alan Gates <ga...@hortonworks.com>
Authored: Tue May 1 12:57:29 2018 -0700
Committer: Alan Gates <ga...@hortonworks.com>
Committed: Tue May 1 12:57:29 2018 -0700
----------------------------------------------------------------------
.../src/main/sql/derby/upgrade-2.3.0-to-3.0.0.derby.sql | 4 ++++
.../src/main/sql/mssql/upgrade-2.3.0-to-3.0.0.mssql.sql | 4 ++++
.../src/main/sql/mysql/upgrade-2.3.0-to-3.0.0.mysql.sql | 4 ++++
.../src/main/sql/oracle/upgrade-2.3.0-to-3.0.0.oracle.sql | 4 ++++
.../src/main/sql/postgres/upgrade-2.3.0-to-3.0.0.postgres.sql | 4 ++++
5 files changed, 20 insertions(+)
----------------------------------------------------------------------
http://git-wip-us.apache.org/repos/asf/hive/blob/cf859232/standalone-metastore/src/main/sql/derby/upgrade-2.3.0-to-3.0.0.derby.sql
----------------------------------------------------------------------
diff --git a/standalone-metastore/src/main/sql/derby/upgrade-2.3.0-to-3.0.0.derby.sql b/standalone-metastore/src/main/sql/derby/upgrade-2.3.0-to-3.0.0.derby.sql
index ed6c4cd..b4c46cd 100644
--- a/standalone-metastore/src/main/sql/derby/upgrade-2.3.0-to-3.0.0.derby.sql
+++ b/standalone-metastore/src/main/sql/derby/upgrade-2.3.0-to-3.0.0.derby.sql
@@ -216,9 +216,13 @@ CREATE INDEX "APP"."PCS_STATS_IDX" ON "APP"."PART_COL_STATS" ("CAT_NAME", "DB_NA
-- Add column to partition events
ALTER TABLE "APP"."PARTITION_EVENTS" ADD COLUMN "CAT_NAME" VARCHAR(256);
+UPDATE "APP"."PARTITION_EVENTS"
+ SET "CAT_NAME" = 'hive' WHERE "DB_NAME" IS NOT NULL;
-- Add column to notification log
ALTER TABLE "APP"."NOTIFICATION_LOG" ADD COLUMN "CAT_NAME" VARCHAR(256);
+UPDATE "APP"."NOTIFICATION_LOG"
+ SET "CAT_NAME" = 'hive' WHERE "DB_NAME" IS NOT NULL;
CREATE TABLE REPL_TXN_MAP (
RTM_REPL_POLICY varchar(256) NOT NULL,
http://git-wip-us.apache.org/repos/asf/hive/blob/cf859232/standalone-metastore/src/main/sql/mssql/upgrade-2.3.0-to-3.0.0.mssql.sql
----------------------------------------------------------------------
diff --git a/standalone-metastore/src/main/sql/mssql/upgrade-2.3.0-to-3.0.0.mssql.sql b/standalone-metastore/src/main/sql/mssql/upgrade-2.3.0-to-3.0.0.mssql.sql
index c2504d3..b338f0d 100644
--- a/standalone-metastore/src/main/sql/mssql/upgrade-2.3.0-to-3.0.0.mssql.sql
+++ b/standalone-metastore/src/main/sql/mssql/upgrade-2.3.0-to-3.0.0.mssql.sql
@@ -290,9 +290,13 @@ CREATE INDEX PCS_STATS_IDX ON PART_COL_STATS (CAT_NAME, DB_NAME, TABLE_NAME, COL
-- Add columns to partition events
ALTER TABLE PARTITION_EVENTS ADD CAT_NAME nvarchar(256);
+UPDATE PARTITION_EVENTS
+ SET CAT_NAME = 'hive' WHERE DB_NAME IS NOT NULL;
-- Add columns to notification log
ALTER TABLE NOTIFICATION_LOG ADD CAT_NAME nvarchar(256);
+UPDATE NOTIFICATION_LOG
+ SET CAT_NAME = 'hive' WHERE DB_NAME IS NOT NULL;
-- HIVE-18747
CREATE TABLE MIN_HISTORY_LEVEL (
http://git-wip-us.apache.org/repos/asf/hive/blob/cf859232/standalone-metastore/src/main/sql/mysql/upgrade-2.3.0-to-3.0.0.mysql.sql
----------------------------------------------------------------------
diff --git a/standalone-metastore/src/main/sql/mysql/upgrade-2.3.0-to-3.0.0.mysql.sql b/standalone-metastore/src/main/sql/mysql/upgrade-2.3.0-to-3.0.0.mysql.sql
index e01b4da..b0d1927 100644
--- a/standalone-metastore/src/main/sql/mysql/upgrade-2.3.0-to-3.0.0.mysql.sql
+++ b/standalone-metastore/src/main/sql/mysql/upgrade-2.3.0-to-3.0.0.mysql.sql
@@ -264,9 +264,13 @@ CREATE INDEX `PCS_STATS_IDX` ON `PART_COL_STATS` (`CAT_NAME`, `DB_NAME`, `TABLE_
-- Add column to partition events
ALTER TABLE `PARTITION_EVENTS` ADD COLUMN `CAT_NAME` varchar(256);
+UPDATE `PARTITION_EVENTS`
+ SET `CAT_NAME` = 'hive' WHERE `DB_NAME` IS NOT NULL;
-- Add column to notification log
ALTER TABLE `NOTIFICATION_LOG` ADD COLUMN `CAT_NAME` varchar(256);
+UPDATE `NOTIFICATION_LOG`
+ SET `CAT_NAME` = 'hive' WHERE `DB_NAME` IS NOT NULL;
INSERT INTO `SEQUENCE_TABLE` (`SEQUENCE_NAME`, `NEXT_VAL`) SELECT * from (select 'org.apache.hadoop.hive.metastore.model.MNotificationLog' as `SEQUENCE_NAME`, 1 as `NEXT_VAL`) a WHERE (SELECT COUNT(*) FROM `SEQUENCE_TABLE` where SEQUENCE_NAME = 'org.apache.hadoop.hive.metastore.model.MNotificationLog') = 0;
http://git-wip-us.apache.org/repos/asf/hive/blob/cf859232/standalone-metastore/src/main/sql/oracle/upgrade-2.3.0-to-3.0.0.oracle.sql
----------------------------------------------------------------------
diff --git a/standalone-metastore/src/main/sql/oracle/upgrade-2.3.0-to-3.0.0.oracle.sql b/standalone-metastore/src/main/sql/oracle/upgrade-2.3.0-to-3.0.0.oracle.sql
index 327800b..0b7c793 100644
--- a/standalone-metastore/src/main/sql/oracle/upgrade-2.3.0-to-3.0.0.oracle.sql
+++ b/standalone-metastore/src/main/sql/oracle/upgrade-2.3.0-to-3.0.0.oracle.sql
@@ -275,9 +275,13 @@ CREATE INDEX PCS_STATS_IDX ON PART_COL_STATS (CAT_NAME, DB_NAME,TABLE_NAME,COLUM
-- Add column to partition events
ALTER TABLE PARTITION_EVENTS ADD CAT_NAME VARCHAR2(256);
+UPDATE PARTITION_EVENTS
+ SET CAT_NAME = 'hive' WHERE DB_NAME IS NOT NULL;
-- Add column to notification log
ALTER TABLE NOTIFICATION_LOG ADD CAT_NAME VARCHAR2(256);
+UPDATE NOTIFICATION_LOG
+ SET CAT_NAME = 'hive' WHERE DB_NAME IS NOT NULL;
CREATE TABLE REPL_TXN_MAP (
RTM_REPL_POLICY varchar(256) NOT NULL,
http://git-wip-us.apache.org/repos/asf/hive/blob/cf859232/standalone-metastore/src/main/sql/postgres/upgrade-2.3.0-to-3.0.0.postgres.sql
----------------------------------------------------------------------
diff --git a/standalone-metastore/src/main/sql/postgres/upgrade-2.3.0-to-3.0.0.postgres.sql b/standalone-metastore/src/main/sql/postgres/upgrade-2.3.0-to-3.0.0.postgres.sql
index 63932a9..f06f0dd 100644
--- a/standalone-metastore/src/main/sql/postgres/upgrade-2.3.0-to-3.0.0.postgres.sql
+++ b/standalone-metastore/src/main/sql/postgres/upgrade-2.3.0-to-3.0.0.postgres.sql
@@ -292,9 +292,13 @@ CREATE INDEX "PCS_STATS_IDX" ON "PART_COL_STATS" ("CAT_NAME", "DB_NAME", "TABLE_
-- Add column to partition event
ALTER TABLE "PARTITION_EVENTS" ADD "CAT_NAME" varchar(256);
+UPDATE "PARTITION_EVENTS"
+ SET "CAT_NAME" = 'hive' WHERE "DB_NAME" IS NOT NULL;
-- Add column to notification log
ALTER TABLE "NOTIFICATION_LOG" ADD "CAT_NAME" varchar(256);
+UPDATE "NOTIFICATION_LOG"
+ SET "CAT_NAME" = 'hive' WHERE "DB_NAME" IS NOT NULL;
CREATE TABLE REPL_TXN_MAP (
RTM_REPL_POLICY varchar(256) NOT NULL,