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)