Hi Databricks Community,
I am using databricks community Edition and after I logout and login next time and try to query the tables that were created earlier , I get the below error
Error in SQL statement: AnalysisException: Table or view not found: students; line 1 pos 14;
'Project [*]
+- 'UnresolvedRelation [students], [], false
However when I check in _delta_logs , I still see files related to the tables.
%python
display(dbutils.fs.ls("./user/hive/warehouse/students/_delta_log/"))
And if I try to create the same table again , it gives the below error
%sql
CREATE TABLE students
(id INT, name STRING, value DOUBLE);
Error in SQL statement: AnalysisException: Cannot create table ('`spark_catalog`.`default`.`students`'). The associated location ('dbfs:/user/hive/warehouse/students') is not empty but it's not a Delta table
Can someone please help me understand if I am missing anything
