Manage table partition using Apache Gravitino
Introduction
Although many catalogs inherently manage partitions automatically, there are scenarios where manual partition management is necessary. Usage scenarios like managing the TTL (Time-To-Live) of partition data, gathering statistics on partition metadata, and optimizing queries through partition pruning. For these reasons, Apache Gravitino provides capabilities of partition management.
Requirements and limitations
- Partition management is based on the partitioned table, so please ensure that you are operating on a partitioned table.
The following table shows the partition operations supported across various catalogs in Gravitino:
Operation | Hive catalog | Iceberg catalog | Jdbc-Mysql catalog | Jdbc-PostgreSQL catalog | Jdbc-Doris catalog |
---|---|---|---|---|---|
Add Partition | ✔ | ✘ |