[
https://issues.apache.org/jira/browse/FLINK-36417?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17896585#comment-17896585
]
Sergey Nuyanzin commented on FLINK-36417:
-----------------------------------------
Merged to
1.19 as
[5b4914b981f5966c1987972e7b1a88d3c761c5ab|https://github.com/apache/flink/commit/5b4914b981f5966c1987972e7b1a88d3c761c5ab]
1.20 as
[b520487bd5a8a3d13343f8cfbbcbaa317d438937|https://github.com/apache/flink/commit/b520487bd5a8a3d13343f8cfbbcbaa317d438937]
> 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)
