How to add partition to an existing table

Apache Iceberg
1

Hi,

I’m experimenting with performance of large tables (>500M rows) and as I go through different use cases I oftentimes wish to change the partitioning of a table. I know that i can create reflection, but there should be some basic structure of the table distribution too.

can this be done, please?

thanks
Jaro

2

@jaroslav_marko Is this Parquet or Iceberg? If Parquet, changing partition is tricky as queries also needs to change, have you tried the partition transform feature in Iceberg?

Have you gone through the blog @AlexMerced has written on this?

3

Hi @balaji.ramaswamy sorry for late reply. Yes this is on Iceberg tables, thanks for information.
Jaro