topic Unable to execute update statement through Databricks Notebook in Data Engineering

Unable to execute update statement through Databricks Notebook

sreeyv — Thu, 30 May 2024 12:00:36 GMT

I am unable to execute update statements through Databricks Notebook, getting this error message "com.databricks.sql.transaction.tahoe.actions.InvalidProtocolVersionException: Delta protocol version is too new for this version of the Databricks Runtime. Please upgrade to a newer release."

in a notebook cell

%sql

Update table1 SET col1 = 'xxxx'

Re: Unable to execute update statement through Databricks Notebook

daniel_sahal — Fri, 31 May 2024 05:36:55 GMT

@sreeyv
Which Databricks Runtime are you using?

Re: Unable to execute update statement through Databricks Notebook

sreeyv — Sat, 01 Jun 2024 19:02:42 GMT

This is resolved, this happens when a Column in the table has a GENERATED BY DEFAULT AS IDENTITY defined. When you remove this column, it works fine