Doris2.1.10使用catalog连接paimon,新增数据看不到,必须手动refresh CATALOG才能看得到

Viewed 5

Doris2.1.10使用catalog连接paimon(paimon数据是存储在minio中)后,Flink手动往paimon中insert一条数据后,在Doris中查不到新增的数据,必须要refresh CATALOG才能看得到,问题是怎么导致的?怎么处理?
以下是Doris创建catalog语句:
CREATE CATALOG paimon_minio_131 PROPERTIES (
'type' = 'paimon',
'warehouse' = 's3://paimon131/testdb',
'paimon.catalog.type' = 'filesystem',
's3.endpoint' = 'http://192.168.101.131:9000',
's3.access_key' = 'admin',
's3.secret_key' = 'Bkgx123$%^',
's3.path.style.access' = 'true'
);
FlinkSQL创建paimon表语句:
CREATE TABLE my_table (
user_id BIGINT,
item_id BIGINT,
behavior STRING,
dt STRING,
hh STRING,
PRIMARY KEY (dt, hh, user_id) NOT ENFORCED
);
导入数据测试语句:insert into my_table values(5,105,'出库','2025-11-14','18:17:20');

06a36903e68fdd37f185374e5fdbd1fe.png

885194192857be962434a066d76a5f55.png

8380c6b860b13281b603863e94b53624.png

0 Answers