Merge Update in Notebook Faster Than Scala script

Kotekaman
New Contributor

Hi Folks,

I tested running a merge update using SQL queries in a notebook, and it is faster than using a Scala script. Both tests were done using the same cluster size in Databricks.

How can I make the Scala script as fast as the SQL notebook?

Witold
Databricks Partner

Have you already compared both query plans?