Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

[Bug] Fail to create tag automatically with watermark #4481

Closed
1 of 2 tasks
JackeyLee007 opened this issue Nov 8, 2024 · 3 comments
Closed
1 of 2 tasks

[Bug] Fail to create tag automatically with watermark #4481

JackeyLee007 opened this issue Nov 8, 2024 · 3 comments
Labels
bug Something isn't working

Comments

@JackeyLee007
Copy link

Search before asking

  • I searched in the issues and found nothing similar.

Paimon version

0.9

Compute Engine

Flink-1.18.1
Standalone cluster.

Minimal reproduce step

-- Target paimon table with tags create automatically from watermark 
create table orders_with_watermark(
    id INT PRIMARY KEY NOT ENFORCED, 
    val int, 
    create_time TIMESTAMP(3), 
    update_time TIMESTAMP(3),
    WATERMARK FOR `update_time` AS `update_time` - INTERVAL '5' SECOND  
  ) 
  WITH (
    'tag.automatic-creation' = 'watermark',
    'tag.creation-period' = 'hourly',
    'tag.creation-delay' = '10 m',
    'tag.num-retained-max' = '90',
    'sink.watermark-time-zone' = 'Asia/Shanghai'
);
-- mock datasource 
CREATE TEMPORARY TABLE datagen_table (
    id INT,
    name STRING,
    ts TIMESTAMP(3)
) WITH (
    'connector' = 'datagen',
    'rows-per-second' = '1',
    'fields.id.min' = '1',
    'fields.id.max' = '100',
    'fields.name.length' = '10',
    'fields.ts.kind' = 'random'
);
-- Run a stream job on Flink
INSERT INTO  orders_with_watermark
  select id, 1, now(), now() 
  from datagen_table;

What doesn't meet your expectations?

The tags should be created automatically every hour, but none.
No tag files could be found under the table folder and also no result when executing the following sql

select * from `orders_with_watermark$tags` 

Anything else?

No response

Are you willing to submit a PR?

  • I'm willing to submit a PR!
@JackeyLee007 JackeyLee007 added the bug Something isn't working label Nov 8, 2024
@JingsongLi
Copy link
Contributor

First, you can check if the job is heath.
Second, you can check the watermark in Flink topology, does the source produces the watermark normally.

@JingsongLi JingsongLi reopened this Nov 8, 2024
@JackeyLee007
Copy link
Author

Sorry, it's my fault. Actually, the watermark should be emitted from the stream source which is the datagen_table for this case.

@JackeyLee007
Copy link
Author

Thanks for your hint. @JingsongLi

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
bug Something isn't working
Projects
None yet
Development

No branches or pull requests

2 participants