ucx icon indicating copy to clipboard operation
ucx copied to clipboard

[BUG]: Migrate tables errors out when migrating managed table with mount external storage

Open HariGS-DB opened this issue 1 year ago • 1 comments

Is there an existing issue for this?

  • [X] I have searched the existing issues

Current Behavior

When running a migrate table job for a table which is managed with a mount path pointing to an external storage location, the code fails with the error Description: [UPGRADE_NOT_SUPPORTED.NOT_EXTERNAL] Table is not eligible for an upgrade from Hive Metastore to Unity Catalog. Reason: Not an external table. SQLSTATE: 0AKUC

Expected Behavior

Since the table is with mount path, it should not go through the SYNC route but instead tables in mount logic to re-create the table in UC pointing to the absolute location of the mount

Steps To Reproduce

No response

Cloud

AWS

Operating System

macOS

Version

latest via Databricks CLI

Relevant log output

No response

HariGS-DB avatar Oct 04 '24 15:10 HariGS-DB

related to https://github.com/databrickslabs/ucx/issues/2838

HariGS-DB avatar Oct 04 '24 15:10 HariGS-DB