https://community.databricks.com/t5/get-started-discussions/unable-to-change-cast-column-datatype-using-delta-io/m-p/43749#M937 <P>I have created a delta table using Delta IO library, with following details</P><P>Table Name: Employee</P><P>Columns {Id Integer, name String, gender String, Salary decimal(5,2)}</P><P>Now I want to upcast the salary from decimal(5,2) to decimal(10,4). If I use delta IO library I am endup with&nbsp;"<SPAN>Detected incompatible schema change" error. Is there way to change upcast columns, change datatype using Delta IO.</SPAN></P> Wed, 06 Sep 2023 05:34:49 GMT Srikanthn 2023-09-06T05:34:49Z https://community.databricks.com/t5/get-started-discussions/unable-to-change-cast-column-datatype-using-delta-io/m-p/43749#M937 <P>I have created a delta table using Delta IO library, with following details</P><P>Table Name: Employee</P><P>Columns {Id Integer, name String, gender String, Salary decimal(5,2)}</P><P>Now I want to upcast the salary from decimal(5,2) to decimal(10,4). If I use delta IO library I am endup with&nbsp;"<SPAN>Detected incompatible schema change" error. Is there way to change upcast columns, change datatype using Delta IO.</SPAN></P> Wed, 06 Sep 2023 05:34:49 GMT https://community.databricks.com/t5/get-started-discussions/unable-to-change-cast-column-datatype-using-delta-io/m-p/43749#M937 Srikanthn 2023-09-06T05:34:49Z