https://community.databricks.com/t5/data-engineering/delta-table-merge-operation-logs-output-is-not-correct-number-of/m-p/14432#M8920 <P><span class="lia-inline-image-display-wrapper" image-alt="initial delta table"><img src="https://community.databricks.com/t5/image/serverpage/image-id/1727i2F6279518F0CC8C5/image-size/large?v=v2&amp;px=999" role="button" title="initial delta table" alt="initial delta table" /></span><span class="lia-inline-image-display-wrapper" image-alt="updated_source_tables for merge"><img src="https://community.databricks.com/t5/image/serverpage/image-id/1722iDD4C61359F889E89/image-size/large?v=v2&amp;px=999" role="button" title="updated_source_tables for merge" alt="updated_source_tables for merge" /></span><span class="lia-inline-image-display-wrapper" image-alt="merger statment"><img src="https://community.databricks.com/t5/image/serverpage/image-id/1731i7931F31641A18595/image-size/large?v=v2&amp;px=999" role="button" title="merger statment" alt="merger statment" /></span>Hi all,</P><P>I am performing merge operation on my delta table in spark. I have existing delta table , it already has some records. Now I created another dataframe of csv file, and added one new record and updated one records in that. Please check below snip.</P><P>(df_source) is the updated table(temp view)</P><P>Now after performing merge operation. The logs generated here are not correct in updated records it shows 3 records updated i have updated only one record. for inserted it shows correctly i have issue with update why it is updating all the records.</P><P></P><P>Can you please help me to understand what's happening behind the scenes.</P> Wed, 06 Jul 2022 13:01:25 GMT Vaibhav_552636 2022-07-06T13:01:25Z https://community.databricks.com/t5/data-engineering/delta-table-merge-operation-logs-output-is-not-correct-number-of/m-p/14432#M8920 <P><span class="lia-inline-image-display-wrapper" image-alt="initial delta table"><img src="https://community.databricks.com/t5/image/serverpage/image-id/1727i2F6279518F0CC8C5/image-size/large?v=v2&amp;px=999" role="button" title="initial delta table" alt="initial delta table" /></span><span class="lia-inline-image-display-wrapper" image-alt="updated_source_tables for merge"><img src="https://community.databricks.com/t5/image/serverpage/image-id/1722iDD4C61359F889E89/image-size/large?v=v2&amp;px=999" role="button" title="updated_source_tables for merge" alt="updated_source_tables for merge" /></span><span class="lia-inline-image-display-wrapper" image-alt="merger statment"><img src="https://community.databricks.com/t5/image/serverpage/image-id/1731i7931F31641A18595/image-size/large?v=v2&amp;px=999" role="button" title="merger statment" alt="merger statment" /></span>Hi all,</P><P>I am performing merge operation on my delta table in spark. I have existing delta table , it already has some records. Now I created another dataframe of csv file, and added one new record and updated one records in that. Please check below snip.</P><P>(df_source) is the updated table(temp view)</P><P>Now after performing merge operation. The logs generated here are not correct in updated records it shows 3 records updated i have updated only one record. for inserted it shows correctly i have issue with update why it is updating all the records.</P><P></P><P>Can you please help me to understand what's happening behind the scenes.</P> Wed, 06 Jul 2022 13:01:25 GMT https://community.databricks.com/t5/data-engineering/delta-table-merge-operation-logs-output-is-not-correct-number-of/m-p/14432#M8920 Vaibhav_552636 2022-07-06T13:01:25Z