AI / Apache Paimon Interview questions
Describe the Read-optimized (ro) system table?
The $ro system table trades a small amount of freshness for a large amount of read speed: it improves query performance by only scanning files that don't need merging at query time.
On a primary key table, that means $ro only scans files at the topmost LSM level, so it reflects the result of the latest full compaction rather than the absolute latest write — and because different buckets may complete full compaction at different times, values for different keys can technically come from different snapshots. On an append table, since all files can already be read without merging, $ro behaves just like the normal table.
The $ro system table improves read speed by:
On a primary key table, $ro reflects data as of:
More Related questions...
