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"
Join our fast-growing data practitioner and expert community of 80K+ members, ready to discover, help and collaborate together while making meaningful connections.
Click here to register and join today!
Engage in exciting technical discussions, join a group with your peers and meet our Featured Members.