data_analysis/production_code/videoods.wx_video_per1h.sql

-- Task: imp.wx_video.wx_video_per1h  ID: 1000625005  Type: DI
{
	"extend":{
		"mode":"code",
		"resourceGroup":"S_res_group_42901_1693906060735",
		"oneStopPageNum":2
	},
	"transform":false,
	"type":"job",
	"version":"2.0",
	"steps":[
		{
			"stepType":"mysql",
			"parameter":{
				"envType":1,
				"useSpecialSecret":false,
				"column":[
					"new_share_image_path",
					"is_foreogn_bucket",
					"sensitive_status",
					"stage_recommend_examine_status",
					"tag_count",
					"recommend_status",
					"video_collection_id",
					"code_name",
					"size",
					"content_md5",
					"examine_status",
					"file_extensions",
					"system",
					"status",
					"version",
					"gmt_modified_timestamp",
					"gmt_create_timestamp",
					"gmt_modified",
					"changed_by",
					"gmt_create",
					"transed_video_path",
					"job_id",
					"request_id",
					"transcode_done_datetime",
					"transcode_status",
					"bit_rate",
					"rotate",
					"total_time",
					"favoriteds",
					"share_count_friend_total",
					"share_count_friend",
					"reported_count",
					"share_count_total",
					"share_count",
					"play_count_total",
					"play_count",
					"cover_img_height",
					"cover_img_width",
					"height",
					"width",
					"qrimg_path",
					"share_moment_img_path",
					"self_cover_img_path",
					"cover_img_path",
					"video_path",
					"title",
					"uid",
					"id"
				],
				"tableComment":"",
				"where":"",
				"connection":[
					{
						"datasource":"longvide_read",
						"table":[
							"wx_video"
						]
					}
				],
				"splitPk":"id",
				"encoding":"UTF-8"
			},
			"name":"Reader",
			"category":"reader"
		},
		{
			"stepType":"odps",
			"parameter":{
				"partition":"",
				"truncate":true,
				"datasource":"odps_first",
				"envType":1,
				"tunnelQuota":"default",
				"isSupportThreeModel":false,
				"column":[
					"new_share_image_path",
					"is_foreogn_bucket",
					"sensitive_status",
					"stage_recommend_examine_status",
					"tag_count",
					"recommend_status",
					"video_collection_id",
					"code_name",
					"size",
					"content_md5",
					"examine_status",
					"file_extensions",
					"system",
					"status",
					"version",
					"gmt_modified_timestamp",
					"gmt_create_timestamp",
					"gmt_modified",
					"changed_by",
					"gmt_create",
					"transed_video_path",
					"job_id",
					"request_id",
					"transcode_done_datetime",
					"transcode_status",
					"bit_rate",
					"rotate",
					"total_time",
					"favoriteds",
					"share_count_friend_total",
					"share_count_friend",
					"reported_count",
					"share_count_total",
					"share_count",
					"play_count_total",
					"play_count",
					"cover_img_height",
					"cover_img_width",
					"height",
					"width",
					"qrimg_path",
					"share_moment_img_path",
					"self_cover_img_path",
					"cover_img_path",
					"video_path",
					"title",
					"uid",
					"id"
				],
				"emptyAsNull":false,
				"tableComment":"*",
				"table":"wx_video_per1h",
				"consistencyCommit":false
			},
			"name":"Writer",
			"category":"writer"
		}
	],
	"setting":{
		"jvmOption":"-Xms2048m -Xmx2048m",
		"errorLimit":{
			"record":""
		},
		"locale":"zh_CN",
		"speed":{
			"throttle":false,
			"concurrent":8
		}
	},
	"order":{
		"hops":[
			{
				"from":"Reader",
				"to":"Writer"
			}
		]
	}
}