You are viewing a plain text version of this content. The canonical link for it is here.

Posted to issues@flink.apache.org by "Shammon (Jira)" <ji...@apache.org> on 2022/11/01 00:29:00 UTC

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

Shammon created FLINK-29820:
-------------------------------

             Summary: 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: Shammon


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 query `SELECT * FROM MyTable$snapshots`, we can query on 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)