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