数据仓库服务 GAUSSDB(DWS)-Hudi外表查询:增量查询

时间:2024-06-29 17:51:21

增量查询

针对hudi增量查询功能,可以通过设置增量查询参数实现增量查询。

1
2
3
4
SET hoodie.SCHEMA.FOREIGN_TABLE.consume.mode=incremental;
SET hoodie.SCHEMA.FOREIGN_TABLE.consume.start.timestamp=起始时间戳;
SET hoodie.SCHEMA.FOREIGN_TABLE.consume.ending.timestamp=结束时间戳;
SELECT * FROM SCHEMA.FOREIGN_TABLE;
support.huaweicloud.com/devg-830-dws/dws_04_1075.html