You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@flink.apache.org by "Yubin Li (Jira)" <ji...@apache.org> on 2024/02/21 07:27:00 UTC
[jira] [Commented] (FLINK-34351) Release Testing: Verify FLINK-33397 Support Configuring Different State TTLs using SQL Hint
[ https://issues.apache.org/jira/browse/FLINK-34351?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17819104#comment-17819104 ]
Yubin Li commented on FLINK-34351:
----------------------------------
[~qingyue] I found some typos in the original test scripts, stage 4 should be as follows:
{code:java}
CREATE TABLE source_t (
a INT,
b BIGINT,
c STRING
) WITH (
'connector' = 'datagen',
'rows-per-second' = '5'
);
CREATE TABLE sink_t (
b BIGINT PRIMARY KEY NOT ENFORCED,
cnt BIGINT,
avg_a DOUBLE,
min_c STRING
) WITH (
'connector' = 'print'
);
COMPILE PLAN '/path/to/agg-plan.json' FOR
INSERT INTO sink_t SELECT /*+ STATE_TTL('source_t' = '1s') */
b,
COUNT(*) AS cnt,
AVG(a) FILTER (WHERE a > 1) AS avg_a,
MIN(c) AS min_c
FROM source_t GROUP BY b;{code}
After careful tests, the practical feature takes effect actually.
!image-2024-02-21-15-24-43-212.png|width=294,height=197!
!image-2024-02-21-15-24-22-289.png|width=418,height=127!
> Release Testing: Verify FLINK-33397 Support Configuring Different State TTLs using SQL Hint
> -------------------------------------------------------------------------------------------
>
> Key: FLINK-34351
> URL: https://issues.apache.org/jira/browse/FLINK-34351
> Project: Flink
> Issue Type: Sub-task
> Components: Table SQL / API
> Affects Versions: 1.19.0
> Reporter: Jane Chan
> Assignee: Yubin Li
> Priority: Blocker
> Labels: release-testing
> Fix For: 1.19.0
>
> Attachments: image-2024-02-21-15-24-22-289.png, image-2024-02-21-15-24-43-212.png
>
>
--
This message was sent by Atlassian Jira
(v8.20.10#820010)