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

Support updating an Iceberg table's partition scheme #12174

Closed
alexjo2144 opened this issue Apr 28, 2022 · 1 comment · Fixed by #12259
Closed

Support updating an Iceberg table's partition scheme #12174

alexjo2144 opened this issue Apr 28, 2022 · 1 comment · Fixed by #12259
Assignees
Labels
enhancement New feature or request
Milestone

Comments

@alexjo2144
Copy link
Member

alexjo2144 commented Apr 28, 2022

Iceberg supports adding and removing partition columns after a table has been created, we should have ALTER TABLE statements that perform these operations.

#1324

Syntax-wise, the way it looks in Spark is ALTER TABLE ... ADD/DROP PARTITION FIELD ....
We could do ALTER TABLE ... SET PROPERTIES partition = ARRAY[<partition>], the main usability problem I see is that you would have to re-specify any partitions you don't want removed when updating the list.
Alternatively, we could also have an ALTER TABLE ... EXECUTE <add/drop>_partition procedure

@findepi
Copy link
Member

findepi commented May 10, 2022

This will be implemented as

ALTER TABLE table_name SET PROPERTIES partitioning = ARRAY[...];

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
enhancement New feature or request
Development

Successfully merging a pull request may close this issue.

3 participants