[GitHub] [inlong] chyueyi commented on issue #6723: 官方文档Doris多表写入文档错误

[GitBox]

chyueyi commented on issue #6723:
URL: https://github.com/apache/inlong/issues/6723#issuecomment-1343736167

   这样写可以多表同步
   ```sql
   SET 'execution.checkpointing.interval' = '3s';
   SET 'table.dynamic-table-options.enabled' = 'true';
   
   CREATE TABLE cdc_mysql_source (
      `data` BYTES METADATA FROM 'meta.data_canal' VIRTUAL
    ) WITH (
   'inlong.metric.labels' = 'groupId=1&streamId=1&nodeId=1',
   'migrate-all' = 'true',
   'connector' = 'mysql-cdc-inlong',
   'scan.incremental.snapshot.enabled' = 'false',
   'hostname' = '172.17.**.**',
   'database-name' = 'c_test3',
   'username' = 'root',
   'password' = '123456',
   'table-name' = 'c_test3\.test,c_test3\.test2'
   );
   
   
   CREATE TABLE cdc_doris_sink (
    `data` BYTES
    )WITH (
      'connector' = 'doris-inlong',
      'fenodes' = '172.17.**.**:8030',
      'username' = 'root',
      'password' = '123456',
      'sink.enable-delete' = 'true',
      'sink.multiple.enable' = 'true',
      'sink.multiple.format' = 'canal-json',
      'sink.multiple.database-pattern' = '${database}',
      'sink.multiple.table-pattern' = '${table}'
     );
   
   insert into cdc_doris_sink select * from cdc_mysql_source;
   ```


-- 
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

To unsubscribe, e-mail: commits-unsubscr...@inlong.apache.org

For queries about this service, please contact Infrastructure at:
us...@infra.apache.org