unity catalog Request failed with status code 404

[lizou]

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

[Anonymous]

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

[lizou]

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]

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