Bug - Cannot create table The associated location is not empty and also not a Delta table.
Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
07-10-2023 11:00 AM
I am getting the error:
Cannot create table ('`hive_metastore`.`MY_SCHEMA`.`MY_TABLE`'). The associated location ('dbfs:/user/hive/warehouse/my_schema.db/my_table') is not empty and also not a Delta table.
When running
drop table 'hive_metastore`.`MY_SCHEMA`.`MY_TABLE`
Getting
[TABLE_OR_VIEW_NOT_FOUND] The table or view `hive_metastore`.`MY_SCHEMA`.`MY_TABLE` cannot be found. Verify the spelling and correctness of the schema and catalog.
Getting
[TABLE_OR_VIEW_NOT_FOUND] The table or view `hive_metastore`.`MY_SCHEMA`.`MY_TABLE` cannot be found. Verify the spelling and correctness of the schema and catalog.
How Can I over that can error? I also tried "create of replace table" but still getting the original error
location is not empty
location is not empty
