โ10-24-2022 11:41 AM
I need help or insight regarding the following errors. My instructors (Brooke Wenig with Conor Murphy) ran this code successfully on our course video, but I cannot replicate what she did.
Here is the code and below it is the outcome from my Coursera course, workspace section 4.5 notebook:
CREATE DATABASE IF NOT EXISTS Databricks;
USE Databricks;
DROP TABLE IF EXISTS fireCallsDelta;
CREATE TABLE fireCallsDelta
USING DELTA
PARTITIONED BY (City)
AS
SELECT * FROM fireCallsParquet
(3) Spark Jobs
Error in SQL statement: AnalysisException: Cannot create table ('`spark_catalog`.`databricks`.`fireCallsDelta`'). The associated location ('dbfs:/user/hive/warehouse/databricks.db/firecallsdelta') is not empty but it's not a Delta table
โ10-24-2022 09:56 PM
The `fireCallsDelta` table already exists, and it appears it was created as a PARQUET table. A couple of options:
โ10-24-2022 09:56 PM
The `fireCallsDelta` table already exists, and it appears it was created as a PARQUET table. A couple of options:
โ10-25-2022 06:53 AM
Thanks. Renaming table as you suggested allowed the query to run successfully.
โ10-25-2022 02:23 AM
Hi @Dave Frenchโ, We havenโt heard from you since the last response from @Denny Leeโ , and I was checking back to see if you have a resolution yet.
If you have any solution, please share it with the community as it can be helpful to others. Otherwise, we will respond with more details and try to help.
Also, Please don't forget to click on the "Select As Best" button whenever the information provided helps resolve your question.
โ10-25-2022 06:54 AM
Done. Thanks.
โ10-25-2022 07:13 AM
Thank you @Dave Frenchโ ! Keep Learning.
โ07-10-2023 10:44 AM
DELETE the original Parquet table as a separate statement
How can this be done? simple query "DROP TABLE .... " still failing with "cannot be found"