topic Re: Need urgent help while Trying to update the below statement from spark SQL. Getting error in Data Engineering

Need urgent help while Trying to update the below statement from spark SQL. Getting error

Skesaram — Wed, 01 Feb 2023 13:20:09 GMT

spark.sql('UPDATE kct SET ABC_basevalue = kct.ABC_KBETR * ABS(T5.UKUSA) FROM cond_azure_try_delta kct

INNER JOIN VW_TCU_delta AS T5 ON kct.WRS = T5.TCU AND kct.ABC_konwa=t5.fc

INNER JOIN tcu_delta t ON(kct.WRS=t.FC) WHERE kct.marked="1"')

Re: Need urgent help while Trying to update the below statement from spark SQL. Getting error

Skesaram — Thu, 02 Feb 2023 09:29:52 GMT

getting the above error. Thanks in advance

Re: Need urgent help while Trying to update the below statement from spark SQL. Getting error

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

this issue is rised here https://community.databricks.com/s/question/0D58Y00009p09c2SAA/not-able-to-perform-update-in-delta-table-in-databricks-using-3-tables

Re: Need urgent help while Trying to update the below statement from spark SQL. Getting error

Skesaram — Tue, 07 Feb 2023 14:49:46 GMT

result_df = kunnr_azure_try.alias("kct").join(VW_T_AdjDefaultPrice.alias("t5"), (kunnr_azure_try.WAERS==VW_T_AdjDefaultPrice.TURR) & (kunnr_azure_try.ZW00_KONWA==VW_T_AdjDefaultPrice.FURR) , "inner").join(tcurr, tcurr.FCURR==kunnrmatnr_cond_azure_try.WAERS,"inner").where(tcurr.TYPE_RATE=="original").where(kunnrmatnr_cond_azure_try.marked==1).select("ZW00_kbetr","ZW00_basevalue",(tcurr.UKURS.alias("TUCURS")),"ZWF1_kbetr","ZWF1_value","ZW00_KPEIN")

result_df.display()

did a work around it worked for me...

Re: Need urgent help while Trying to update the below statement from spark SQL. Getting error

Anonymous — Sun, 09 Apr 2023 03:02:13 GMT

Hi @sreekanth kesaram

Hope everything is going great.

Just wanted to check in if you were able to resolve your issue. If yes, would you be happy to mark an answer as best so that other members can find the solution more quickly? If not, please tell us so we can help you.

Cheers!

Re: Need urgent help while Trying to update the below statement from spark SQL. Getting error

Debayan — Thu, 02 Feb 2023 06:55:33 GMT

Hi, Could you please provide the error or the screenshot?