{
"job": {
"setting": {
"speed": {
"channel": 2000,
"record": "150000"
},
"errorLimit": {
"record": 0,
"percentage": 0
}
},
"content": [
{
"reader": {
"name": "mysqlreader",
"parameter": {
"column": [
"F_trans_id",
"F_enabled",
"F_trans_type",
"F_payment_mode",
"F_state",
"F_create_time",
"F_create_time_ext",
"F_end_time",
"F_end_time_ext",
"F_modify_time",
"F_seller_user_id",
"F_seller_login_name",
"F_seller_true_name",
"F_buyer_user_id",
"F_buyer_login_name",
"F_buyer_true_name",
"F_trans_id_ext",
"F_channel_id",
"F_cash_amount",
"F_currency",
"F_goods_url",
"F_goods_name",
"F_goods_type",
"F_trans_tag",
"F_reserve_int_2",
"F_goods_channel",
"F_reserve_char_2",
"F_seller_sub_account_type",
"F_buyer_sub_account_type",
"F_fee_amount",
"F_trans_mode",
"F_pay_type",
"F_pay_recvable_id",
"F_pay_time",
"F_pay_time_ext",
"F_confirm_time",
"F_confirm_time_ext",
"F_sp_id",
"F_settlement_type",
"F_parallel_type",
"F_share_profit_flag",
"F_share_profit_time",
"F_share_profit_time_ext",
"F_pay_solution_amount",
"F_coupon_strategy",
"F_coupon_amount_new",
"F_coupon_strategy_id",
"F_goods_channel_sp_id",
"F_mkt_solution_amount",
"F_client_source_flag_create",
"F_buyer_fee_amount",
"F_pay_credit_recv_id",
"F_mkt_no_settlement_amount",
"F_seller_fee_settlement_type",
"F_seller_fee_charge_type",
"F_seller_fee_charged_user_id",
"F_seller_fee_refund_flag",
"F_product_type"
],
"splitPk": "F_trans_id",
"where": "f_create_time<'2017-01-01' and F_seller_user_id=1000000000019146",
"connection": [
{
"jdbcUrl": [
"jdbc:mysql://*.*.*.*:6000?useUnicode=true&characterEncoding=CP1252"
],
"table": [
"dyp_db_14.t_trans_query_14_6"
]
}
],
"username": "datax_r",
"password": "******"
}
},
"writer": {
"name": "mysqlwriter",
"parameter": {
"writeMode": "insert",
"username": "db_history_rw",
"password": "******",
"column": [
"F_trans_id",
"F_enabled",
"F_trans_type",
"F_payment_mode",
"F_state",
"F_create_time",
"F_create_time_ext",
"F_end_time",
"F_end_time_ext",
"F_modify_time",
"F_seller_user_id",
"F_seller_login_name",
"F_seller_true_name",
"F_buyer_user_id",
"F_buyer_login_name",
"F_buyer_true_name",
"F_trans_id_ext",
"F_channel_id",
"F_cash_amount",
"F_currency",
"F_goods_url",
"F_goods_name",
"F_goods_type",
"F_trans_tag",
"F_reserve_int_2",
"F_goods_channel",
"F_reserve_char_2",
"F_seller_sub_account_type",
"F_buyer_sub_account_type",
"F_fee_amount",
"F_trans_mode",
"F_pay_type",
"F_pay_recvable_id",
"F_pay_time",
"F_pay_time_ext",
"F_confirm_time",
"F_confirm_time_ext",
"F_sp_id",
"F_settlement_type",
"F_parallel_type",
"F_share_profit_flag",
"F_share_profit_time",
"F_share_profit_time_ext",
"F_pay_solution_amount",
"F_coupon_strategy",
"F_coupon_amount_new",
"F_coupon_strategy_id",
"F_goods_channel_sp_id",
"F_mkt_solution_amount",
"F_client_source_flag_create",
"F_buyer_fee_amount",
"F_pay_credit_recv_id",
"F_mkt_no_settlement_amount",
"F_seller_fee_settlement_type",
"F_seller_fee_charge_type",
"F_seller_fee_charged_user_id",
"F_seller_fee_refund_flag",
"F_product_type"
],
"createSql": [
"CREATE DATABASE IF NOT EXISTS dyp_db_14;",
"use dyp_db_14;\nCREATE TABLE IF NOT EXISTS `t_trans_query_14_6` (\n `F_trans_id` varchar(32) COLLATE latin1_bin NOT NULL,\n `F_enabled` tinyint(3) unsigned DEFAULT '1',\n `F_trans_type` smallint(5) unsigned NOT NULL,\n `F_payment_mode` tinyint(3) unsigned NOT NULL DEFAULT '1',\n `F_state` tinyint(3) unsigned DEFAULT '1',\n `F_create_time` datetime NOT NULL,\n `F_create_time_ext` datetime NOT NULL,\n `F_end_time` datetime DEFAULT '0000-00-00 00:00:00',\n `F_end_time_ext` datetime DEFAULT '0000-00-00 00:00:00',\n `F_modify_time` datetime NOT NULL,\n `F_seller_user_id` bigint(20) unsigned NOT NULL,\n `F_seller_login_name` varchar(32) COLLATE latin1_bin DEFAULT NULL,\n `F_seller_true_name` varchar(160) COLLATE latin1_bin DEFAULT NULL,\n `F_buyer_user_id` bigint(20) unsigned NOT NULL,\n `F_buyer_login_name` varchar(32) COLLATE latin1_bin DEFAULT NULL,\n `F_buyer_true_name` varchar(160) COLLATE latin1_bin DEFAULT NULL,\n `F_trans_id_ext` varchar(64) COLLATE latin1_bin NOT NULL,\n `F_channel_id` smallint(5) unsigned NOT NULL DEFAULT '1',\n `F_cash_amount` bigint(20) DEFAULT '0',\n `F_currency` tinyint(3) unsigned DEFAULT '1',\n `F_goods_url` varchar(255) COLLATE latin1_bin DEFAULT NULL,\n `F_goods_name` varchar(128) COLLATE latin1_bin DEFAULT NULL,\n `F_goods_type` tinyint(3) unsigned DEFAULT '1',\n `F_trans_tag` smallint(5) unsigned DEFAULT '0',\n `F_reserve_int_2` int(11) DEFAULT NULL,\n `F_goods_channel` varchar(64) COLLATE latin1_bin DEFAULT '0',\n `F_reserve_char_2` varchar(64) COLLATE latin1_bin DEFAULT NULL,\n `F_seller_sub_account_type` smallint(5) unsigned NOT NULL DEFAULT '1',\n `F_buyer_sub_account_type` smallint(5) unsigned NOT NULL DEFAULT '1',\n `F_fee_amount` bigint(20) DEFAULT '0',\n `F_trans_mode` smallint(5) unsigned DEFAULT '1',\n `F_pay_type` smallint(5) unsigned DEFAULT NULL,\n `F_pay_recvable_id` varchar(32) COLLATE latin1_bin DEFAULT NULL,\n `F_pay_time` datetime DEFAULT NULL,\n `F_pay_time_ext` datetime DEFAULT NULL,\n `F_confirm_time` datetime DEFAULT NULL,\n `F_confirm_time_ext` datetime DEFAULT NULL,\n `F_sp_id` varchar(16) COLLATE latin1_bin DEFAULT NULL,\n `F_settlement_type` smallint(5) unsigned DEFAULT '1',\n `F_parallel_type` tinyint(3) unsigned NOT NULL DEFAULT '0',\n `F_share_profit_flag` tinyint(3) unsigned NOT NULL DEFAULT '1',\n `F_share_profit_time` datetime DEFAULT NULL,\n `F_share_profit_time_ext` datetime DEFAULT NULL,\n `F_pay_solution_amount` bigint(20) NOT NULL DEFAULT '0',\n `F_coupon_strategy` varchar(1000) COLLATE latin1_bin DEFAULT NULL,\n `F_coupon_amount_new` bigint(20) DEFAULT '0',\n `F_coupon_strategy_id` smallint(5) DEFAULT '0',\n `F_goods_channel_sp_id` varchar(16) COLLATE latin1_bin DEFAULT '0',\n `F_mkt_solution_amount` bigint(20) NOT NULL DEFAULT '0' COMMENT '',\n `F_client_source_flag_create` varchar(32) COLLATE latin1_bin NOT NULL DEFAULT '' COMMENT '',\n `F_buyer_fee_amount` bigint(20) DEFAULT '0' COMMENT '',\n `F_pay_credit_recv_id` varchar(32) COLLATE latin1_bin NOT NULL DEFAULT '',\n `F_mkt_no_settlement_amount` bigint(20) NOT NULL DEFAULT '0',\n `F_seller_fee_settlement_type` smallint(5) unsigned NOT NULL DEFAULT '1' COMMENT '',\n `F_seller_fee_charge_type` smallint(5) unsigned NOT NULL DEFAULT '1' COMMENT '',\n `F_seller_fee_charged_user_id` bigint(20) unsigned NOT NULL DEFAULT '0' COMMENT '',\n `F_seller_fee_refund_flag` smallint(5) unsigned NOT NULL DEFAULT '1' COMMENT '',\n `F_product_type` smallint(5) NOT NULL DEFAULT '0' COMMENT '',\n PRIMARY KEY (`F_trans_id`),\n KEY `I_create_time_seller` (`F_seller_user_id`,`F_seller_sub_account_type`,`F_modify_time`),\n KEY `I_create_time_buyer` (`F_buyer_user_id`,`F_buyer_sub_account_type`,`F_modify_time`),\n KEY `I_create_ctime_seller` (`F_seller_user_id`,`F_seller_sub_account_type`,`F_create_time`),\n KEY `I_create_ctime_buyer` (`F_buyer_user_id`,`F_buyer_sub_account_type`,`F_create_time`),\n KEY `I_create_ptime_seller` (`F_seller_user_id`,`F_seller_sub_account_type`,`F_pay_time`),\n KEY `I_create_ptime_buyer` (`F_buyer_user_id`,`F_buyer_sub_account_type`,`F_pay_time`)\n) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_bin ROW_FORMAT=COMPRESSED KEY_BLOCK_SIZE=8;",
"use dyp_db_14;\ntruncate table t_trans_query_14_6;"
],
"preSql": [],
"connection": [
{
"jdbcUrl": "jdbc:mysql://*.*.*.*:6000?useUnicode=true&characterEncoding=CP1252",
"table": [
"dyp_db_14.t_trans_query_14_6"
]
}
]
}
}
}
]
}
}