hadoop►datax►datax job

datax job

从数据库读取数据写入到hdfs(mysql)

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
{
  "job": {
    "setting": {
      "speed": {
        "channel": 1,
        "byte": 2048576000
      },
      "errorLimit": {
        "record": 0,
        "percentage": 0.02
      }
    },
    "content": [
      {
        "reader": {
          "name": "mysqlreader",
          "parameter": {
            "username": "$username",
            "password": "$password",
            "connection": [
              {
                "querySql": [
                  "select column1,column2,column3 from tablename;"
                ],
                "jdbcUrl": [
                  "jdbc:mysql://$IP_addr:$port/$dbname?characterEncoding=utf-8"
                ]
              }
            ]
          }
        },
        "writer": {
          "name": "hdfswriter",
          "parameter": {
            "defaultFS": "hdfs://IP_addr:9000",
            "fileType": "text",
            "fileName": "${dbname}_${time}",
            "path": "/p/test/tablename/${time}",
            "column": [
              {
                "name": "xx",
                "type": "yy"
              },
              {
                "name": "xx",
                "type": "yy"
              },
              {
                "name": "xx",
                "type": "yy"
              },
              ... ...
            ],
            "writeMode": "append",
            "fieldDelimiter": "\t",
            "encoding": "utf-8",
            "compress": " "
          }
        }
      }
    ]
  }
}

从数据库读取数据写入到数据库(mysql)

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
{
  "job": {
    "setting": {
      "speed": {
        "channel": 1,
        "byte": 2048576000
      },
      "errorLimit": {
        "record": 0,
        "percentage": 0.02
      }
    },
    "content": [
      {
        "reader": {
          "name": "mysqlreader",
          "parameter": {
            "username": "$username",
            "password": "$password",
            "connection": [
              {
                "querySql": [
                  "SELECT colume1,colume2,colume3 FROM tablename;"
                ],
                "jdbcUrl": [
                  "jdbc:mysql://$IP_addr:$port/$dbname?characterEncoding=utf-8"
                ]
              }
            ]
          }
        },
        "writer": {
          "name": "mysqlwriter",
          "parameter": {
            "writeMode": "insert",
            "username": "$username",
            "password": "$password",
            "column": [
              "colume1",
              "colume2",
              "colume3"
            ],
            "session": [
              "set session sql_mode='ANSI'"
            ],
            "preSql": [
              "delete from tabename;"
            ],
            "connection": [
              {
                "jdbcUrl": "jdbc:mysql://$IP_addr:$port/$dbname?characterEncoding=utf-8",
                "table": [
                  "tablename"
                ]
              }
            ]
          }
        }
      }
    ]
  }
}

从数据库读取数据写入到文本文件(mysql)

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
{
  "job": {
    "setting": {
      "speed": {
        "channel": 1,
        "byte": 2048576000
      },
      "errorLimit": {
        "record": 0,
        "percentage": 0.02
      }
    },
    "content": [
      {
        "reader": {
          "name": "mysqlreader",
          "parameter": {
            "username": "$username",
            "password": "$password",
            "connection": [
              {
                "querySql": [
                  "SELECT colume1,colume2,colume3 FROM tablename;"
                ],
                "jdbcUrl": [
                  "jdbc:mysql://$IP_addr:$port/$dbname?characterEncoding=utf-8"
                ]
              }
            ]
          }
        },
        "writer": {
          "name": "txtfilewriter",
          "parameter": {
            "path": "/path/to/tablename",
            "fileName": "${dbname}_$time",
            "writeMode": "append"
          }
        }
      }
    ]
  }
}