GreenPlum Writer

GreenPlum Writer plugin implements writing data to GreenPlum database.

Configuration Example

This plugin is used to write data to GreenPlum database. This plugin is based on RDBMS Writer, so you can refer to all configuration items of RDBMS Writer.

{
  "job": {
    "setting": {
      "speed": {
        "channel": 1,
        "bytes": -1
      }
    },
    "content": {
      "reader": {
        "name": "postgresqlreader",
        "parameter": {
          "username": "wgzhao",
          "password": "wgzhao",
          "column": [
            "*"
          ],
          "connection": {
            "table": [
              "addax_tbl"
            ],
            "jdbcUrl": "jdbc:postgresql://localhost:5432/wgzhao"
          }
        }
      },
      "writer": {
        "name": "greenplumwriter",
        "parameter": {
          "username": "wgzhao",
          "password": "wgzhao",
          "column": [
            "*"
          ],
          "preSql": [
            "truncate table @table"
          ],
          "connection": {
            "jdbcUrl": "jdbc:postgresql://localhost:5432/wgzhao",
            "table": [
              "gp_test"
            ]
          }
        }
      }
    }
  }
}