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

Connect with Databricks Users in Your Area

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