cancel
Showing results for 
Search instead for 
Did you mean: 
Data Governance
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
Welcome to Databricks Community: Lets learn, network and celebrate together

Join our fast-growing data practitioner and expert community of 80K+ members, ready to discover, help and collaborate together while making meaningful connections. 

Click here to register and join today! 

Engage in exciting technical discussions, join a group with your peers and meet our Featured Members.