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

can't REFRESH a materialized view based on paimon catalog #45795

Closed
MirrerZu opened this issue May 17, 2024 · 1 comment
Closed

can't REFRESH a materialized view based on paimon catalog #45795

MirrerZu opened this issue May 17, 2024 · 1 comment
Labels
type/bug Something isn't working

Comments

@MirrerZu
Copy link

Steps to reproduce the behavior (Required)

create a paimon catalog:

CREATE EXTERNAL CATALOG `paimon`
PROPERTIES ("type"  =  "paimon",
"paimon.catalog.type"  =  "filesystem",
"paimon.catalog.warehouse"  =  "file:///tmp/paimon"
)

there is a table in paimon catalog like:

CREATE TABLE `test1` (
  `id` int(11) DEFAULT NULL,
  `hchar` varchar(1048576) DEFAULT NULL,
  `hdecimal` decimal(13, 3) DEFAULT NULL
)
PROPERTIES ("location" = "file:///tmp/paimon/cdctest.db/test1");

create a materialized view based on paimon catalog :

CREATE MATERIALIZED VIEW temptest1
DISTRIBUTED BY HASH(`id`)
REFRESH ASYNC EVERY (interval 1 minute)
AS select * from paimon.cdctest.test1;

then I change test1's data in paimon , the viewtemptest1 should change after 1 minute.

Expected behavior (Required)

the materialized view temptest1 should change following the paimon table.

Real behavior (Required)

the materialized view temptest1 don't have any change after 10 minute; even if I recreate a manual refresh materialized view and do refresh by hand, the view's data can't change.
at the same time, I directly query the table in paimon catalog, the result is correctly changed.

StarRocks version (Required)

3.2.6

@MirrerZu MirrerZu added the type/bug Something isn't working label May 17, 2024
@MirrerZu MirrerZu changed the title Create materialized view based on paimon catalog can't REFRESH can't REFRESH a materialized view based on paimon catalog May 17, 2024
@MirrerZu
Copy link
Author

3.3.0-rc01 works well !
Hope next version can be released soon

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

No branches or pull requests

1 participant