09-17-2024 11:13 PM - edited 09-17-2024 11:15 PM
Hey folks!
I am facing an issue while migration the tables from Hive to UC using UCX tool; after completely running the setup and getting the assessment overview, we ran the following commands i.e. "databricks labs ucx create-table-mapping" but after we ran the command "databricks labs ucx migrate-tables", it should be supposed to migrate the tables those which are in my dbfs and already in the parquet format. As after successfully running the command, I am not getting any error but the database that has been created in the UC, the following tables are not reflecting there in the UC. I also ran the SYNC command for the external tables too, but the issue is same in that case also
I would also like to know that in the assessment overview what does the UC readiness signifies?
For your reference I am attaching the screenshots, please refer to them...
Thanks,
09-21-2024 08:55 PM
After running this command databricks labs ucx create-table-mapping, you should see a text file with a list of tables. I hope you updated the respective Catalog names before running the migrate-tables command.
90% of the total objects can be readily migrated to UC.
09-22-2024 09:07 PM
@gchandra Yes we have updated the respective Catalog names accordingly but unfortunately the tables are not reflecting there in the UC Catalog
Can you also send me the proper steps, In case We are missing any of them.
09-24-2024 01:21 AM
@gchandra for your reference,
09-24-2024 12:40 AM - edited 09-24-2024 12:41 AM
Hi @priyansh ,
If your workflow run successfull without any error, you can check the logs why to find why your table is not migrated from hive metastore to UC
In above img you can see a log folder where you can see all your workflow logs,
and one query is can you able to create table in your catalog?? if not that will be an issue
09-24-2024 01:19 AM
Hii @BasheerAhmed ,
data bricks labs UCX create-catalogs-schemas
After running the above command, we were able to create the catalog and schemas,
But unfortunately, after running this command data bricks labs UCX migrate-tables, Tables are not reflecting in UC and on verifying the log files the error we found was 429 too many requests.
"Changes have been made in the commands to post "
09-24-2024 04:53 AM
Join a Regional User Group to connect with local Databricks users. Events will be happening in your city, and you won’t want to miss the chance to attend and share knowledge.
If there isn’t a group near you, start one and help create a community that brings people together.
Request a New Group