https://community.databricks.com/t5/data-engineering/delta-table-partitioning/m-p/97293#M39468 <P>Created a streaming job with delta table as a target.&nbsp; The table did not have a partition when created earlier, however i would like to add an existing column as a partition column.</P><P>I am getting the following error.</P><LI-CODE lang="python">com.databricks.sql.transaction.tahoe.DeltaAnalysisException: [_LEGACY_ERROR_TEMP_DELTA_0007] Partition columns do not match the partition columns of the table.</LI-CODE><P>Is re-writing the entire table with the partition column the only way forward ?</P> Fri, 01 Nov 2024 20:44:00 GMT Anand4 2024-11-01T20:44:00Z https://community.databricks.com/t5/data-engineering/delta-table-partitioning/m-p/97293#M39468 <P>Created a streaming job with delta table as a target.&nbsp; The table did not have a partition when created earlier, however i would like to add an existing column as a partition column.</P><P>I am getting the following error.</P><LI-CODE lang="python">com.databricks.sql.transaction.tahoe.DeltaAnalysisException: [_LEGACY_ERROR_TEMP_DELTA_0007] Partition columns do not match the partition columns of the table.</LI-CODE><P>Is re-writing the entire table with the partition column the only way forward ?</P> Fri, 01 Nov 2024 20:44:00 GMT https://community.databricks.com/t5/data-engineering/delta-table-partitioning/m-p/97293#M39468 Anand4 2024-11-01T20:44:00Z https://community.databricks.com/t5/data-engineering/delta-table-partitioning/m-p/97305#M39470 <P>Hi <a href="https://community.databricks.com/t5/user/viewprofilepage/user-id/124360">@Anand4</a>,<BR />Delta Lake does not support altering the partitioning of an existing table directly. Therefore, the way forward is to rewrite the entire table with the new partition column</P> Fri, 01 Nov 2024 22:26:12 GMT https://community.databricks.com/t5/data-engineering/delta-table-partitioning/m-p/97305#M39470 Alberto_Umana 2024-11-01T22:26:12Z