topic Re: Not able to perform update in delta table in databricks using 3 tables in Data Engineering

Not able to perform update in delta table in databricks using 3 tables

Upendra_Kumar — Thu, 02 Feb 2023 09:47:21 GMT

Hi,

I am able to perform merge from 2 tables but have requirement to update table based on 3 tables like following query.

update a

set a.name=b.name

from table1 a

inner join table2 b on a.id=b.id

inner join table3 c on a.id=c.id

Thanks in advance..

Re: Not able to perform update in delta table in databricks using 3 tables

Cami — Thu, 02 Feb 2023 21:06:06 GMT

it can be a workaround ( it just crossed my mind) but you can try to join those tables in a data frame and after that select columns for A table with new value for a.name column. Save data frame and as a temporary table and make merge with A table.

Re: Not able to perform update in delta table in databricks using 3 tables

Anonymous — Thu, 09 Feb 2023 06:45:15 GMT

Hi @upendra kumar sharma

Hope all is well! Just wanted to check in if you were able to resolve your issue and would you be happy to share the solution or mark an answer as best? Else please let us know if you need more help.

We'd love to hear from you.

Thanks!

Re: Not able to perform update in delta table in databricks using 3 tables

Anonymous — Sun, 09 Apr 2023 06:16:33 GMT

Hi @upendra kumar sharma

Help us build a vibrant and resourceful community by recognizing and highlighting insightful contributions. Mark the best answers and show your appreciation!

Thanks and Regards