Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

[Feature Request] [Kernel] Delete a partition or delete Parquet files from a table #3988

Open
2 of 8 tasks
chrisparrinello opened this issue Dec 19, 2024 · 0 comments
Open
2 of 8 tasks
Labels
enhancement New feature or request

Comments

@chrisparrinello
Copy link

Feature request

Which Delta project/connector is this regarding?

  • Spark
  • Standalone
  • Flink
  • Kernel
  • Other (fill in here)

Overview

Our pipeline generates Parquet files outside of a Delta or Spark context so we use Delta Standalone to add the Parquet files to a Delta table for a partition. If the pipeline regenerates the Parquet files for a partition, we need the ability to be able to remove the old Parquet files for that partition and add the new Parquet files to the same partition.

Motivation

This feature will add more bulk-level updates versus row-level updates currently supported by Delta Kernel

Further details

Delta Standalone support AddFile and Remove file operations on the Delta log via code such as the following:

        OptimisticTransaction txn = deltaLog.startTransaction();
        txn.commit(newFiles, new Operation(Operation.Name.UPDATE), engineInfo);

The Delta Kernel equivalent for AddFile ss creating DataFileStatus objects and then using Transaction.generateAppendActions. There doesn't seem to be an equivalent in the code for a RemoveFile operation.

In lieu of a RemoveFile operation, we could work around that by having the ability to delete a partition. We can then recreate the partition via DataFileStatus/Transaction.generateAppendActions calls.

Willingness to contribute

The Delta Lake Community encourages new feature contributions. Would you or another member of your organization be willing to contribute an implementation of this feature?

  • Yes. I can contribute this feature independently.
  • Yes. I would be willing to contribute this feature with guidance from the Delta Lake community.
  • No. I cannot contribute this feature at this time.
@chrisparrinello chrisparrinello added the enhancement New feature or request label Dec 19, 2024
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
enhancement New feature or request
Projects
None yet
Development

No branches or pull requests

1 participant