- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
02-11-2025 03:30 AM
While running the UCX tool in workspace we are not able to access the tables which are created in hive metastore on default schema. When we run the migrate-table workflow we get the error that the tables are not accessible.
We get the following error:
06:55:33 WARN [d.l.u.hive_metastore.mapping][checking_all_database_properties_1] Failed to get properties for Table hive_metastore.default.air_quality: [TABLE_OR_VIEW_NOT_FOUND] The table or view `default`.`air_quality` cannot be found. Verify the spelling and correctness of the schema and catalog. If you did not qualify the name with a schema, verify the current_schema() output, or qualify the name with the correct schema and catalog. To tolerate the error on drop use DROP VIEW IF EXISTS or DROP TABLE IF EXISTS. SQLSTATE: 42P01; line 1 pos 19;
Since the tables are not accessible so migrations also not successful.