FAQ
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 $$

Search Discussions

Related Discussions

Discussion Navigation
viewthread | post
Discussion Overview
groupcommits @
categorieshive, hadoop
postedNov 9, '11 at 1:42a
activeNov 9, '11 at 1:42a
posts1
users1
websitehive.apache.org

1 user in discussion

Pauly: 1 post

People

Translate

site design / logo © 2021 Grokbase