data_analysis/production_code/loghubods.changwen_rootsourceid_group_hour.sql

-- Task: changwen_rootsourceid_group_hour  ID: 1024546173  Type: DI
{
	"extend":{
		"mode":"wizard",
		"resourceGroup":"S_res_group_42901_1627548651694",
		"oneStopPageNum":2
	},
	"transform":false,
	"mappingRule":{
		"sourceType":"mysql",
		"targetType":"odps",
		"needDiff":true,
		"targetTableColumn":[
			{
				"name":"id",
				"comment":"自增主键",
				"typeDetail":"{\"odpsType\":\"BIGINT\",\"typeName\":\"BIGINT\"}",
				"type":"BIGINT"
			},
			{
				"name":"group_name",
				"comment":"分组名称",
				"typeDetail":"{\"odpsType\":\"STRING\",\"typeName\":\"STRING\"}",
				"type":"STRING"
			},
			{
				"name":"root_source_id",
				"comment":"",
				"typeDetail":"{\"odpsType\":\"STRING\",\"typeName\":\"STRING\"}",
				"type":"STRING"
			},
			{
				"name":"save_timestamp",
				"comment":"保存时候的时间，毫秒时间戳",
				"typeDetail":"{\"odpsType\":\"BIGINT\",\"typeName\":\"BIGINT\"}",
				"type":"BIGINT"
			}
		],
		"sourceTableColumn":[
			{
				"columnType":"-5",
				"typeSize":"20",
				"nullable":"0",
				"columnSize":"20",
				"name":"id",
				"comment":"自增主键",
				"newDigit":"0",
				"type":"BIGINT",
				"primaryKey":"true"
			},
			{
				"columnType":"12",
				"typeSize":"20",
				"nullable":"1",
				"columnSize":"20",
				"name":"group_name",
				"comment":"分组名称",
				"newDigit":"0",
				"type":"VARCHAR"
			},
			{
				"columnType":"12",
				"typeSize":"100",
				"nullable":"1",
				"columnSize":"100",
				"name":"root_source_id",
				"comment":"",
				"newDigit":"0",
				"type":"VARCHAR"
			},
			{
				"columnType":"-5",
				"typeSize":"20",
				"nullable":"1",
				"columnSize":"20",
				"name":"save_timestamp",
				"comment":"保存时候的时间，毫秒时间戳",
				"newDigit":"0",
				"type":"BIGINT"
			}
		]
	},
	"markConfig":{
		"columnMappingUseCustomRule":false
	},
	"type":"job",
	"version":"2.0",
	"steps":[
		{
			"stepType":"mysql",
			"copies":1,
			"parameter":{
				"envType":1,
				"datasource":"adplatform",
				"useSpecialSecret":false,
				"column":[
					"id",
					"group_name",
					"root_source_id",
					"save_timestamp"
				],
				"tableComment":"",
				"where":"",
				"connection":[
					{
						"datasource":"adplatform",
						"table":[
							"changwen_rootsourceid_group"
						]
					}
				],
				"splitPk":"id"
			},
			"name":"Reader",
			"gui":{
				"x":100,
				"y":100
			},
			"category":"reader"
		},
		{
			"stepType":"odps",
			"copies":1,
			"parameter":{
				"partition":"dt=${bizdate}${hh}",
				"truncate":true,
				"envType":1,
				"datasource":"odps_first",
				"tunnelQuota":"default",
				"isSupportThreeModel":false,
				"column":[
					"id",
					"group_name",
					"root_source_id",
					"save_timestamp"
				],
				"emptyAsNull":false,
				"tableComment":"",
				"consistencyCommit":false,
				"table":"changwen_rootsourceid_group_hour"
			},
			"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
		}
	}
}