[jira] [Commented] (FLINK-29820) Support to read data from table store with specify snapshot id

["Jingsong Lee (Jira)" <ji...@apache.org>]

    [ 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)