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:30:00 UTC

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

     [ https://issues.apache.org/jira/browse/FLINK-29820?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Shammon updated FLINK-29820:
----------------------------
    Description: 
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 on table `wordcount` with `snapshot 10` as follows:

`SELECT * FROM wordcount$snapshot$10 WHERE count>10`

  was:
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`


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