AI / Apache Paimon Interview questions
What is the purpose of the Audit Log system table?
The $audit_log system table exposes a table's incremental changelog with an extra rowkind column attached, so you can filter and audit exactly what kind of change each row represents.
rowkind takes one of four values: +I for insertion, -U for the previous content of an updated row, +U for the new content of an updated row, and -D for deletion.
SELECT * FROM my_table$audit_log;
It's the tool of choice when you specifically need to reason about the change history of a table — auditing, debugging a downstream discrepancy, or reconciling what actually happened between two points in time.
Querying the $audit_log system table adds which extra column?
Which rowkind value represents the previous content of an updated row?
More Related questions...
