juntaozhang commented on code in PR #7313: URL: https://github.com/apache/paimon/pull/7313#discussion_r3386488634
########## docs/docs/primary-key-table/chain-table.md: ########## @@ -191,6 +190,32 @@ you will get the following result: +---+----+-----+ ``` +- Chain Table Compaction: Merge data from snapshot and delta branches into the snapshot branch. + This is useful for periodically compacting incremental data into full snapshots. + You can use the `compact_chain_table` procedure to merge a specific partition: + +```sql +CALL sys.compact_chain_table(table => 'default.t', partition => 'date="20250811"'); +``` + +After compaction, the data in the snapshot branch will contain the merged result from both snapshot +and delta branches, and subsequent queries will benefit from direct snapshot access without +merge-on-read overhead. + +```sql +select t1, t2, t3 from `default`.`t$branch_snapshot` where date = '20250811'; +``` + +you will get the following result: +```text ++---+----+-----+ Review Comment: Done, thanks for your reminder. -- This is an automated message from the Apache Git Service. To respond to the message, please log on to GitHub and use the URL above to go to the specific comment. To unsubscribe, e-mail: [email protected] For queries about this service, please contact Infrastructure at: [email protected]
