How can I repair a delta table where files were deleted manu

Question

How can I repair a delta table where files were deleted manually

Tom van Bussel · Answer

In Spark you can run ```FSCK REPAIR TABLE table name DRY RUN ```

Tom van Bussel · Answer

This command will remove all references to files that no longer exist from the Delta Log Adding DRY RUN will tell you which files it determined to be missing but won t fix anything

Georg Heiler · Answer

but this works only with a table If I do not have a metastore only the delta files in S3

Georg Heiler · Answer

how can I apply this instead

Tom van Bussel · Answer

It will still work You can refer to non metastore tables as ```delta `uri path to table````

Tom van Bussel · Answer

So ```FSCK REPAIR TABLE delta `uri path to table````

Tom van Bussel · Answer

This works for all Delta SQL command e g MERGE

Georg Heiler · Answer

ah cool