代码拉取完成,页面将自动刷新
类型:lookup
名称:mysqlLookup
MySQL 5.X
column
描述:需要读取的字段。
注意:当进行维表补全后,即在原先的Row数据集中追加了补全的列,则在Writer写入时候需要在Column配置这种定义增加的列。
格式:支持3种格式
"column":["*"]
"column":["id","name"]
"column": [{
"name": "col",
"type": "datetime"
}]
属性说明:
必选:是
字段类型:Array
默认值:无
{
"job": {
"content": [
{
"mysqlReader1": {
"type" : "reader",
"pluginName" : "mysqlReader",
"parameter": {
"jdbcUrl" : "jdbc:mysql://0.0.0.1:3306/database?useSSL=false",
"username" : "username",
"password" : "password",
"table" : "student",
"column": [{
"name": "id",
"type": "int"
},{
"name": "name",
"type": "varchar"
},{
"name": "sex",
"type": "int"
}]
}
},
"jdbcLookup": {
"type": "lookup",
"pluginName": "mysqlLookup",
"parameter": {
"cacheType": "lru",
"cacheMaxrows": 10000,
"cacheTtl": 180000,
"username": "root",
"password": "123",
"jdbcUrl": "jdbc:mysql://10.254.10.31:3306/demo?useunicode=true&characterEncoding=utf8&zeroDateTimeBehavior=convertToNull&serverTimezone=Asia/Shanghai",
"table": "dm_sys_code",
"where": "code_id='dm_sex'",
"joinColumns": {"sex": "sex_code"},
"columns": ["sex_code","sex_value"]
}
},
"mysqlWriter2" : {
"type" : "writer",
"pluginName" : "mysqlWriter",
"parameter" : {
"jdbcUrl" : "jdbc:mysql://0.0.0.1:3306/database?useSSL=false",
"username" : "username",
"password" : "password",
"table" : "student1",
"column": [
{"name": "id","type": "int"},
{"name": "name","type": "string"},
{"name": "sex","type": "int"},
{"name": "sex_value","type": "string"}
],
"writeMode" : "INSERT"
}
}
}
],
"setting": {
"name": "myJob",
"speed": {
"channel": 2
},
"restore": {
"isRestore": false
}
}
}
}
{
"job": {
"content": [
{
"mysqlReader1": {
"type" : "reader",
"pluginName" : "mysqlReader",
"parameter": {
"jdbcUrl" : "jdbc:mysql://0.0.0.1:3306/database?useSSL=false",
"username" : "username",
"password" : "password",
"table" : "student",
"column": [{
"name": "id",
"type": "int"
},{
"name": "name",
"type": "varchar"
},{
"name": "sex",
"type": "int"
}]
}
},
"jdbcLookup": {
"type": "lookup",
"pluginName": "mysqlLookup",
"parameter": {
"cacheType": "nono",
"username": "root",
"password": "123",
"jdbcUrl": "jdbc:mysql://10.254.10.31:3306/demo?useunicode=true&characterEncoding=utf8&zeroDateTimeBehavior=convertToNull&serverTimezone=Asia/Shanghai",
"table": "dm_sys_code",
"where": "code_id='dm_sex'",
"joinColumns": {"sex": "sex_code"},
"columns": ["sex_code","sex_value"]
}
},
"mysqlWriter2" : {
"type" : "writer",
"pluginName" : "mysqlWriter",
"parameter" : {
"jdbcUrl" : "jdbc:mysql://0.0.0.1:3306/database?useSSL=false",
"username" : "username",
"password" : "password",
"table" : "student1",
"column": [
{"name": "id","type": "int"},
{"name": "name","type": "string"},
{"name": "sex","type": "int"},
{"name": "sex_value","type": "string"}
],
"writeMode" : "INSERT"
}
}
}
],
"setting": {
"name": "myJob",
"speed": {
"channel": 2
},
"restore": {
"isRestore": false
}
}
}
}
{
"job": {
"content": [
{
"mysqlReader1": {
"type" : "reader",
"pluginName" : "mysqlReader",
"parameter": {
"jdbcUrl" : "jdbc:mysql://0.0.0.1:3306/database?useSSL=false",
"username" : "username",
"password" : "password",
"table" : "student",
"column": [{
"name": "id",
"type": "int"
},{
"name": "name",
"type": "varchar"
},{
"name": "sex",
"type": "int"
}]
}
},
"jdbcLookup": {
"type": "lookup",
"pluginName": "mysqlLookup",
"parameter": {
"cacheType": "all",
"username": "root",
"password": "123",
"jdbcUrl": "jdbc:mysql://10.254.10.31:3306/demo?useunicode=true&characterEncoding=utf8&zeroDateTimeBehavior=convertToNull&serverTimezone=Asia/Shanghai",
"table": "dm_sys_code",
"where": "code_id='dm_sex'",
"joinColumns": {"sex": "sex_code"},
"columns": ["sex_code","sex_value"]
}
},
"mysqlWriter2" : {
"type" : "writer",
"pluginName" : "mysqlWriter",
"parameter" : {
"jdbcUrl" : "jdbc:mysql://0.0.0.1:3306/database?useSSL=false",
"username" : "username",
"password" : "password",
"table" : "student1",
"column": [
{"name": "id","type": "int"},
{"name": "name","type": "string"},
{"name": "sex","type": "int"},
{"name": "sex_value","type": "string"}
],
"writeMode" : "INSERT"
}
}
}
],
"setting": {
"name": "myJob",
"speed": {
"channel": 2
},
"restore": {
"isRestore": false
}
}
}
}
此处可能存在不合适展示的内容,页面不予展示。您可通过相关编辑功能自查并修改。
如您确认内容无涉及 不当用语 / 纯广告导流 / 暴力 / 低俗色情 / 侵权 / 盗版 / 虚假 / 无价值内容或违法国家有关法律法规的内容,可点击提交进行申诉,我们将尽快为您处理。