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"
}
}
}
]
}
}