数据仓库服务 GAUSSDB(DWS)-订阅实时数仓Binlog:开启Binlog

时间:2024-11-15 15:19:28

开启Binlog

通过在建HStore表时指定表级参数enable_binlog,开启HStore表的Binlog功能。
 1
 2
 3
 4
 5
 6
 7
 8
 9
10
CREATE TABLE hstore_binlog_source (
    c1  INT PRIMARY KEY,
    c2  INT,
    c3  INT
) WITH (
    ORIENTATION = COLUMN, 
    enable_hstore=true, 
    enable_binlog=on,
    binlog_ttl = 86400
);
support.huaweicloud.com/HyDevg-910-dws/dws_04_1211.html