需要緊急幫助,而嚐試更新以下聲明引發的SQL。得到錯誤

[Skesaram]

火花。sql(“更新kct集ABC_basevalue = kct。ABC_KBETR * ABS (T5.UKUSA) cond_azure_try_delta kct

內連接VW_TCU_delta kct T5。采用= T5。TCU kct.ABC_konwa = t5.fc

內連接tcu_delta t (kct.WRS = t.FC)上kct.marked =“1”)

[Debayan]

你好,你能提供錯誤或截圖嗎?

[Skesaram]

上述錯誤。謝謝提前

[卡米]

這個問題是其三https://community.www.eheci.com/s/question/0D58Y00009p09c2SAA/not-able-to-perform-update-in-delta-t..。

[Skesaram]

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),“內部”)。加入(tcurr tcurr.FCURR = = kunnrmatnr_cond_azure_try.WAERS,“內部”)。(tcurr.TYPE_RATE = =“原始”)。(kunnrmatnr_cond_azure_try.marked = = 1) .select (“ZW00_kbetr”、“ZW00_basevalue”(tcurr.UKURS.alias (“TUCURS”),“ZWF1_kbetr”,“ZWF1_value”,“ZW00_KPEIN”)

result_df.display ()

做了一個解決它為我工作…