- 3026 Views
- 2 replies
- 1 kudos
Resolved! Error deleting a table
I'm trying to delete a table that was created from a csv and due to the file deletion, I can't execute the deletion, with the following error: I'm new to Databricks and I don't know how to fix this. Some help?
- 3026 Views
- 2 replies
- 1 kudos
- 1 kudos
To delete the table, it's looking for underlying delta log file and because the file doesn't exist, it's throwing you that error.Just drop the table.drop table <table_name>
- 1 kudos
- 1508 Views
- 1 replies
- 0 kudos
If I delete a table through the UI, does it also delete the underlying files?
I am using the UI in the workspace. I can use the Data tab to see my tables, then use the delete option through the UI. But I know there are underlying files that contain the tables data. Are these files also being deleted?
- 1508 Views
- 1 replies
- 0 kudos
- 0 kudos
If the table is external the files are not deleted. For managed table, the underlying files get deleted. Essentially a "DROP TABLE" command is submitted under the hood.
- 0 kudos