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

Search Discussions

Related Discussions

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

1 user in discussion

Pauly: 1 post

People

Translate

site design / logo © 2021 Grokbase