Databricks Community

shanisolomonron

The When to replace a table documentation states that using CREATE OR REPLACE TABLE should preserve the table’s identity:Table contents are replaced, but the table identity is maintained.However, in my recent test the table ID changed after running t...

shanisolomonron

Hi,When deletion vectors are enabled on a Delta table, is there a guarantee that MERGE, UPDATE, or DELETE operations will not rewrite unmodified data, but rather use deletion vectors to soft delete the original file?For example, suppose the table cur...

shanisolomonron

@Krishna_S thanks for your reply. In a non UC-managed table, is it valid to see a table ID change throughout the life time of the table?(Also, what value gives me to utilize UC to manage my tables?)

shanisolomonron

Waiting for a databricks employee to clarify this item.

shanisolomonron

Thanks for the clarification @K_Anudeep.Sorry to circle back on this, but in your original answer you mentioned there are scenarios where a Delta table can have deletion vectors enabled yet not actually use them—for example, when the table is append-...

shanisolomonron

Thanks @K_Anudeep.Could you clarify the condition in which deletion vectors might be enabled, but I might not see the above sequence of transactions, but rather see:Remove a.parquetAdd a new file (e.g. new.parquet) containing the non-deleted + update...

Databricks Community

User Stats

User Activity

Table ID not preserved using CREATE OR REPLACE TABLE

Merge, Update and deletes using deletion vectors

Re: Table ID not preserved using CREATE OR REPLACE TABLE

Re: Table ID not preserved using CREATE OR REPLACE TABLE

Re: Merge, Update and deletes using deletion vectors

Re: Merge, Update and deletes using deletion vectors