Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
07-27-2022 04:06 AM
you could guarantee order by actually ordering the dataframe which you want to merge or use a window function (and keeping only the most recent record f.e.).
The upsert is an expensive operation, so depending on the amount of data which has to be evaluated it can take a while indeed.
There are some tweaks possible though:
https://docs.microsoft.com/en-us/azure/databricks/kb/delta/delta-merge-into