AI / Apache Paimon Interview questions
How do you use the sequence.field option in Paimon?
sequence.field tells Paimon which column to trust for merge ordering instead of relying on input arrival order. By default, a primary key table merges records in the order they arrive — the last one in wins — but distributed writers can deliver records out of order.
CREATE TABLE my_table ( pk BIGINT PRIMARY KEY NOT ENFORCED, v1 DOUBLE, update_time TIMESTAMP ) WITH ( 'sequence.field' = 'update_time' );
With this set, the record with the largest update_time value always merges last, regardless of arrival order; ties fall back to arrival order. You can even list multiple fields, comma-separated, which are compared in order.
Without sequence.field set, Paimon determines merge order for a primary key table by:
With sequence.field='update_time' set, the record that wins the merge is the one with:
More Related questions...
