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