[ https://issues.apache.org/jira/browse/FLINK-29820?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17702211#comment-17702211 ]
Jingsong Lee commented on FLINK-29820: -------------------------------------- We have already supported this. > Support to read data from table store with specify snapshot id > -------------------------------------------------------------- > > Key: FLINK-29820 > URL: https://issues.apache.org/jira/browse/FLINK-29820 > Project: Flink > Issue Type: New Feature > Components: Table Store > Affects Versions: table-store-0.3.0, table-store-0.2.2 > Reporter: Fang Yong > Priority: Major > > Currently our queries can only read the latest snapshot from table store. We > need to support reading the data of the specified snapshot, in this way, we > can read historical versions or compare data across versions as needed. In > [#FLINK-29735] we have supported to query snapshots with `SELECT * FROM > MyTable$snapshots`, we can query data from table `wordcount` with `snapshot > 10` as follows: > `SELECT * FROM wordcount$snapshot$10 WHERE count>10` -- This message was sent by Atlassian Jira (v8.20.10#820010)