Repository: hive Updated Branches: refs/heads/master dc4dfce96 -> c9d1b0e1e
HIVE-17614: Notification_sequence initialization using SQL statement which is compatible with Mysql 5.1 (Anishek Agarwal 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/c9d1b0e1 Tree: http://git-wip-us.apache.org/repos/asf/hive/tree/c9d1b0e1 Diff: http://git-wip-us.apache.org/repos/asf/hive/diff/c9d1b0e1 Branch: refs/heads/master Commit: c9d1b0e1e26e425114f617160f4fb41b95faf8e1 Parents: dc4dfce Author: Anishek Agarwal <anis...@gmail.com> Authored: Wed Oct 4 14:36:40 2017 +0530 Committer: Anishek Agarwal <anis...@gmail.com> Committed: Wed Oct 4 14:36:40 2017 +0530 ---------------------------------------------------------------------- metastore/scripts/upgrade/mysql/045-HIVE-16886.mysql.sql | 2 +- metastore/scripts/upgrade/mysql/hive-schema-3.0.0.mysql.sql | 2 +- 2 files changed, 2 insertions(+), 2 deletions(-) ---------------------------------------------------------------------- http://git-wip-us.apache.org/repos/asf/hive/blob/c9d1b0e1/metastore/scripts/upgrade/mysql/045-HIVE-16886.mysql.sql ---------------------------------------------------------------------- diff --git a/metastore/scripts/upgrade/mysql/045-HIVE-16886.mysql.sql b/metastore/scripts/upgrade/mysql/045-HIVE-16886.mysql.sql index d4d798d..8aaf7c3 100644 --- a/metastore/scripts/upgrade/mysql/045-HIVE-16886.mysql.sql +++ b/metastore/scripts/upgrade/mysql/045-HIVE-16886.mysql.sql @@ -1 +1 @@ -INSERT INTO `NOTIFICATION_SEQUENCE` (`NNI_ID`, `NEXT_EVENT_ID`) SELECT 1,1 WHERE NOT EXISTS ( SELECT `NEXT_EVENT_ID` FROM `NOTIFICATION_SEQUENCE`); \ No newline at end of file +INSERT INTO `NOTIFICATION_SEQUENCE` (`NNI_ID`, `NEXT_EVENT_ID`) SELECT * from (select 1 as `NNI_ID`, 1 as `NOTIFICATION_SEQUENCE`) a WHERE (SELECT COUNT(*) FROM `NOTIFICATION_SEQUENCE`) = 0; \ No newline at end of file http://git-wip-us.apache.org/repos/asf/hive/blob/c9d1b0e1/metastore/scripts/upgrade/mysql/hive-schema-3.0.0.mysql.sql ---------------------------------------------------------------------- diff --git a/metastore/scripts/upgrade/mysql/hive-schema-3.0.0.mysql.sql b/metastore/scripts/upgrade/mysql/hive-schema-3.0.0.mysql.sql index 6091801..f3baa44 100644 --- a/metastore/scripts/upgrade/mysql/hive-schema-3.0.0.mysql.sql +++ b/metastore/scripts/upgrade/mysql/hive-schema-3.0.0.mysql.sql @@ -812,7 +812,7 @@ CREATE TABLE IF NOT EXISTS `NOTIFICATION_SEQUENCE` PRIMARY KEY (`NNI_ID`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1; -INSERT INTO `NOTIFICATION_SEQUENCE` (`NNI_ID`, `NEXT_EVENT_ID`) SELECT 1,1 WHERE NOT EXISTS ( SELECT `NEXT_EVENT_ID` FROM `NOTIFICATION_SEQUENCE`); +INSERT INTO `NOTIFICATION_SEQUENCE` (`NNI_ID`, `NEXT_EVENT_ID`) SELECT * from (select 1 as `NNI_ID`, 1 as `NOTIFICATION_SEQUENCE`) a WHERE (SELECT COUNT(*) FROM `NOTIFICATION_SEQUENCE`) = 0; CREATE TABLE IF NOT EXISTS `KEY_CONSTRAINTS` (