AI / Apache Paimon Interview questions
What is an Append Table in Paimon?
An append table is any Paimon table created without a primary key. It cannot receive changelogs or be upserted directly — it can only accept incoming append data, much like a plain Hive partitioned table.
CREATE TABLE my_table ( product_id BIGINT, price DOUBLE, sales BIGINT ) WITH ( -- 'target-file-size' = '256 MB', -- 'file.format' = 'parquet' );
Compared to a plain Hive table, though, it adds several data-lake conveniences: object storage (S3/OSS) friendliness, time travel and rollback, low-cost delete/update support, automatic small-file merging on streaming sinks, streaming read/write like a queue, and fast, index-backed queries.
More Related questions...