data_analysis/production_code/videoods.wx_video_detail.sql

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