I have big delta table in Azure Blob Storage Container. It stores very big size data.
Now I want to add a new column to this existing delta table. For all existing data, I want to give default value 1.
Option 1, I can read whole delta table, add new column, then overwrite. But I don’t want to overwrite.
Is there other way, we can add a new column without overwrite, just give default value 1 for all existing rows?
Leave an answer