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

Skesaram
New Contributor II

‎02-01-2023 05:20 AM

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"')

Labels:
0 Kudos