topic Re: 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. in Data Engineering

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 — Sun, 13 Nov 2022 23:34:14 GMT

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?

Re: 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 — Mon, 14 Nov 2022 14:29:21 GMT

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?

Re: 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.

youssefmrini — Tue, 15 Nov 2022 14:24:54 GMT

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