cancel
Showing results for 
Search instead for 
Did you mean: 
Data Engineering
cancel
Showing results for 
Search instead for 
Did you mean: 

SQL Merge Statement not working

Raghu_Bindingan
New Contributor III

Hi I am trying to use the SQL Merge statement on databricks

MERGE INTO target

USING source

ON source.key = target.key

WHEN MATCHED

UPDATE SET *

WHEN NOT MATCHED

INSERT *

WHEN NOT MATCHED BY SOURCE

DELETE

This is failing with the error [PARSE_SYNTAX_ERROR] Syntax error at or near 'UPDATE'.(line 18, pos 2). I am running my notebook on a cluster that is running Databricks 12.2

Any help is appreciated.

1 ACCEPTED SOLUTION

Accepted Solutions

Raghu_Bindingan
New Contributor III

I was missing the THEN before UPDATE, INSERT and DELETE. This keyword is missing from the documentation on Databricks https://learn.microsoft.com/en-us/azure/databricks/delta/merge

It now works. Thanks

View solution in original post

2 REPLIES 2

UmaMahesh1
Honored Contributor III

Are you using the wildcard for the Update and insert ?

#DAIS2023

Raghu_Bindingan
New Contributor III

I was missing the THEN before UPDATE, INSERT and DELETE. This keyword is missing from the documentation on Databricks https://learn.microsoft.com/en-us/azure/databricks/delta/merge

It now works. Thanks

Welcome to Databricks Community: Lets learn, network and celebrate together

Join our fast-growing data practitioner and expert community of 80K+ members, ready to discover, help and collaborate together while making meaningful connections. 

Click here to register and join today! 

Engage in exciting technical discussions, join a group with your peers and meet our Featured Members.