You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
create a materialized view based on paimon catalog :
CREATE MATERIALIZED VIEW temptest1
DISTRIBUTED BY HASH(`id`)
REFRESH ASYNC EVERY (interval 1 minute)
ASselect*frompaimon.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
The text was updated successfully, but these errors were encountered:
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
Steps to reproduce the behavior (Required)
create a paimon catalog:
there is a table in paimon catalog like:
create a materialized view based on paimon catalog :
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
The text was updated successfully, but these errors were encountered: