httpSink.md

March 3, 2021 · View on GitHub

1.格式:

CREATE TABLE tableName(
    colName colType,
    ...
    colNameX colType
 )WITH(
    type ='http', 
    url ='http://xxx:8080/test/returnAll'
    ,flag ='aa' 
    ,delay = '10' 
 );

3.表结构定义

参数名称含义
tableNamehttp表名称
colName列名称
colType列类型 colType支持的类型

4.参数:

参数名称含义是否必填默认值
http结果表插件类型,必须为http
url地址
flag结果返回标识符
delay每条结果数据之间延时时间默认20毫秒

5.样例:


-- {"name":"maqi","id":1001}
CREATE TABLE sourceIn (
    id int,
    name VARCHAR
)WITH(
    type  =  'kafka',  
    bootstrapServers  =  'localhost:9092',  
    topic ='test1'
 );

CREATE  TABLE  sinkOut  (
  id  int 
  , name varchar 
) WITH  (
  type ='http', 
  url ='http://xxx:8080/test/returnAll'
  ,flag ='aa' 
  ,delay = '10' 
);

insert into sinkOut select id,name from sourceIn;

发送数据:{"name":"maqi","id":1001}
结果数据:
1.flag不填或者为空串:{"name":"maqi","id":1001}
2.flag有内容:{"flag":"11111111","name":"maqi","id":1001,"tableName":"sinkOut"}