topic Re: Databricks Delta - UPDATE error in Data Engineering

Databricks Delta - UPDATE error

GuidoPereyra_ — Tue, 30 Oct 2018 17:35:01 GMT

Hi,

We got the following error when we tried to UPDATE a delta table running concurrent notebooks that all end with an update to the same table.

com.databricks.sql.transaction.tahoe.ConcurrentAppendException: Files were added matching 'true' by a concurrent update. Please try the operation again.

I tried to perform serveral UPDATEs manually at the same time with the same cluster and it seems to works good, but it failed with the concurrent notebooks.

Anyone knows how to fix it?

Thanks in advance

Re: Databricks Delta - UPDATE error

matt — Thu, 20 Jun 2019 21:02:13 GMT

Was there ever a resolution to this issue? I am getting the same problem now.

Re: Databricks Delta - UPDATE error

GuidoPereyra_ — Fri, 21 Jun 2019 14:10:13 GMT

Hi @matt@direction.consulting

I just found the following doc https://docs.azuredatabricks.net/delta/isolation-level.html#set-the-isolation-level.

In my case, I could fixed partitioning the table and I think is the only way for concurrent update in the same table but you can find different serialization level in the doc for the others operations.

I hope It is hopeful