<?xml version="1.0" encoding="UTF-8"?>
<rss xmlns:content="http://purl.org/rss/1.0/modules/content/" xmlns:dc="http://purl.org/dc/elements/1.1/" xmlns:rdf="http://www.w3.org/1999/02/22-rdf-syntax-ns#" xmlns:taxo="http://purl.org/rss/1.0/modules/taxonomy/" version="2.0">
  <channel>
    <title>topic Concurrent issue on delta lake insert update in Data Engineering</title>
    <link>https://community.databricks.com/t5/data-engineering/concurrent-issue-on-delta-lake-insert-update/m-p/102157#M40994</link>
    <description>&lt;P&gt;Hey team! I need your help on delta lake let me explain the scenario of mine.&lt;/P&gt;&lt;P&gt;Scenario: ive a table in delta lake and ive 2 databricks workflows running parallely which has insert and update tasks to do.&lt;BR /&gt;My delta table is partitioned with country code&lt;/P&gt;&lt;P&gt;My code for insert is&lt;BR /&gt;Df.write.mode(“append”).saveAsTable(table_name)&lt;/P&gt;&lt;P&gt;For update using merge&lt;/P&gt;&lt;P&gt;deltaTable.as("t").merge(&lt;BR /&gt;Df.as("s"),&lt;BR /&gt;"s.user_id = t.user_id")&lt;BR /&gt;.whenMatched().update(“t.col”:”s.col”….)&lt;/P&gt;&lt;P&gt;Im getting concurrent error when my job running parallely.&lt;/P&gt;&lt;P&gt;#databricks #deltalake&amp;nbsp;&lt;/P&gt;</description>
    <pubDate>Sun, 15 Dec 2024 15:10:33 GMT</pubDate>
    <dc:creator>Dhanushn</dc:creator>
    <dc:date>2024-12-15T15:10:33Z</dc:date>
    <item>
      <title>Concurrent issue on delta lake insert update</title>
      <link>https://community.databricks.com/t5/data-engineering/concurrent-issue-on-delta-lake-insert-update/m-p/102157#M40994</link>
      <description>&lt;P&gt;Hey team! I need your help on delta lake let me explain the scenario of mine.&lt;/P&gt;&lt;P&gt;Scenario: ive a table in delta lake and ive 2 databricks workflows running parallely which has insert and update tasks to do.&lt;BR /&gt;My delta table is partitioned with country code&lt;/P&gt;&lt;P&gt;My code for insert is&lt;BR /&gt;Df.write.mode(“append”).saveAsTable(table_name)&lt;/P&gt;&lt;P&gt;For update using merge&lt;/P&gt;&lt;P&gt;deltaTable.as("t").merge(&lt;BR /&gt;Df.as("s"),&lt;BR /&gt;"s.user_id = t.user_id")&lt;BR /&gt;.whenMatched().update(“t.col”:”s.col”….)&lt;/P&gt;&lt;P&gt;Im getting concurrent error when my job running parallely.&lt;/P&gt;&lt;P&gt;#databricks #deltalake&amp;nbsp;&lt;/P&gt;</description>
      <pubDate>Sun, 15 Dec 2024 15:10:33 GMT</pubDate>
      <guid>https://community.databricks.com/t5/data-engineering/concurrent-issue-on-delta-lake-insert-update/m-p/102157#M40994</guid>
      <dc:creator>Dhanushn</dc:creator>
      <dc:date>2024-12-15T15:10:33Z</dc:date>
    </item>
    <item>
      <title>Re: Concurrent issue on delta lake insert update</title>
      <link>https://community.databricks.com/t5/data-engineering/concurrent-issue-on-delta-lake-insert-update/m-p/102159#M40996</link>
      <description>&lt;P&gt;Hi,&amp;nbsp;&lt;a href="https://community.databricks.com/t5/user/viewprofilepage/user-id/136473"&gt;@Dhanushn&lt;/a&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;In response to your question, the community contains the following information:&lt;/P&gt;&lt;P&gt;&lt;A href="https://community.databricks.com/t5/community-platform-discussions/concurrent-update-to-delta-throws-error/td-p/65599" target="_blank"&gt;https://community.databricks.com/t5/community-platform-discussions/concurrent-update-to-delta-throws-error/td-p/65599&lt;/A&gt;&lt;/P&gt;&lt;P&gt;&lt;A href="https://kb.databricks.com/en_US/delta/insert-operation-fails-while-trying-to-execute-multiple-concurrent-insert-or-merge-operations-to-append-data" target="_blank"&gt;https://kb.databricks.com/en_US/delta/insert-operation-fails-while-trying-to-execute-multiple-concurrent-insert-or-merge-operations-to-append-data&lt;/A&gt;&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;Additionally, you may have already seen it, but here’s a link to the relevant section in the official documentation.&lt;/P&gt;&lt;P&gt;&lt;A href="https://docs.databricks.com/en/optimizations/isolation-level.html#concurrentappendexception" target="_blank"&gt;https://docs.databricks.com/en/optimizations/isolation-level.html#concurrentappendexception&lt;/A&gt;&lt;/P&gt;&lt;P&gt;I hope this information is helpful to you!&lt;/P&gt;</description>
      <pubDate>Sun, 15 Dec 2024 17:24:34 GMT</pubDate>
      <guid>https://community.databricks.com/t5/data-engineering/concurrent-issue-on-delta-lake-insert-update/m-p/102159#M40996</guid>
      <dc:creator>Takuya-Omi</dc:creator>
      <dc:date>2024-12-15T17:24:34Z</dc:date>
    </item>
  </channel>
</rss>

