You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@hive.apache.org by pa...@apache.org on 2011/11/09 02:42:34 UTC
svn commit: r1199593 -
/hive/trunk/metastore/scripts/upgrade/mysql/008-HIVE-2246.mysql.sql
Author: pauly
Date: Wed Nov 9 01:42:34 2011
New Revision: 1199593
URL: http://svn.apache.org/viewvc?rev=1199593&view=rev
Log:
HIVE-2556. upgrade script 008-HIVE-2246.mysql.sql contains syntax errors. (Ning Zhang via pauly)
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=1199593&r1=1199592&r2=1199593&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 Wed Nov 9 01:42:34 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 $$