[
https://issues.apache.org/jira/browse/HIVE-22498?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Naveen Gangam updated HIVE-22498:
---------------------------------
Status: Patch Available (was: Open)
MySQL does not allow update on a table with a select on the same table. Updated
the query to use a nested subquery.
> Schema tool enhancements to merge catalogs
> ------------------------------------------
>
> Key: HIVE-22498
> URL: https://issues.apache.org/jira/browse/HIVE-22498
> Project: Hive
> Issue Type: Sub-task
> Affects Versions: 4.0.0
> Reporter: Naveen Gangam
> Assignee: Naveen Gangam
> Priority: Major
> Attachments: HIVE-22498.2.patch, HIVE-22498.patch
>
>
> Schema tool currently supports relocation of database from one catalog to
> another, one at a time. While having to do this one at a time is painful, it
> also lacks support for converting them to external tables during migration,
> in lieu of the changes to the translation layer where a MANAGED table is
> strictly ACID-only table.
> Hence we also need to convert them to external tables during relocation.
--
This message was sent by Atlassian Jira
(v8.3.4#803005)
