I am migrating SQL commands to Azure Databricks SQL. While running the below Update command in databricks SQL:
UPDATE three as t1 SET prod = WEB_TRFC_VISIT_SMRY.PRDCT_ID where exists ( (SELECT SVC_TAG_ID, max(supp_sys_ID) as PRDCT_ID FROM WEB_TRFC_VISIT_SMRY GROUP BY SVC_TAG_ID) WHERE t1.SVC_TAG_ID = SVC_TAG_ID)
I am getting below error: "no viable alternative at input 'exists (\n(SELECT SVC_TAG_ID, max(supp_sys_ID) as PRDCT_ID\n FROM WEB_TRFC_VISIT_SMRY\nGROUP BY SVC_TAG_ID)\nWHERE'(line 7, pos 0)"
Could someone help me find a solution for this. Everything I try is throwing an error.
