{
    "job": {
        "content": [
            {
                "reader": {
                    "name": "txtfilereader",
                    "parameter": {
                        "path": ["/webapps/datax/fail"],
                        "encoding": "UTF-8",
                        "column": [
                            {
                                "index": 0,
                                "type": "string"
                            },
                            {
                                "index": 1,
                                "type": "string"
                            },
                            {
                                "index": 2,
                                "type": "string"
                            },
                            {
                                "index": 3,
                                "type": "string"
                            },
                            {
                                "index": 4,
                                "type": "string"
                            },
                            {
                                "index": 5,
                                "type": "string"
                            },
                            {
                                "index": 6,
                                "type": "string"
                            },
                            {
                                "index": 7,
                                "type": "string"
                            },
                            {
                                "index": 8,
                                "type": "string"
                            },
                            {
                                "index": 9,
                                "type": "string"
                            },
                            {
                                "index": 10,
                                "type": "string"
                            },
                            {
                                "index": 11,
                                "type": "string"
                            },
                            {
                                "index": 12,
                                "type": "string"
                            },
                            {
                                "index": 13,
                                "type": "string"
                            },
                            {
                                "index": 14,
                                "type": "string"
                            },
                            {
                                "index": 15,
                                "type": "string"
                            },
                            {
                                "index": 16,
                                "type": "date",
                                "format": "yyyy-MM-dd HH:mm:ss"
                            },
                            {
                                "index": 17,
                                "type": "date",
                                "format": "yyyy-MM-dd HH:mm:ss"
                            },
                            {
                                "index": 18,
                                "type": "date",
                                "format": "yyyy-MM-dd HH:mm:ss"
                            },
                            {
                                "index": 19,
                                "type": "date",
                                "format": "yyyy-MM-dd HH:mm:ss"
                            },
                            {
                                "index": 20,
                                "type": "date",
                                "format": "yyyy-MM-dd HH:mm:ss"
                            },
                            {
                                "index": 21,
                                "type": "date",
                                "format": "yyyy-MM-dd HH:mm:ss"
                            },
                            {
                                "index": 22,
                                "type": "date",
                                "format": "yyyy-MM-dd HH:mm:ss"
                            },
                            {
                                "index": 23,
                                "type": "date",
                                "format": "yyyy-MM-dd HH:mm:ss"
                            },
                            {
                                "index": 24,
                                "type": "string"
                            },
                            {
                                "index": 25,
                                "type": "string"
                            },
                            {
                                "index": 26,
                                "type": "string"
                            },
                            {
                                "index": 27,
                                "type": "string"
                            },
                            {
                                "index": 28,
                                "type": "string"
                            },
                            {
                                "index": 29,
                                "type": "string"
                            },
                            {
                                "index": 30,
                                "type": "string"
                            },
                            {
                                "index": 31,
                                "type": "string"
                            },
                            {
                                "index": 32,
                                "type": "string"
                            },
                            {
                                "index": 33,
                                "type": "string"
                            },
                            {
                                "index": 34,
                                "type": "string"
                            },
                            {
                                "index": 35,
                                "type": "string"
                            },
                            {
                                "index": 36,
                                "type": "string"
                            },
                            {
                                "index": 37,
                                "type": "string"
                            },
                            {
                                "index": 38,
                                "type": "string"
                            },
                            {
                                "index": 39,
                                "type": "string"
                            },
                            {
                                "index": 40,
                                "type": "string"
                            },
                            {
                                "index": 41,
                                "type": "string"
                            },
                            {
                                "index": 42,
                                "type": "string"
                            },
                            {
                                "index": 43,
                                "type": "string"
                            },
                            {
                                "index": 44,
                                "type": "string"
                            },
                            {
                                "index": 45,
                                "type": "string"
                            },
                            {
                                "index": 46,
                               "type": "string"
                            },
                            {
                                "index": 47,
                                "type": "string"
                            },
                            {
                                "index": 48,
                                "type": "string"
                            },
                            {
                                "index": 49,
                                "type": "string"
                            },
                            {
                                "index": 50,
                                "type": "string"
                            },
                            {
                                "index": 51,
                                "type": "string"
                            },
                            {
                                "index": 52,
                                "type": "string"
                            },
                            {
                                "index": 53,
                                "type": "string"
                            },
                            {
                                "index": 54,
                                "type": "string"
                            },
                            {
                                "index": 55,
                                "type": "string"
                            },
                            {
                                "index": 56,
                                "type": "string"
                            },
                            {
                                "index": 57,
                                "type": "string"
                            },
                            {
                                "index": 58,
                                "type": "date",
                                "format": "yyyy-MM-dd HH:mm:ss"
                            },
                            {
                                "index": 59,
                                "type": "date",
                                "format": "yyyy-MM-dd HH:mm:ss"
                            }
                        ],
                        "fieldDelimiter": ",",
                        "nullFormat":"null",
                        "compress": "gzip"
                    }
                },
                "writer": {
                    "name": "mysqlwriter",
                    "parameter": {
                        "writeMode": "insert",
                        "username": "用户名",
                        "password": "密码",
                        "column": [
                            "session_id",
                            "call_id_a",
                            "call_id_b",
                            "caller_nbr",
                            "callee_nbr",
                            "display_nbr",
                            "service_nbr_a",
                            "service_nbr_b",
                            "province",
                            "local_net",
                            "cust_id",
                            "cust_name",
                            "order_id",
                            "area_code",
                            "pro_type",
                            "service_type",
                            "start_time",
                            "end_time",
                            "dial_time",
                            "call_in",
                            "start_ring",
                            "answer",
                            "hung_up",
                            "ring_time",
                            "hung_up_originator",
                            "duration",
                            "min_duration",
                            "memory_id",
                            "disposition",
                            "error_message",
                            "status",
                            "yzj_type",
                            "extension_num",
                            "user_data",
                            "event_flag",
                            "event_flag_real_time",
                            "record_in",
                            "record_out",
                            "record_mode",
                            "voice_address",
                            "voice_address_in",
                            "voice_address_out",
                            "charge_number",
                            "is_charge",
                            "call_status",
                            "platform_order_id",
                            "platform_cust_id",
                            "platform_cust_use_id",
                            "sales_code",
                            "attr_code",
                            "main_bill_number",
                            "bill_number",
                            "duration6s",
                            "is_deal",
                            "partition_code",
                            "remark1",
                            "remark2",
                            "remark3",
                            "create_time",
                            "update_time"
                        ],
                        "session": [
                            "set session sql_mode='ANSI'"
                        ],
                        "preSql": [
                            ""
                        ],
                        "connection": [
                            {
                                "jdbcUrl": "jdbc:mysql://ip:2883/oadb?useUnicode=true&characterEncoding=utf8&useSSL=false",
                                "table": [
                                    "uoap_cdr_calls_detail_fail"
                                ]
                            }
                        ]
                    }
                }


            }
        ],
        "setting": {
            "speed": {
                "channel": 5
            }
        }
    }
}