data_analysis/production_code/videoods.topic.sql

-- Task: imp.topic  ID: 1001894077  Type: DI
{
	"extend":{
		"mode":"wizard",
		"resourceGroup":"group_42901"
	},
	"transform":false,
	"type":"job",
	"version":"2.0",
	"steps":[
		{
			"stepType":"mysql",
			"copies":1,
			"parameter":{
				"envType":1,
				"column":[
					"id",
					"name",
					"introduction",
					"image_1_1_path",
					"image_16_9_path",
					"image_9_16_path",
					"audit_status",
					"is_participatory",
					"distribution_state",
					"create_uid",
					"hot_score",
					"participant_num",
					"data_status",
					"create_time",
					"update_time"
				],
				"tableComment":"社区-话题",
				"where":"",
				"connection":[
					{
						"datasource":"longvide_read",
						"table":[
							"topic"
						]
					}
				],
				"splitPk":"id"
			},
			"name":"Reader",
			"gui":{
				"x":100,
				"y":100
			},
			"category":"reader"
		},
		{
			"stepType":"odps",
			"copies":1,
			"parameter":{
				"truncate":true,
				"envType":1,
				"datasource":"odps_first",
				"column":[
					"id",
					"name",
					"introduction",
					"image_1_1_path",
					"image_16_9_path",
					"image_9_16_path",
					"audit_status",
					"is_participatory",
					"distribution_state",
					"create_uid",
					"hot_score",
					"participant_num",
					"data_status",
					"create_time",
					"update_time"
				],
				"emptyAsNull":false,
				"tableComment":"社区-话题",
				"table":"topic"
			},
			"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
		}
	}
}

-- Task: imp.topic  ID: 1001894077  Type: DI
{
	"extend":{
		"mode":"wizard",
		"resourceGroup":"group_42901"
	},
	"transform":false,
	"type":"job",
	"version":"2.0",
	"steps":[
		{
			"stepType":"mysql",
			"copies":1,
			"parameter":{
				"envType":1,
				"column":[
					"id",
					"name",
					"introduction",
					"image_1_1_path",
					"image_16_9_path",
					"image_9_16_path",
					"audit_status",
					"is_participatory",
					"distribution_state",
					"create_uid",
					"hot_score",
					"participant_num",
					"data_status",
					"create_time",
					"update_time"
				],
				"tableComment":"社区-话题",
				"where":"",
				"connection":[
					{
						"datasource":"longvide_read",
						"table":[
							"topic"
						]
					}
				],
				"splitPk":"id"
			},
			"name":"Reader",
			"gui":{
				"x":100,
				"y":100
			},
			"category":"reader"
		},
		{
			"stepType":"odps",
			"copies":1,
			"parameter":{
				"truncate":true,
				"envType":1,
				"datasource":"odps_first",
				"column":[
					"id",
					"name",
					"introduction",
					"image_1_1_path",
					"image_16_9_path",
					"image_9_16_path",
					"audit_status",
					"is_participatory",
					"distribution_state",
					"create_uid",
					"hot_score",
					"participant_num",
					"data_status",
					"create_time",
					"update_time"
				],
				"emptyAsNull":false,
				"tableComment":"社区-话题",
				"table":"topic"
			},
			"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
		}
	}
}