Author: namit
Date: Fri Nov 11 23:12:22 2011
New Revision: 1201091
URL: http://svn.apache.org/viewvc?rev=1201091&view=rev
Log:
HIVE-2568 HIVE-2246 upgrade script needs to drop foreign key in COLUMNS_OLD
(Ning Zhang via namit)
Modified:
hive/trunk/metastore/scripts/upgrade/mysql/008-HIVE-2246.mysql.sql
Modified: hive/trunk/metastore/scripts/upgrade/mysql/008-HIVE-2246.mysql.sql
URL:
http://svn.apache.org/viewvc/hive/trunk/metastore/scripts/upgrade/mysql/008-HIVE-2246.mysql.sql?rev=1201091&r1=1201090&r2=1201091&view=diff
==============================================================================
--- hive/trunk/metastore/scripts/upgrade/mysql/008-HIVE-2246.mysql.sql
(original)
+++ hive/trunk/metastore/scripts/upgrade/mysql/008-HIVE-2246.mysql.sql Fri Nov
11 23:12:22 2011
@@ -26,6 +26,9 @@ CREATE PROCEDURE REVERT()
DROP TABLE IF EXISTS COLUMNS_V2;
DROP TABLE IF EXISTS TABLE_SDS;
DROP TABLE IF EXISTS CDS;
+ ALTER TABLE COLUMNS_OLD
+ ADD CONSTRAINT `COLUMNS_FK1` FOREIGN KEY (`SD_ID`) REFERENCES
`SDS`(`SD_ID`)
+ ;
RENAME TABLE COLUMNS_OLD TO COLUMNS;
END $$
@@ -211,6 +214,8 @@ CREATE PROCEDURE CREATE_TABLE_SDS()
CREATE PROCEDURE RENAME_OLD_COLUMNS()
BEGIN
RENAME TABLE `COLUMNS` TO `COLUMNS_OLD`;
+ ALTER TABLE COLUMNS_OLD
+ DROP FOREIGN KEY `COLUMNS_FK1`;
END $$
/*
