Dinky的使用——实现多路输出

其实多路输出就是制定多个个insert into语句，我这里以mysql数据库为例，实现三路输出的一个小案例

一、创建作业

二、编写flinksql代码

CREATE TABLE source_news( 
`id` INT,
`timestamp` TIMESTAMP,
`title` STRING,
`source` STRING,
`head_img` STRING,
`url` STRING,
`category` STRING,
`keyword` STRING,
`tag` STRING,
`description` STRING,
`content` STRING
) COMMENT 'source_news'
WITH (
  'connector' = 'jdbc', 
  'url' = 'jdbc:mysql://172.16.119.50:3306/test?createDatabaseIfNotExist=true&useSSL=false&characterEncoding=UTF-8',
  'username' = 'root',
  'password' = 'Tj@20220710', 
  'table-name' = 'source_news' 
);

CREATE TABLE sport_count( 
`id` INT,
`timestamp` TIMESTAMP,
`title` STRING,
`source` STRING,
`head_img` STRING,
`url` STRING,
`category` STRING,
`keyword` STRING,
`tag` STRING,
`description` STRING,
`content` STRING
) COMMENT 'sport_count' WITH (
  'connector' = 'jdbc', 
  'url' = 'jdbc:mysql://172.16.119.50:3306/test?createDatabaseIfNotExist=true&useSSL=false&characterEncoding=UTF-8',
  'username' = 'root',
  'password' = 'Tj@20220710', 
  'table-name' = 'sport_count' 
);

CREATE TABLE sport_football( 
`id` INT,
`timestamp` TIMESTAMP,
`title` STRING,
`source` STRING,
`head_img` STRING,
`url` STRING,
`category` STRING,
`keyword` STRING,
`tag` STRING,
`description` STRING,
`content` STRING
) COMMENT 'sport_football' WITH (
  'connector' = 'jdbc', 
  'url' = 'jdbc:mysql://172.16.119.50:3306/test?createDatabaseIfNotExist=true&useSSL=false&characterEncoding=UTF-8',
  'username' = 'root',
  'password' = 'Tj@20220710', 
  'table-name' = 'sport_football' 
);

create table raise_children_count(
    `id` int,
    `category` string,
    `title` string
    -- PRIMARY KEY (id) NOT ENFORCED
)  COMMENT 'raise_children_count' with(
  'connector' = 'jdbc', 
  'url' = 'jdbc:mysql://172.16.119.50:3306/test?createDatabaseIfNotExist=true&useSSL=false&characterEncoding=UTF-8',
  'username' = 'root',
  'password' = 'Tj@20220710', 
  'table-name' = 'raise_children_count'
);


  insert into raise_children_count(category,title)
   select category,title from source_news where category='育儿';

insert into sport_count
    SELECT *  FROM source_news where category='运动';

insert into sport_football
    select * from source_news where tag like '%国足%';