Spark Dataframe write to Delta format doesn't create a _delta_log

Ovi — Fri, 19 May 2023 15:51:12 GMT

Hello everyone,

I have an intermittent issue when trying to create a Delta table for the first time in Databricks: all the data gets converted into parquet at the specified location but the

_delta_log is not created or, if created, it's left empty, thus the resulted data folder isn't considered to be a Delta table.

The command it's a basic one:

sourceDf.write

.format("delta")

.mode(SaveMode.ErrorIfExists)

.partitionBy("date")

.option("mergeSchema", "true")

.save(deltaLocation)

Thank you,

Ovi

Re: Spark Dataframe write to Delta format doesn't create a _delta_log

jose_gonzalez — Tue, 06 Jun 2023 18:48:38 GMT

Can you list (display) the folder location "deltaLocation"? what files do you see here? have you try to use a new location for testing? do you get the same behavior?

topic Re: Spark Dataframe write to Delta format doesn't create a _delta_log in Data Engineering

Spark Dataframe write to Delta format doesn't create a _delta_log

Re: Spark Dataframe write to Delta format doesn't create a _delta_log