cancel
Showing results for 
Search instead for 
Did you mean: 
Data Governance
Join discussions on data governance practices, compliance, and security within the Databricks Community. Exchange strategies and insights to ensure data integrity and regulatory compliance.
cancel
Showing results for 
Search instead for 
Did you mean: 

unity catalog Request failed with status code 404

lizou
Contributor II

maybe this is a bug in the unity catalog as the error happens multiple times when a table becomes inaccessible

error: Request failed with status code 404

try to drop the table error: NoSuchTableException: [TABLE_OR_VIEW_NOT_FOUND] 

try to replace the table error: TableAlreadyExistsException: [TABLE_OR_VIEW_ALREADY_EXISTS]

the table info still exists in system.information_schema.columns

basically stuck at this state

image

3 REPLIES 3

Anonymous
Not applicable

@lizou​ What do you mean by "table becomes inaccessible"? Were the underlying table data files deleted by any chance?

lizou
Contributor II

no file deleting. just this error appears, and no way to drop or recreate the table. I also don't know what's GUID of the table is. What else we can do to drop a table without using the drop table statement?

lizou
Contributor II

the error disappeared now after a few months.

It could be

  1. happens when there is a lot of schema change on db during the initial project stage.
  2. there may be some temp security issues
  3. may be databricks fixed in the back end
  4. appears less issue when schema rarely changes after the project get stable and schema is set
Join 100K+ Data Experts: Register Now & Grow with Us!

Excited to expand your horizons with us? Click here to Register and begin your journey to success!

Already a member? Login and join your local regional user group! If there isn’t one near you, fill out this form and we’ll create one for you to join!