AI / Apache Paimon Interview questions
Define a primary key table in Paimon?
A primary key table is a Paimon table created with one or more columns declared as its primary key, which lets you insert, update, or delete individual records instead of only appending new rows. Primary keys consist of columns whose combined values are unique per record.
Paimon enforces ordering by sorting the primary key within each bucket, which is what lets filtering on the primary key run efficiently. When two or more incoming records share the same primary key, Paimon merges them into a single record according to the table's configured merge engine.
CREATE TABLE my_table ( user_id BIGINT, name STRING, balance DOUBLE, PRIMARY KEY (user_id) NOT ENFORCED );
Declaring a primary key on a Paimon table primarily enables:
Paimon enforces data ordering on a primary key table by:
More Related questions...
