hive-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Alexander Alten-Lorenz" <alexan...@cloudera.com>
Subject Review Request: Disable FK checks on COLUMNS in 008-HIVE-2246.mysql.sql
Date Mon, 03 Sep 2012 07:18:35 GMT

-----------------------------------------------------------
This is an automatically generated e-mail. To reply, visit:
https://reviews.apache.org/r/6894/
-----------------------------------------------------------

Review request for hive.


Description
-------

By upgrading a MySQL metastore sometimes the schema get's into a foreign key issue:
+----------------------------------------+ 
| Inserted table columns into COLUMNS_V2 | 
+----------------------------------------+ 
| Inserted table columns into COLUMNS_V2 | 
+----------------------------------------+ 
+--------------------------+ 
| Completed migrating idxs | 
+--------------------------+ 
| Completed migrating idxs | 
+--------------------------+ 
ERROR 1025 (HY000) at line 250 in file: '008-HIVE-2246.mysql.sql': Error on rename of './metastore/COLUMNS_OLD'
to './metastore/#sql2-14e6-6eb' (errno: 152)

These patch disables FK checks before the table will be copied, and enable them after.


This addresses bug HIVE-3424.
    https://issues.apache.org/jira/browse/HIVE-3424


Diffs
-----

  metastore/scripts/upgrade/mysql/008-HIVE-2246.mysql.sql 3ac8d2e 

Diff: https://reviews.apache.org/r/6894/diff/


Testing
-------


Thanks,

Alexander Alten-Lorenz


Mime
  • Unnamed multipart/alternative (inline, None, 0 bytes)
View raw message