data_analysis/production_code/videoods.flow_pool_level_video.sql

-- Task: flow_pool_level_video  ID: 1006748760  Type: DI
{
	"extend":{
		"mode":"wizard",
		"resourceGroup":"S_res_group_42901_1627548651694",
		"oneStopPageNum":2
	},
	"transform":false,
	"type":"job",
	"version":"2.0",
	"steps":[
		{
			"stepType":"mysql",
			"copies":1,
			"parameter":{
				"envType":1,
				"datasource":"flowpool",
				"useSpecialSecret":false,
				"column":[
					"id",
					"flow_pool_id",
					"flow_pool_level_id",
					"life_cycle_id",
					"video_id",
					"uid",
					"start_type",
					"end_type",
					"start_time",
					"end_time",
					"expire_time",
					"distribute_count",
					"view_count",
					"view_algo_count",
					"end_view_count",
					"play_count",
					"end_play_count",
					"real_play_count",
					"end_real_play_count",
					"back_flow",
					"end_back_flow",
					"share_friend_count",
					"data_status",
					"create_time",
					"update_time",
					"attribute"
				],
				"tableComment":"流量池分级下的视频",
				"where":"",
				"connection":[
					{
						"datasource":"flowpool",
						"table":[
							"flow_pool_level_video"
						]
					}
				],
				"splitPk":"id"
			},
			"name":"Reader",
			"gui":{
				"x":100,
				"y":100
			},
			"category":"reader"
		},
		{
			"stepType":"odps",
			"copies":1,
			"parameter":{
				"truncate":true,
				"envType":1,
				"datasource":"odps_first",
				"isSupportThreeModel":false,
				"tunnelQuota":"default",
				"column":[
					"id",
					"flow_pool_id",
					"flow_pool_level_id",
					"life_cycle_id",
					"video_id",
					"uid",
					"start_type",
					"end_type",
					"start_time",
					"end_time",
					"expire_time",
					"distribute_count",
					"view_count",
					"view_algo_count",
					"end_view_count",
					"play_count",
					"end_play_count",
					"real_play_count",
					"end_real_play_count",
					"back_flow",
					"end_back_flow",
					"share_friend_count",
					"data_status",
					"create_time",
					"update_time",
					"attribute"
				],
				"emptyAsNull":false,
				"tableComment":"流量池分级下的视频",
				"consistencyCommit":false,
				"table":"flow_pool_level_video"
			},
			"name":"Writer",
			"gui":{
				"x":100,
				"y":200
			},
			"category":"writer"
		},
		{
			"copies":1,
			"parameter":{
				"nodes":[],
				"edges":[],
				"groups":[],
				"version":"2.0"
			},
			"name":"Processor",
			"gui":{
				"x":100,
				"y":300
			},
			"category":"processor"
		}
	],
	"order":{
		"hops":[
			{
				"from":"Reader",
				"gui":{
					"sourceAnchor":1,
					"targetAnchor":0
				},
				"to":"Writer"
			}
		]
	},
	"setting":{
		"errorLimit":{
			"record":""
		},
		"locale":"zh_CN",
		"speed":{
			"throttle":false,
			"concurrent":2
		}
	}
}