schemaTool upgrade from 0.14.0 to 1.3.0 causes failure (Hari Subramaniyan via Sushanth Sowmyan, Thejas Nair) (addendum fix)
Project: http://git-wip-us.apache.org/repos/asf/hive/repo Commit: http://git-wip-us.apache.org/repos/asf/hive/commit/0af1d6e7 Tree: http://git-wip-us.apache.org/repos/asf/hive/tree/0af1d6e7 Diff: http://git-wip-us.apache.org/repos/asf/hive/diff/0af1d6e7 Branch: refs/heads/beeline-cli Commit: 0af1d6e7d36fbd8071a35692f51d72eb86b0e9da Parents: 42f88ca Author: Sushanth Sowmyan <khorg...@gmail.com> Authored: Thu May 7 12:07:17 2015 -0700 Committer: Sushanth Sowmyan <khorg...@gmail.com> Committed: Thu May 7 12:07:17 2015 -0700 ---------------------------------------------------------------------- metastore/scripts/upgrade/mysql/hive-schema-1.2.0.mysql.sql | 2 +- metastore/scripts/upgrade/mysql/hive-schema-1.3.0.mysql.sql | 2 +- 2 files changed, 2 insertions(+), 2 deletions(-) ---------------------------------------------------------------------- http://git-wip-us.apache.org/repos/asf/hive/blob/0af1d6e7/metastore/scripts/upgrade/mysql/hive-schema-1.2.0.mysql.sql ---------------------------------------------------------------------- diff --git a/metastore/scripts/upgrade/mysql/hive-schema-1.2.0.mysql.sql b/metastore/scripts/upgrade/mysql/hive-schema-1.2.0.mysql.sql index 07dce8f..a205ac3 100644 --- a/metastore/scripts/upgrade/mysql/hive-schema-1.2.0.mysql.sql +++ b/metastore/scripts/upgrade/mysql/hive-schema-1.2.0.mysql.sql @@ -216,7 +216,7 @@ CREATE TABLE IF NOT EXISTS `PARTITIONS` ( UNIQUE KEY `UNIQUEPARTITION` (`PART_NAME`,`TBL_ID`), KEY `PARTITIONS_N49` (`TBL_ID`), KEY `PARTITIONS_N50` (`SD_ID`), - KEY `PARTITIONS_N51` (`LINK_TARGET_ID`) + KEY `PARTITIONS_N51` (`LINK_TARGET_ID`), CONSTRAINT `PARTITIONS_FK1` FOREIGN KEY (`TBL_ID`) REFERENCES `TBLS` (`TBL_ID`), CONSTRAINT `PARTITIONS_FK2` FOREIGN KEY (`SD_ID`) REFERENCES `SDS` (`SD_ID`), CONSTRAINT `PARTITIONS_FK3` FOREIGN KEY (`LINK_TARGET_ID`) REFERENCES `PARTITIONS` (`PART_ID`) http://git-wip-us.apache.org/repos/asf/hive/blob/0af1d6e7/metastore/scripts/upgrade/mysql/hive-schema-1.3.0.mysql.sql ---------------------------------------------------------------------- diff --git a/metastore/scripts/upgrade/mysql/hive-schema-1.3.0.mysql.sql b/metastore/scripts/upgrade/mysql/hive-schema-1.3.0.mysql.sql index 19ae264..bc63f0d 100644 --- a/metastore/scripts/upgrade/mysql/hive-schema-1.3.0.mysql.sql +++ b/metastore/scripts/upgrade/mysql/hive-schema-1.3.0.mysql.sql @@ -216,7 +216,7 @@ CREATE TABLE IF NOT EXISTS `PARTITIONS` ( UNIQUE KEY `UNIQUEPARTITION` (`PART_NAME`,`TBL_ID`), KEY `PARTITIONS_N49` (`TBL_ID`), KEY `PARTITIONS_N50` (`SD_ID`), - KEY `PARTITIONS_N51` (`LINK_TARGET_ID`) + KEY `PARTITIONS_N51` (`LINK_TARGET_ID`), CONSTRAINT `PARTITIONS_FK1` FOREIGN KEY (`TBL_ID`) REFERENCES `TBLS` (`TBL_ID`), CONSTRAINT `PARTITIONS_FK2` FOREIGN KEY (`SD_ID`) REFERENCES `SDS` (`SD_ID`), CONSTRAINT `PARTITIONS_FK3` FOREIGN KEY (`LINK_TARGET_ID`) REFERENCES `PARTITIONS` (`PART_ID`)
