-- Task: imp.wx_video_detail.wx_video_detail ID: 1000416082 Type: DI { "extend":{ "mode":"wizard", "resourceGroup":"group_42901", "oneStopPageNum":2 }, "transform":false, "mappingRule":{ "sourceType":"mysql", "targetType":"odps", "needDiff":true, "targetTableColumn":[ { "name":"id", "comment":"", "typeDetail":"{\"odpsType\":\"BIGINT\",\"typeName\":\"BIGINT\"}", "type":"BIGINT" }, { "name":"video_id", "comment":"", "typeDetail":"{\"odpsType\":\"BIGINT\",\"typeName\":\"BIGINT\"}", "type":"BIGINT" }, { "name":"uid", "comment":"", "typeDetail":"{\"odpsType\":\"BIGINT\",\"typeName\":\"BIGINT\"}", "type":"BIGINT" }, { "name":"gmt_create", "comment":"", "typeDetail":"{\"odpsType\":\"DATETIME\",\"typeName\":\"DATETIME\"}", "type":"DATETIME" }, { "name":"app_type", "comment":"", "typeDetail":"{\"odpsType\":\"BIGINT\",\"typeName\":\"BIGINT\"}", "type":"BIGINT" }, { "name":"barrage_switch", "comment":"弹幕开关 1打开 -1关闭", "typeDetail":"{\"odpsType\":\"BIGINT\",\"typeName\":\"BIGINT\"}", "type":"BIGINT" }, { "name":"barrage_count", "comment":"弹幕数", "typeDetail":"{\"odpsType\":\"BIGINT\",\"typeName\":\"BIGINT\"}", "type":"BIGINT" }, { "name":"comment_count", "comment":"评论数", "typeDetail":"{\"odpsType\":\"BIGINT\",\"typeName\":\"BIGINT\"}", "type":"BIGINT" }, { "name":"share_image_path", "comment":"分享到微信会话的图片的宽高比为5:4底片的路径", "typeDetail":"{\"odpsType\":\"STRING\",\"typeName\":\"STRING\"}", "type":"STRING" }, { "name":"descr", "comment":"视频简介", "typeDetail":"{\"odpsType\":\"STRING\",\"typeName\":\"STRING\"}", "type":"STRING" }, { "name":"sample_request_id", "comment":"试看视频的转码任务请求id", "typeDetail":"{\"odpsType\":\"STRING\",\"typeName\":\"STRING\"}", "type":"STRING" }, { "name":"sample_job_id", "comment":"试看视频的转码任务id", "typeDetail":"{\"odpsType\":\"STRING\",\"typeName\":\"STRING\"}", "type":"STRING" }, { "name":"sample_transcode_status", "comment":"试看视频的转码任务状态(1:发送转码失败,2:转码中,3:转码完成,4:转码失败,5是不需要发送转码,此状态只针对于detail表而言)", "typeDetail":"{\"odpsType\":\"BIGINT\",\"typeName\":\"BIGINT\"}", "type":"BIGINT" }, { "name":"sample_transed_video_path", "comment":"试看视频的转码后的视频路径", "typeDetail":"{\"odpsType\":\"STRING\",\"typeName\":\"STRING\"}", "type":"STRING" }, { "name":"charge", "comment":"0 免费 1收费", "typeDetail":"{\"odpsType\":\"BIGINT\",\"typeName\":\"BIGINT\"}", "type":"BIGINT" }, { "name":"price", "comment":"金额 单位 分", "typeDetail":"{\"odpsType\":\"BIGINT\",\"typeName\":\"BIGINT\"}", "type":"BIGINT" }, { "name":"sample_total_time", "comment":"试看时长", "typeDetail":"{\"odpsType\":\"BIGINT\",\"typeName\":\"BIGINT\"}", "type":"BIGINT" }, { "name":"sample_transed_datetime", "comment":"试看视频转完码的时间点", "typeDetail":"{\"odpsType\":\"DATETIME\",\"typeName\":\"DATETIME\"}", "type":"DATETIME" }, { "name":"allow_ios_play", "comment":"是否允许ios端播放,0不允许,1 允许", "typeDetail":"{\"odpsType\":\"BIGINT\",\"typeName\":\"BIGINT\"}", "type":"BIGINT" }, { "name":"pay_count", "comment":"支付过的人数", "typeDetail":"{\"odpsType\":\"BIGINT\",\"typeName\":\"BIGINT\"}", "type":"BIGINT" }, { "name":"cus_title", "comment":"自定义标题", "typeDetail":"{\"odpsType\":\"STRING\",\"typeName\":\"STRING\"}", "type":"STRING" }, { "name":"cus_desc", "comment":"自定义简介", "typeDetail":"{\"odpsType\":\"STRING\",\"typeName\":\"STRING\"}", "type":"STRING" }, { "name":"task_status", "comment":"0 未处理,1 已处理", "typeDetail":"{\"odpsType\":\"BIGINT\",\"typeName\":\"BIGINT\"}", "type":"BIGINT" }, { "name":"discern_status", "comment":"0 未检测 1 不需要检测 2 检测通过 3检测失败", "typeDetail":"{\"odpsType\":\"BIGINT\",\"typeName\":\"BIGINT\"}", "type":"BIGINT" }, { "name":"view_count", "comment":"曝光次数", "typeDetail":"{\"odpsType\":\"BIGINT\",\"typeName\":\"BIGINT\"}", "type":"BIGINT" } ], "sourceTableColumn":[ { "columnType":"-5", "typeSize":"20", "nullable":"0", "name":"id", "comment":"", "type":"BIGINT", "primaryKey":"true" }, { "columnType":"-5", "typeSize":"20", "nullable":"0", "name":"video_id", "comment":"", "type":"BIGINT" }, { "columnType":"-5", "typeSize":"20", "nullable":"0", "name":"uid", "comment":"", "type":"BIGINT" }, { "columnType":"93", "typeSize":"19", "nullable":"1", "name":"gmt_create", "comment":"", "type":"DATETIME" }, { "columnType":"4", "typeSize":"4", "nullable":"0", "name":"app_type", "comment":"", "type":"INT" }, { "columnType":"4", "typeSize":"4", "nullable":"1", "name":"barrage_switch", "comment":"弹幕开关 1打开 -1关闭", "type":"INT" }, { "columnType":"4", "typeSize":"11", "nullable":"1", "name":"barrage_count", "comment":"弹幕数", "type":"INT" }, { "columnType":"4", "typeSize":"11", "nullable":"1", "name":"comment_count", "comment":"评论数", "type":"INT" }, { "columnType":"12", "typeSize":"500", "nullable":"1", "name":"share_image_path", "comment":"分享到微信会话的图片的宽高比为5:4底片的路径", "type":"VARCHAR" }, { "columnType":"12", "typeSize":"500", "nullable":"1", "name":"descr", "comment":"视频简介", "type":"VARCHAR" }, { "columnType":"12", "typeSize":"128", "nullable":"1", "name":"sample_request_id", "comment":"试看视频的转码任务请求ID", "type":"VARCHAR" }, { "columnType":"12", "typeSize":"128", "nullable":"1", "name":"sample_job_id", "comment":"试看视频的转码任务ID", "type":"VARCHAR" }, { "columnType":"4", "typeSize":"2", "nullable":"1", "name":"sample_transcode_status", "comment":"试看视频的转码任务状态(1:发送转码失败,2:转码中,3:转码完成,4:转码失败,5是不需要发送转码,此状态只针对于detail表而言)", "type":"INT" }, { "columnType":"12", "typeSize":"255", "nullable":"1", "name":"sample_transed_video_path", "comment":"试看视频的转码后的视频路径", "type":"VARCHAR" }, { "columnType":"4", "typeSize":"4", "nullable":"1", "name":"charge", "comment":"0 免费 1收费", "type":"INT" }, { "columnType":"-5", "typeSize":"20", "nullable":"1", "name":"price", "comment":"金额 单位 分", "type":"BIGINT" }, { "columnType":"4", "typeSize":"10", "nullable":"1", "name":"sample_total_time", "comment":"试看时长", "type":"INT" }, { "columnType":"93", "typeSize":"19", "nullable":"1", "name":"sample_transed_datetime", "comment":"试看视频转完码的时间点", "type":"DATETIME" }, { "columnType":"4", "typeSize":"4", "nullable":"1", "name":"allow_ios_play", "comment":"是否允许ios端播放,0不允许,1 允许", "type":"INT" }, { "columnType":"4", "typeSize":"10", "nullable":"1", "name":"pay_count", "comment":"支付过的人数", "type":"INT" }, { "columnType":"12", "typeSize":"100", "nullable":"1", "name":"cus_title", "comment":"自定义标题", "type":"VARCHAR" }, { "columnType":"12", "typeSize":"500", "nullable":"1", "name":"cus_desc", "comment":"自定义简介", "type":"VARCHAR" }, { "columnType":"4", "typeSize":"2", "nullable":"1", "name":"task_status", "comment":"0 未处理,1 已处理", "type":"INT" }, { "columnType":"4", "typeSize":"2", "nullable":"1", "name":"discern_status", "comment":"0 未检测 1 不需要检测 2 检测通过 3检测失败", "type":"INT" }, { "columnType":"-5", "typeSize":"20", "nullable":"1", "name":"view_count", "comment":"曝光次数", "type":"BIGINT" } ] }, "markConfig":{}, "type":"job", "version":"2.0", "steps":[ { "stepType":"mysql", "copies":1, "parameter":{ "envType":1, "datasource":"longvideo", "useSpecialSecret":false, "column":[ "id", "video_id", "uid", "gmt_create", "app_type", "barrage_switch", "barrage_count", "comment_count", "share_image_path", "descr", "sample_request_id", "sample_job_id", "sample_transcode_status", "sample_transed_video_path", "charge", "price", "sample_total_time", "sample_transed_datetime", "allow_ios_play", "pay_count", "cus_title", "cus_desc", "task_status", "discern_status", "view_count" ], "tableComment":"", "where":"", "connection":[ { "datasource":"longvideo", "table":[ "`wx_video_detail`" ] } ], "splitPk":"id" }, "name":"Reader", "gui":{ "x":100, "y":100 }, "category":"reader" }, { "stepType":"odps", "copies":1, "parameter":{ "truncate":true, "envType":1, "datasource":"odps_first", "tunnelQuota":"default", "isSupportThreeModel":false, "column":[ "id", "video_id", "uid", "gmt_create", "app_type", "barrage_switch", "barrage_count", "comment_count", "share_image_path", "descr", "sample_request_id", "sample_job_id", "sample_transcode_status", "sample_transed_video_path", "charge", "price", "sample_total_time", "sample_transed_datetime", "allow_ios_play", "pay_count", "cus_title", "cus_desc", "task_status", "discern_status", "view_count" ], "emptyAsNull":false, "tableComment":"视频详情表", "consistencyCommit":false, "table":"wx_video_detail" }, "name":"Writer", "gui":{ "x":100, "y":200 }, "category":"writer" } ], "order":{ "hops":[ { "from":"Reader", "gui":{ "sourceAnchor":1, "targetAnchor":0 }, "to":"Writer" } ] }, "setting":{ "errorLimit":{ "record":"" }, "locale":"zh", "speed":{ "throttle":false, "concurrent":2 } } } -- Task: imp.wx_video_detail.wx_video_detail ID: 1000416082 Type: DI { "extend":{ "mode":"wizard", "resourceGroup":"group_42901", "oneStopPageNum":2 }, "transform":false, "mappingRule":{ "sourceType":"mysql", "targetType":"odps", "needDiff":true, "targetTableColumn":[ { "name":"id", "comment":"", "typeDetail":"{\"odpsType\":\"BIGINT\",\"typeName\":\"BIGINT\"}", "type":"BIGINT" }, { "name":"video_id", "comment":"", "typeDetail":"{\"odpsType\":\"BIGINT\",\"typeName\":\"BIGINT\"}", "type":"BIGINT" }, { "name":"uid", "comment":"", "typeDetail":"{\"odpsType\":\"BIGINT\",\"typeName\":\"BIGINT\"}", "type":"BIGINT" }, { "name":"gmt_create", "comment":"", "typeDetail":"{\"odpsType\":\"DATETIME\",\"typeName\":\"DATETIME\"}", "type":"DATETIME" }, { "name":"app_type", "comment":"", "typeDetail":"{\"odpsType\":\"BIGINT\",\"typeName\":\"BIGINT\"}", "type":"BIGINT" }, { "name":"barrage_switch", "comment":"弹幕开关 1打开 -1关闭", "typeDetail":"{\"odpsType\":\"BIGINT\",\"typeName\":\"BIGINT\"}", "type":"BIGINT" }, { "name":"barrage_count", "comment":"弹幕数", "typeDetail":"{\"odpsType\":\"BIGINT\",\"typeName\":\"BIGINT\"}", "type":"BIGINT" }, { "name":"comment_count", "comment":"评论数", "typeDetail":"{\"odpsType\":\"BIGINT\",\"typeName\":\"BIGINT\"}", "type":"BIGINT" }, { "name":"share_image_path", "comment":"分享到微信会话的图片的宽高比为5:4底片的路径", "typeDetail":"{\"odpsType\":\"STRING\",\"typeName\":\"STRING\"}", "type":"STRING" }, { "name":"descr", "comment":"视频简介", "typeDetail":"{\"odpsType\":\"STRING\",\"typeName\":\"STRING\"}", "type":"STRING" }, { "name":"sample_request_id", "comment":"试看视频的转码任务请求id", "typeDetail":"{\"odpsType\":\"STRING\",\"typeName\":\"STRING\"}", "type":"STRING" }, { "name":"sample_job_id", "comment":"试看视频的转码任务id", "typeDetail":"{\"odpsType\":\"STRING\",\"typeName\":\"STRING\"}", "type":"STRING" }, { "name":"sample_transcode_status", "comment":"试看视频的转码任务状态(1:发送转码失败,2:转码中,3:转码完成,4:转码失败,5是不需要发送转码,此状态只针对于detail表而言)", "typeDetail":"{\"odpsType\":\"BIGINT\",\"typeName\":\"BIGINT\"}", "type":"BIGINT" }, { "name":"sample_transed_video_path", "comment":"试看视频的转码后的视频路径", "typeDetail":"{\"odpsType\":\"STRING\",\"typeName\":\"STRING\"}", "type":"STRING" }, { "name":"charge", "comment":"0 免费 1收费", "typeDetail":"{\"odpsType\":\"BIGINT\",\"typeName\":\"BIGINT\"}", "type":"BIGINT" }, { "name":"price", "comment":"金额 单位 分", "typeDetail":"{\"odpsType\":\"BIGINT\",\"typeName\":\"BIGINT\"}", "type":"BIGINT" }, { "name":"sample_total_time", "comment":"试看时长", "typeDetail":"{\"odpsType\":\"BIGINT\",\"typeName\":\"BIGINT\"}", "type":"BIGINT" }, { "name":"sample_transed_datetime", "comment":"试看视频转完码的时间点", "typeDetail":"{\"odpsType\":\"DATETIME\",\"typeName\":\"DATETIME\"}", "type":"DATETIME" }, { "name":"allow_ios_play", "comment":"是否允许ios端播放,0不允许,1 允许", "typeDetail":"{\"odpsType\":\"BIGINT\",\"typeName\":\"BIGINT\"}", "type":"BIGINT" }, { "name":"pay_count", "comment":"支付过的人数", "typeDetail":"{\"odpsType\":\"BIGINT\",\"typeName\":\"BIGINT\"}", "type":"BIGINT" }, { "name":"cus_title", "comment":"自定义标题", "typeDetail":"{\"odpsType\":\"STRING\",\"typeName\":\"STRING\"}", "type":"STRING" }, { "name":"cus_desc", "comment":"自定义简介", "typeDetail":"{\"odpsType\":\"STRING\",\"typeName\":\"STRING\"}", "type":"STRING" }, { "name":"task_status", "comment":"0 未处理,1 已处理", "typeDetail":"{\"odpsType\":\"BIGINT\",\"typeName\":\"BIGINT\"}", "type":"BIGINT" }, { "name":"discern_status", "comment":"0 未检测 1 不需要检测 2 检测通过 3检测失败", "typeDetail":"{\"odpsType\":\"BIGINT\",\"typeName\":\"BIGINT\"}", "type":"BIGINT" }, { "name":"view_count", "comment":"曝光次数", "typeDetail":"{\"odpsType\":\"BIGINT\",\"typeName\":\"BIGINT\"}", "type":"BIGINT" } ], "sourceTableColumn":[ { "columnType":"-5", "typeSize":"20", "nullable":"0", "name":"id", "comment":"", "type":"BIGINT", "primaryKey":"true" }, { "columnType":"-5", "typeSize":"20", "nullable":"0", "name":"video_id", "comment":"", "type":"BIGINT" }, { "columnType":"-5", "typeSize":"20", "nullable":"0", "name":"uid", "comment":"", "type":"BIGINT" }, { "columnType":"93", "typeSize":"19", "nullable":"1", "name":"gmt_create", "comment":"", "type":"DATETIME" }, { "columnType":"4", "typeSize":"4", "nullable":"0", "name":"app_type", "comment":"", "type":"INT" }, { "columnType":"4", "typeSize":"4", "nullable":"1", "name":"barrage_switch", "comment":"弹幕开关 1打开 -1关闭", "type":"INT" }, { "columnType":"4", "typeSize":"11", "nullable":"1", "name":"barrage_count", "comment":"弹幕数", "type":"INT" }, { "columnType":"4", "typeSize":"11", "nullable":"1", "name":"comment_count", "comment":"评论数", "type":"INT" }, { "columnType":"12", "typeSize":"500", "nullable":"1", "name":"share_image_path", "comment":"分享到微信会话的图片的宽高比为5:4底片的路径", "type":"VARCHAR" }, { "columnType":"12", "typeSize":"500", "nullable":"1", "name":"descr", "comment":"视频简介", "type":"VARCHAR" }, { "columnType":"12", "typeSize":"128", "nullable":"1", "name":"sample_request_id", "comment":"试看视频的转码任务请求ID", "type":"VARCHAR" }, { "columnType":"12", "typeSize":"128", "nullable":"1", "name":"sample_job_id", "comment":"试看视频的转码任务ID", "type":"VARCHAR" }, { "columnType":"4", "typeSize":"2", "nullable":"1", "name":"sample_transcode_status", "comment":"试看视频的转码任务状态(1:发送转码失败,2:转码中,3:转码完成,4:转码失败,5是不需要发送转码,此状态只针对于detail表而言)", "type":"INT" }, { "columnType":"12", "typeSize":"255", "nullable":"1", "name":"sample_transed_video_path", "comment":"试看视频的转码后的视频路径", "type":"VARCHAR" }, { "columnType":"4", "typeSize":"4", "nullable":"1", "name":"charge", "comment":"0 免费 1收费", "type":"INT" }, { "columnType":"-5", "typeSize":"20", "nullable":"1", "name":"price", "comment":"金额 单位 分", "type":"BIGINT" }, { "columnType":"4", "typeSize":"10", "nullable":"1", "name":"sample_total_time", "comment":"试看时长", "type":"INT" }, { "columnType":"93", "typeSize":"19", "nullable":"1", "name":"sample_transed_datetime", "comment":"试看视频转完码的时间点", "type":"DATETIME" }, { "columnType":"4", "typeSize":"4", "nullable":"1", "name":"allow_ios_play", "comment":"是否允许ios端播放,0不允许,1 允许", "type":"INT" }, { "columnType":"4", "typeSize":"10", "nullable":"1", "name":"pay_count", "comment":"支付过的人数", "type":"INT" }, { "columnType":"12", "typeSize":"100", "nullable":"1", "name":"cus_title", "comment":"自定义标题", "type":"VARCHAR" }, { "columnType":"12", "typeSize":"500", "nullable":"1", "name":"cus_desc", "comment":"自定义简介", "type":"VARCHAR" }, { "columnType":"4", "typeSize":"2", "nullable":"1", "name":"task_status", "comment":"0 未处理,1 已处理", "type":"INT" }, { "columnType":"4", "typeSize":"2", "nullable":"1", "name":"discern_status", "comment":"0 未检测 1 不需要检测 2 检测通过 3检测失败", "type":"INT" }, { "columnType":"-5", "typeSize":"20", "nullable":"1", "name":"view_count", "comment":"曝光次数", "type":"BIGINT" } ] }, "markConfig":{}, "type":"job", "version":"2.0", "steps":[ { "stepType":"mysql", "copies":1, "parameter":{ "envType":1, "datasource":"longvideo", "useSpecialSecret":false, "column":[ "id", "video_id", "uid", "gmt_create", "app_type", "barrage_switch", "barrage_count", "comment_count", "share_image_path", "descr", "sample_request_id", "sample_job_id", "sample_transcode_status", "sample_transed_video_path", "charge", "price", "sample_total_time", "sample_transed_datetime", "allow_ios_play", "pay_count", "cus_title", "cus_desc", "task_status", "discern_status", "view_count" ], "tableComment":"", "where":"", "connection":[ { "datasource":"longvideo", "table":[ "`wx_video_detail`" ] } ], "splitPk":"id" }, "name":"Reader", "gui":{ "x":100, "y":100 }, "category":"reader" }, { "stepType":"odps", "copies":1, "parameter":{ "truncate":true, "envType":1, "datasource":"odps_first", "tunnelQuota":"default", "isSupportThreeModel":false, "column":[ "id", "video_id", "uid", "gmt_create", "app_type", "barrage_switch", "barrage_count", "comment_count", "share_image_path", "descr", "sample_request_id", "sample_job_id", "sample_transcode_status", "sample_transed_video_path", "charge", "price", "sample_total_time", "sample_transed_datetime", "allow_ios_play", "pay_count", "cus_title", "cus_desc", "task_status", "discern_status", "view_count" ], "emptyAsNull":false, "tableComment":"视频详情表", "consistencyCommit":false, "table":"wx_video_detail" }, "name":"Writer", "gui":{ "x":100, "y":200 }, "category":"writer" } ], "order":{ "hops":[ { "from":"Reader", "gui":{ "sourceAnchor":1, "targetAnchor":0 }, "to":"Writer" } ] }, "setting":{ "errorLimit":{ "record":"" }, "locale":"zh", "speed":{ "throttle":false, "concurrent":2 } } }