cancel
Showing results for 
Search instead for 
Did you mean: 
Data Engineering
Join discussions on data engineering best practices, architectures, and optimization strategies within the Databricks Community. Exchange insights and solutions with fellow data engineers.
cancel
Showing results for 
Search instead for 
Did you mean: 

How can Delta table protocol version be downgraded from higher version to lower version the table properties minReader from 2 to 1 and MaxWriter from 5 to 3.

Yaswanth
New Contributor III

Is there a possibility to downgrade the Delta Table protocol versions minReader from 2 to 1 and maxWriter from 5 to 3? I have set the TBL properties to 2 and 5 and columnmapping mode to rename the columns in the DeltaTable but the other users are reading this delta table with Databricks runtime 7.3 and getting the error "com.databricks.sql.transaction.tahoe.ColumnMappingUnsupportedException:". they cannot upgrade the Databricks runtime to 10.4. i'm trying to reset the tblproperties it is not happening

Is there a possibility to revert back to version to previous version? and how? or any other solution to handle this problem?

Looking for a solution to the problem please any inputs?

1 ACCEPTED SOLUTION

Accepted Solutions

youssefmrini
Honored Contributor III

Unfortunately You can't downgrade the version. it's an irreversible operation.

View solution in original post

2 REPLIES 2

Yaswanth
New Contributor III

Hi Kaniz Fatma, Yes you are correct.. what is the solution here now.. apart from upgrading the database runtime.. Can I restore the table version to previous one? Or I need to drop the delta table and are create the new one?

youssefmrini
Honored Contributor III

Unfortunately You can't downgrade the version. it's an irreversible operation.

Connect with Databricks Users in Your Area

Join a Regional User Group to connect with local Databricks users. Events will be happening in your city, and you won’t want to miss the chance to attend and share knowledge.

If there isn’t a group near you, start one and help create a community that brings people together.

Request a New Group