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

Posted to issues@flink.apache.org by "liwei li (Jira)" <ji...@apache.org> on 2022/11/26 02:26:00 UTC

[jira] [Commented] (FLINK-29828) Support to read data from table with given snapshot id

    [ https://issues.apache.org/jira/browse/FLINK-29828?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17638796#comment-17638796 ] 

liwei li commented on FLINK-29828:
----------------------------------

hi, [~zjureel] , Why not we use SQL Hints?  IMO, it seems more user friendly and the syntax is more standardized.

> Support to read data from table with given snapshot id
> ------------------------------------------------------
>
>                 Key: FLINK-29828
>                 URL: https://issues.apache.org/jira/browse/FLINK-29828
>             Project: Flink
>          Issue Type: Sub-task
>          Components: Table Store
>    Affects Versions: table-store-0.3.0, table-store-0.2.2
>            Reporter: Shammon
>            Priority: Major
>
> Support reading data from table with given snapshot id from table, users can query table data as follows:
> `SELECT t1.word, t1.cnt, t2.cnt FROM word_count$snapshot$10 t1 JOIN word_count$snapshot$11 t2 ON t1.word = t2.word and t1.cnt != t2.cnt`



--
This message was sent by Atlassian Jira
(v8.20.10#820010)