[core] Support statistic with time travel
Purpose
Scenario:user query statistic table by snapshot-id and analyzed table multiple times. Such as user can do the analyzed at regular time and collect the statistic metric to monitor.
Currently paimon query statistic system table with snapshot_id would error out due to PaimonAnalyzeTableColumnCommand##commitStatistics not keep the real snapshot id the same with statistic snapshot_id,the pr is aimed to fix it.
before fix:
after fix:
Linked issue: close #xxx
Tests
AnalyzeTableTestBase "Paimon analyze: test statistic system table with predicate"
API and Format
Documentation
Good Job! But when I review your code, I found there is no doc for statistic system table. Could you add?
Good Job! But when I review your code, I found there is no doc for statistic system table. Could you add?
Addressed, Thanks for @wwj6591812 reivew, I would add a doc for it.
+1
traversal logic do a optimize, before: need from latest snapshot to the target analyzed snapshot, after: change from the nearest snapshot to the target analyzed snapshot. @JingsongLi
After discuss, change to query by real snapshot id. @JingsongLi