Author: pauly
Date: Wed Nov 9 01:46:08 2011
New Revision: 1199595
URL: http://svn.apache.org/viewvc?rev=1199595&view=rev
Log:
HIVE-2556. upgrade script 008-HIVE-2246.mysql.sql contains syntax errors. (Ning
Zhang via pauly)
- begin *PUBLIC* platform impact section -
Bugzilla: #
- end platform impact -
Modified:
hive/branches/branch-0.8/metastore/scripts/upgrade/mysql/008-HIVE-2246.mysql.sql
Modified:
hive/branches/branch-0.8/metastore/scripts/upgrade/mysql/008-HIVE-2246.mysql.sql
URL:
http://svn.apache.org/viewvc/hive/branches/branch-0.8/metastore/scripts/upgrade/mysql/008-HIVE-2246.mysql.sql?rev=1199595&r1=1199594&r2=1199595&view=diff
==============================================================================
---
hive/branches/branch-0.8/metastore/scripts/upgrade/mysql/008-HIVE-2246.mysql.sql
(original)
+++
hive/branches/branch-0.8/metastore/scripts/upgrade/mysql/008-HIVE-2246.mysql.sql
Wed Nov 9 01:46:08 2011
@@ -26,7 +26,7 @@ CREATE PROCEDURE REVERT()
DROP TABLE IF EXISTS COLUMNS_V2;
DROP TABLE IF EXISTS TABLE_SDS;
DROP TABLE IF EXISTS CDS;
- RENAME COLUMNS_OLD TO COLUMNS;
+ RENAME TABLE COLUMNS_OLD TO COLUMNS;
END $$
@@ -140,7 +140,7 @@ CREATE PROCEDURE MIGRATE_PARTITIONS()
JOIN PARTITIONS p on p.SD_ID = sd.SD_ID
JOIN TBLS t on t.TBL_ID = p.TBL_ID
SET sd.CD_ID = t.SD_ID
- where p.SD_ID is not null
+ where p.SD_ID is not null;
SELECT 'Updated CD_IDs in SDS for partitions';
END $$
