[
https://issues.apache.org/jira/browse/FLINK-36417?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17896462#comment-17896462
]
Sergey Nuyanzin commented on FLINK-36417:
-----------------------------------------
[~xuyangzhong]
I created 2 PRs
1.19: https://github.com/apache/flink/pull/25623
1.20: https://github.com/apache/flink/pull/25622
just cherry-picks
once ci is green we can merge them
> STATE_TTL doesn't work with WatermarkAssigner
> ---------------------------------------------
>
> Key: FLINK-36417
> URL: https://issues.apache.org/jira/browse/FLINK-36417
> Project: Flink
> Issue Type: Bug
> Components: Table SQL / Planner
> Reporter: Sergey Nuyanzin
> Assignee: Sergey Nuyanzin
> Priority: Major
> Fix For: 2.0-preview
>
>
> A query to reproduce
> {code:sql}
> SELECT /*+ STATE_TTL('st'='1d', 'vt' = '3d') */ st.* FROM SimpleTable st
> LEFT JOIN(SELECT DISTINCT b FROM VirtualTable) vt
> ON st.b = vt.b WHERE vt.b IS NOT NULL
> {code}
> It fails with not being able to find table with name {{st}}.
> The reason is that if we look into a plan there is WatermarkAssigner which
> doesn't support hints
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
