Fetch the repository succeeded.
connection
"connection": [{
"jdbcUrl": "jdbc:pivotal:greenplum://localhost:5432;DatabaseName=database",
"table": ["table"],
"schema":"public"
}]
jdbcUrl
insert
操作,可以搭配insertSqlMode使用COPY table_name [ ( column_name [, ...] ) ] FROM STDIN DELIMITER 'delimiter_character'
语句,提高数据的插入效率insert
过慢带来的问题,此参数被固定为copy
insert
,否则设置无效{
"job": {
"content": [{
"reader": {
"parameter": {
"column": [
{
"name": "id",
"type": "int",
"value": 1
}
],
"sliceRecordCount": ["100"]
},
"name" : "streamreader"
},
"writer": {
"name": "greenplumwriter",
"parameter": {
"connection": [{
"jdbcUrl": "jdbc:pivotal:greenplum://localhost:5432;DatabaseName=database",
"table": ["table"]
}],
"username": "username",
"password": "password",
"column": ["id"],
"writeMode": "insert",
"insertSqlMode": "copy",
"batchSize": 100,
"preSql": ["TRUNCATE table"],
"postSql": []
}
}
}],
"setting": {
"speed": {
"channel": 1,
"bytes": 0
},
"errorLimit": {
"record": 100
}
}
}
}
此处可能存在不合适展示的内容,页面不予展示。您可通过相关编辑功能自查并修改。
如您确认内容无涉及 不当用语 / 纯广告导流 / 暴力 / 低俗色情 / 侵权 / 盗版 / 虚假 / 无价值内容或违法国家有关法律法规的内容,可点击提交进行申诉,我们将尽快为您处理。