https://console.volcengine.com/bi#/dataPrep/edit/1940?appId=1009125&taskType=0
{
"appId": 1009125,
"id": 1940,
"dagConf": {
"dag": {
"nodes": [
{
"key": "Read_asset_car_tob_pudongyongda_property_1603618594544",
"name": "意向评级标注",
"type": "Read",
"dataType": "hive",
"nodeStatus": "SUCCEEDED",
"connection": {
"dataSourceId": null,
"dataSourceType": "hive",
"contentType": null,
"path": null,
"host": null,
"port": null,
"user": null,
"password": null,
"catalogName": null,
"dbName": "aeolus",
"driverName": null,
"tableName": "asset_car_tob_pudongyongda_property",
"sql": null,
"partitions": [
"date=null"
],
"encryptMethod": 0,
"additionalParamsStr": null,
"jdbcConnectionString": null,
"shardNum": 0,
"chPartitionType": null,
"clusterName": "cn",
"shardColumn": null,
"bootstrapServers": null,
"topicName": null,
"groupId": null,
"checkpointLocation": null,
"displayTableName": null
},
"sampleJson": null,
"outputColumns": [
{
"name": "uid",
"type": "long",
"originType": "bigint",
"isSelect": false
},
{
"name": "gender",
"type": "string",
"originType": "string",
"isSelect": false
},
{
"name": "age",
"type": "string",
"originType": "string",
"isSelect": false
},
{
"name": "area",
"type": "string",
"originType": "string",
"isSelect": false
},
{
"name": "lifestage",
"type": "string",
"originType": "string",
"isSelect": false
},
{
"name": "education",
"type": "string",
"originType": "string",
"isSelect": false
},
{
"name": "job",
"type": "string",
"originType": "string",
"isSelect": false
},
{
"name": "birthday",
"type": "string",
"originType": "string",
"isSelect": false
},
{
"name": "lifecycle",
"type": "string",
"originType": "string",
"isSelect": false
},
{
"name": "own_store",
"type": "string",
"originType": "string",
"isSelect": false
},
{
"name": "own_sales",
"type": "string",
"originType": "string",
"isSelect": false
},
{
"name": "wanted_store",
"type": "string",
"originType": "string",
"isSelect": false
},
{
"name": "wanted_carmodel",
"type": "string",
"originType": "string",
"isSelect": false
},
{
"name": "rank",
"type": "string",
"originType": "string",
"isSelect": false
},
{
"name": "lasttime_pudongyongda_testdrive",
"type": "string",
"originType": "string",
"isSelect": false
},
{
"name": "newcar_tasting",
"type": "string",
"originType": "string",
"isSelect": false
},
{
"name": "storetimes_lastthreemonth",
"type": "string",
"originType": "string",
"isSelect": false
},
{
"name": "storenumbers_lastthreemonth",
"type": "string",
"originType": "string",
"isSelect": false
},
{
"name": "warranty_times",
"type": "int",
"originType": "int",
"isSelect": false
},
{
"name": "warranty_values",
"type": "string",
"originType": "string",
"isSelect": false
},
{
"name": "pudongyongda_noentry_time",
"type": "string",
"originType": "string",
"isSelect": false
},
{
"name": "forwardtimes_lastthreemonth",
"type": "string",
"originType": "string",
"isSelect": false
},
{
"name": "publishtimes_lastmonth",
"type": "string",
"originType": "string",
"isSelect": false
},
{
"name": "applets_opentimes_lastmonth",
"type": "int",
"originType": "int",
"isSelect": false
},
{
"name": "optionalpackpage_opentimes_lastmonth",
"type": "int",
"originType": "int",
"isSelect": false
},
{
"name": "optionalpackpage_time_lastmonth",
"type": "int",
"originType": "int",
"isSelect": false
},
{
"name": "last_eta",
"type": "int",
"originType": "int",
"isSelect": false
},
{
"name": "eta_modifytimes",
"type": "string",
"originType": "string",
"isSelect": false
},
{
"name": "pointuse_lastmonth",
"type": "string",
"originType": "string",
"isSelect": false
},
{
"name": "point_count",
"type": "string",
"originType": "string",
"isSelect": false
},
{
"name": "active_lasttime",
"type": "string",
"originType": "string",
"isSelect": false
},
{
"name": "contact_preference",
"type": "string",
"originType": "string",
"isSelect": false
},
{
"name": "gift_preference",
"type": "string",
"originType": "string",
"isSelect": false
},
{
"name": "carowner",
"type": "string",
"originType": "string",
"isSelect": false
},
{
"name": "salescarmodel",
"type": "string",
"originType": "string",
"isSelect": false
},
{
"name": "salestime",
"type": "string",
"originType": "string",
"isSelect": false
},
{
"name": "carownerappvisit",
"type": "string",
"originType": "string",
"isSelect": false
},
{
"name": "othercarmodel",
"type": "string",
"originType": "string",
"isSelect": false
},
{
"name": "interest_car_price",
"type": "string",
"originType": "string",
"isSelect": false
},
{
"name": "interest_car_brand_country",
"type": "string",
"originType": "string",
"isSelect": false
},
{
"name": "interest_car_brand",
"type": "string",
"originType": "string",
"isSelect": false
},
{
"name": "interest_car_other_series_type",
"type": "string",
"originType": "string",
"isSelect": false
},
{
"name": "interest_car_newenergy_type",
"type": "string",
"originType": "string",
"isSelect": false
},
{
"name": "client_stage",
"type": "string",
"originType": "string",
"isSelect": false
},
{
"name": "channel",
"type": "string",
"originType": "string",
"isSelect": false
},
{
"name": "community_pv_lastweek",
"type": "int",
"originType": "int",
"isSelect": false
},
{
"name": "community_creation_lastweek",
"type": "int",
"originType": "int",
"isSelect": false
},
{
"name": "community_forward_lastweek",
"type": "int",
"originType": "int",
"isSelect": false
},
{
"name": "community_recruit_lastweek",
"type": "int",
"originType": "int",
"isSelect": false
},
{
"name": "car_optical_pack_eagerness",
"type": "string",
"originType": "string",
"isSelect": false
},
{
"name": "car_pick_up_eagerness",
"type": "string",
"originType": "string",
"isSelect": false
},
{
"name": "returned_customer",
"type": "string",
"originType": "string",
"isSelect": false
},
{
"name": "car_price_comparison",
"type": "string",
"originType": "string",
"isSelect": false
},
{
"name": "stored_many_points",
"type": "string",
"originType": "string",
"isSelect": false
},
{
"name": "club_freshman",
"type": "string",
"originType": "string",
"isSelect": false
},
{
"name": "recall_values",
"type": "string",
"originType": "string",
"isSelect": false
},
{
"name": "date",
"type": "string",
"originType": "string",
"isSelect": false
}
],
"operators": {
"filters": {
"logic": true,
"children": [
{
"type": "string",
"operator": "=",
"operand": [
{
"name": "date"
},
{
"type": "string",
"value": "20201020"
}
],
"children": []
}
]
}
},
"params": {
"extractType": "{"key":"full"}",
"readNum": "{"key":"all"}"
},
"advanceSettings": []
},
{
"key": "reset_column_1603681051791",
"name": "字段设置",
"type": "Reset",
"dataType": "Column",
"nodeStatus": "SUCCEEDED",
"operators": {
"fields": [
{
"name": "uid",
"originType": "long",
"alias": "uid",
"type": "long",
"isSelect": true
},
{
"name": "gender",
"originType": "string",
"alias": "gender",
"type": "string",
"isSelect": true
},
{
"name": "age",
"originType": "string",
"alias": "age",
"type": "string",
"isSelect": true
},
{
"name": "area",
"originType": "string",
"alias": "area",
"type": "string",
"isSelect": true
},
{
"name": "lifestage",
"originType": "string",
"alias": "lifestage",
"type": "string",
"isSelect": true
},
{
"name": "education",
"originType": "string",
"alias": "education",
"type": "string",
"isSelect": true
},
{
"name": "job",
"originType": "string",
"alias": "job",
"type": "string",
"isSelect": true
},
{
"name": "birthday",
"originType": "double",
"alias": "birthday",
"type": "double",
"isSelect": true
},
{
"name": "lifecycle",
"originType": "string",
"alias": "lifecycle",
"type": "string",
"isSelect": true
},
{
"name": "own_store",
"originType": "string",
"alias": "own_store",
"type": "string",
"isSelect": true
},
{
"name": "own_sales",
"originType": "string",
"alias": "own_sales",
"type": "string",
"isSelect": true
},
{
"name": "wanted_store",
"originType": "string",
"alias": "wanted_store",
"type": "string",
"isSelect": true
},
{
"name": "wanted_carmodel",
"originType": "string",
"alias": "wanted_carmodel",
"type": "string",
"isSelect": true
},
{
"name": "rank",
"originType": "string",
"alias": "rank",
"type": "string",
"isSelect": true
},
{
"name": "lasttime_pudongyongda_testdrive",
"originType": "string",
"alias": "lasttime_pudongyongda_testdrive",
"type": "string",
"isSelect": true
},
{
"name": "newcar_tasting",
"originType": "string",
"alias": "newcar_tasting",
"type": "string",
"isSelect": true
},
{
"name": "storetimes_lastthreemonth",
"originType": "string",
"alias": "storetimes_lastthreemonth",
"type": "string",
"isSelect": true
},
{
"name": "storenumbers_lastthreemonth",
"originType": "string",
"alias": "storenumbers_lastthreemonth",
"type": "string",
"isSelect": true
},
{
"name": "warranty_times",
"originType": "double",
"alias": "warranty_times",
"type": "double",
"isSelect": true
},
{
"name": "warranty_values",
"originType": "double",
"alias": "warranty_values",
"type": "double",
"isSelect": true
},
{
"name": "pudongyongda_noentry_time",
"originType": "string",
"alias": "pudongyongda_noentry_time",
"type": "string",
"isSelect": true
},
{
"name": "forwardtimes_lastthreemonth",
"originType": "string",
"alias": "forwardtimes_lastthreemonth",
"type": "string",
"isSelect": true
},
{
"name": "publishtimes_lastmonth",
"originType": "string",
"alias": "publishtimes_lastmonth",
"type": "string",
"isSelect": true
},
{
"name": "applets_opentimes_lastmonth",
"originType": "int",
"alias": "applets_opentimes_lastmonth",
"type": "int",
"isSelect": true
},
{
"name": "optionalpackpage_opentimes_lastmonth",
"originType": "int",
"alias": "optionalpackpage_opentimes_lastmonth",
"type": "int",
"isSelect": true
},
{
"name": "optionalpackpage_time_lastmonth",
"originType": "int",
"alias": "optionalpackpage_time_lastmonth",
"type": "int",
"isSelect": true
},
{
"name": "last_eta",
"originType": "int",
"alias": "last_eta",
"type": "int",
"isSelect": true
},
{
"name": "eta_modifytimes",
"originType": "string",
"alias": "eta_modifytimes",
"type": "string",
"isSelect": true
},
{
"name": "pointuse_lastmonth",
"originType": "string",
"alias": "pointuse_lastmonth",
"type": "string",
"isSelect": true
},
{
"name": "point_count",
"originType": "string",
"alias": "point_count",
"type": "string",
"isSelect": true
},
{
"name": "active_lasttime",
"originType": "string",
"alias": "active_lasttime",
"type": "string",
"isSelect": true
},
{
"name": "contact_preference",
"originType": "string",
"alias": "contact_preference",
"type": "string",
"isSelect": true
},
{
"name": "gift_preference",
"originType": "string",
"alias": "gift_preference",
"type": "string",
"isSelect": true
},
{
"name": "carowner",
"originType": "string",
"alias": "carowner",
"type": "string",
"isSelect": true
},
{
"name": "salescarmodel",
"originType": "string",
"alias": "salescarmodel",
"type": "string",
"isSelect": true
},
{
"name": "salestime",
"originType": "string",
"alias": "salestime",
"type": "string",
"isSelect": true
},
{
"name": "carownerappvisit",
"originType": "string",
"alias": "carownerappvisit",
"type": "string",
"isSelect": true
},
{
"name": "othercarmodel",
"originType": "string",
"alias": "othercarmodel",
"type": "string",
"isSelect": true
},
{
"name": "interest_car_price",
"originType": "string",
"alias": "interest_car_price",
"type": "string",
"isSelect": true
},
{
"name": "interest_car_brand_country",
"originType": "string",
"alias": "interest_car_brand_country",
"type": "string",
"isSelect": true
},
{
"name": "interest_car_brand",
"originType": "string",
"alias": "interest_car_brand",
"type": "string",
"isSelect": true
},
{
"name": "interest_car_other_series_type",
"originType": "string",
"alias": "interest_car_other_series_type",
"type": "string",
"isSelect": true
},
{
"name": "interest_car_newenergy_type",
"originType": "string",
"alias": "interest_car_newenergy_type",
"type": "string",
"isSelect": true
},
{
"name": "client_stage",
"originType": "string",
"alias": "client_stage",
"type": "string",
"isSelect": true
},
{
"name": "channel",
"originType": "string",
"alias": "channel",
"type": "string",
"isSelect": true
},
{
"name": "community_pv_lastweek",
"originType": "int",
"alias": "community_pv_lastweek",
"type": "int",
"isSelect": true
},
{
"name": "community_creation_lastweek",
"originType": "int",
"alias": "community_creation_lastweek",
"type": "int",
"isSelect": true
},
{
"name": "community_forward_lastweek",
"originType": "int",
"alias": "community_forward_lastweek",
"type": "int",
"isSelect": true
},
{
"name": "community_recruit_lastweek",
"originType": "int",
"alias": "community_recruit_lastweek",
"type": "int",
"isSelect": true
},
{
"name": "car_optical_pack_eagerness",
"originType": "string",
"alias": "car_optical_pack_eagerness",
"type": "string",
"isSelect": true
},
{
"name": "car_pick_up_eagerness",
"originType": "string",
"alias": "car_pick_up_eagerness",
"type": "string",
"isSelect": true
},
{
"name": "returned_customer",
"originType": "string",
"alias": "returned_customer",
"type": "string",
"isSelect": true
},
{
"name": "car_price_comparison",
"originType": "string",
"alias": "car_price_comparison",
"type": "string",
"isSelect": true
},
{
"name": "stored_many_points",
"originType": "string",
"alias": "stored_many_points",
"type": "string",
"isSelect": true
},
{
"name": "club_freshman",
"originType": "string",
"alias": "club_freshman",
"type": "string",
"isSelect": true
},
{
"name": "recall_values",
"originType": "string",
"alias": "recall_values",
"type": "string",
"isSelect": true
},
{
"name": "date",
"originType": "string",
"alias": "date",
"type": "string",
"isSelect": true
}
],
"condition": ""
}
},
{
"key": "Read_A111111_1635927769820",
"name": "A111111",
"type": "Read",
"dataType": "hive",
"nodeStatus": "SUCCEEDED",
"connection": {
"clusterName": "cn",
"path": "",
"dbName": "aeolus",
"tableName": "A111111",
"displayTableName": "A111111",
"partitions": [
"uid=${date}"
]
},
"outputColumns": [
{
"name": "gender",
"type": "string",
"originPrepType": "string",
"originType": "string",
"isSelect": true
},
{
"name": "age",
"type": "string",
"originPrepType": "string",
"originType": "string",
"isSelect": true
},
{
"name": "area",
"type": "string",
"originPrepType": "string",
"originType": "string",
"isSelect": true
},
{
"name": "lifestage",
"type": "string",
"originPrepType": "string",
"originType": "string",
"isSelect": true
},
{
"name": "education",
"type": "string",
"originPrepType": "string",
"originType": "string",
"isSelect": true
},
{
"name": "job",
"type": "string",
"originPrepType": "string",
"originType": "string",
"isSelect": true
},
{
"name": "birthday",
"type": "string",
"originPrepType": "string",
"originType": "string",
"isSelect": true
},
{
"name": "lifecycle",
"type": "string",
"originPrepType": "string",
"originType": "string",
"isSelect": true
},
{
"name": "own_store",
"type": "string",
"originPrepType": "string",
"originType": "string",
"isSelect": true
},
{
"name": "own_sales",
"type": "string",
"originPrepType": "string",
"originType": "string",
"isSelect": true
},
{
"name": "wanted_store",
"type": "string",
"originPrepType": "string",
"originType": "string",
"isSelect": true
},
{
"name": "wanted_carmodel",
"type": "string",
"originPrepType": "string",
"originType": "string",
"isSelect": true
},
{
"name": "rank",
"type": "string",
"originPrepType": "string",
"originType": "string",
"isSelect": true
},
{
"name": "lasttime_pudongyongda_testdrive",
"type": "string",
"originPrepType": "string",
"originType": "string",
"isSelect": true
},
{
"name": "newcar_tasting",
"type": "string",
"originPrepType": "string",
"originType": "string",
"isSelect": true
},
{
"name": "storetimes_lastthreemonth",
"type": "string",
"originPrepType": "string",
"originType": "string",
"isSelect": true
},
{
"name": "storenumbers_lastthreemonth",
"type": "string",
"originPrepType": "string",
"originType": "string",
"isSelect": true
},
{
"name": "warranty_times",
"type": "int",
"originPrepType": "int",
"originType": "int",
"isSelect": true
},
{
"name": "warranty_values",
"type": "string",
"originPrepType": "string",
"originType": "string",
"isSelect": true
},
{
"name": "pudongyongda_noentry_time",
"type": "string",
"originPrepType": "string",
"originType": "string",
"isSelect": true
},
{
"name": "forwardtimes_lastthreemonth",
"type": "string",
"originPrepType": "string",
"originType": "string",
"isSelect": true
},
{
"name": "publishtimes_lastmonth",
"type": "string",
"originPrepType": "string",
"originType": "string",
"isSelect": true
},
{
"name": "applets_opentimes_lastmonth",
"type": "int",
"originPrepType": "int",
"originType": "int",
"isSelect": true
},
{
"name": "optionalpackpage_opentimes_lastmonth",
"type": "int",
"originPrepType": "int",
"originType": "int",
"isSelect": true
},
{
"name": "optionalpackpage_time_lastmonth",
"type": "int",
"originPrepType": "int",
"originType": "int",
"isSelect": true
},
{
"name": "last_eta",
"type": "int",
"originPrepType": "int",
"originType": "int",
"isSelect": true
},
{
"name": "eta_modifytimes",
"type": "string",
"originPrepType": "string",
"originType": "string",
"isSelect": true
},
{
"name": "pointuse_lastmonth",
"type": "string",
"originPrepType": "string",
"originType": "string",
"isSelect": true
},
{
"name": "point_count",
"type": "string",
"originPrepType": "string",
"originType": "string",
"isSelect": true
},
{
"name": "active_lasttime",
"type": "string",
"originPrepType": "string",
"originType": "string",
"isSelect": true
},
{
"name": "contact_preference",
"type": "string",
"originPrepType": "string",
"originType": "string",
"isSelect": true
},
{
"name": "gift_preference",
"type": "string",
"originPrepType": "string",
"originType": "string",
"isSelect": true
},
{
"name": "carowner",
"type": "string",
"originPrepType": "string",
"originType": "string",
"isSelect": true
},
{
"name": "salescarmodel",
"type": "string",
"originPrepType": "string",
"originType": "string",
"isSelect": true
},
{
"name": "salestime",
"type": "string",
"originPrepType": "string",
"originType": "string",
"isSelect": true
},
{
"name": "carownerappvisit",
"type": "string",
"originPrepType": "string",
"originType": "string",
"isSelect": true
},
{
"name": "othercarmodel",
"type": "string",
"originPrepType": "string",
"originType": "string",
"isSelect": true
},
{
"name": "interest_car_price",
"type": "string",
"originPrepType": "string",
"originType": "string",
"isSelect": true
},
{
"name": "interest_car_brand_country",
"type": "string",
"originPrepType": "string",
"originType": "string",
"isSelect": true
},
{
"name": "interest_car_brand",
"type": "string",
"originPrepType": "string",
"originType": "string",
"isSelect": true
},
{
"name": "interest_car_other_series_type",
"type": "string",
"originPrepType": "string",
"originType": "string",
"isSelect": true
},
{
"name": "interest_car_newenergy_type",
"type": "string",
"originPrepType": "string",
"originType": "string",
"isSelect": true
},
{
"name": "client_stage",
"type": "string",
"originPrepType": "string",
"originType": "string",
"isSelect": true
},
{
"name": "channel",
"type": "string",
"originPrepType": "string",
"originType": "string",
"isSelect": true
},
{
"name": "community_pv_lastweek",
"type": "int",
"originPrepType": "int",
"originType": "int",
"isSelect": true
},
{
"name": "community_creation_lastweek",
"type": "int",
"originPrepType": "int",
"originType": "int",
"isSelect": true
},
{
"name": "community_forward_lastweek",
"type": "int",
"originPrepType": "int",
"originType": "int",
"isSelect": true
},
{
"name": "community_recruit_lastweek",
"type": "int",
"originPrepType": "int",
"originType": "int",
"isSelect": true
},
{
"name": "car_optical_pack_eagerness",
"type": "string",
"originPrepType": "string",
"originType": "string",
"isSelect": true
},
{
"name": "car_pick_up_eagerness",
"type": "string",
"originPrepType": "string",
"originType": "string",
"isSelect": true
},
{
"name": "returned_customer",
"type": "string",
"originPrepType": "string",
"originType": "string",
"isSelect": true
},
{
"name": "car_price_comparison",
"type": "string",
"originPrepType": "string",
"originType": "string",
"isSelect": true
},
{
"name": "stored_many_points",
"type": "string",
"originPrepType": "string",
"originType": "string",
"isSelect": true
},
{
"name": "club_freshman",
"type": "string",
"originPrepType": "string",
"originType": "string",
"isSelect": true
},
{
"name": "recall_values",
"type": "string",
"originPrepType": "string",
"originType": "string",
"isSelect": true
},
{
"name": "date",
"type": "string",
"originPrepType": "string",
"originType": "string",
"isSelect": true
},
{
"name": "uid",
"type": "long",
"originPrepType": "long",
"originType": "bigint",
"isSelect": true
}
],
"operators": {
"filters": {
"logic": true,
"children": [
{
"type": "long",
"operator": "",
"operand": [
{
"name": "uid"
}
]
}
]
}
},
"params": {
"extractType": "{"key":"full"}",
"readNum": "{"key":"sample","value":"10000"}"
}
},
{
"key": "SparkJoinOperator_1635927787704",
"name": "连接_1",
"type": "SparkJoinOperator",
"dataType": "left",
"params": {
"joinType": "left",
"joinFieldMatchType": "auto"
},
"nodeStatus": "SUCCEEDED",
"operators": {
"joinNodes": [
"Read_asset_car_tob_pudongyongda_property_1603618594544",
"Read_A111111_1635927769820"
],
"filters": {
"logic": true,
"children": [
{
"operator": "=",
"operand": [
{
"namespace": "Read_asset_car_tob_pudongyongda_property_1603618594544",
"name": "uid",
"type": "long",
"tableType": "left"
},
{
"namespace": "Read_A111111_1635927769820",
"name": "uid",
"type": "long",
"tableType": "right"
}
]
},
{
"operator": "=",
"operand": [
{
"namespace": "Read_asset_car_tob_pudongyongda_property_1603618594544",
"name": "gender",
"type": "string",
"tableType": "left"
},
{
"namespace": "Read_A111111_1635927769820",
"name": "gender",
"type": "string",
"tableType": "right"
}
]
},
{
"operator": "=",
"operand": [
{
"namespace": "Read_asset_car_tob_pudongyongda_property_1603618594544",
"name": "age",
"type": "string",
"tableType": "left"
},
{
"namespace": "Read_A111111_1635927769820",
"name": "age",
"type": "string",
"tableType": "right"
}
]
},
{
"operator": "=",
"operand": [
{
"namespace": "Read_asset_car_tob_pudongyongda_property_1603618594544",
"name": "area",
"type": "string",
"tableType": "left"
},
{
"namespace": "Read_A111111_1635927769820",
"name": "area",
"type": "string",
"tableType": "right"
}
]
},
{
"operator": "=",
"operand": [
{
"namespace": "Read_asset_car_tob_pudongyongda_property_1603618594544",
"name": "lifestage",
"type": "string",
"tableType": "left"
},
{
"namespace": "Read_A111111_1635927769820",
"name": "lifestage",
"type": "string",
"tableType": "right"
}
]
},
{
"operator": "=",
"operand": [
{
"namespace": "Read_asset_car_tob_pudongyongda_property_1603618594544",
"name": "education",
"type": "string",
"tableType": "left"
},
{
"namespace": "Read_A111111_1635927769820",
"name": "education",
"type": "string",
"tableType": "right"
}
]
},
{
"operator": "=",
"operand": [
{
"namespace": "Read_asset_car_tob_pudongyongda_property_1603618594544",
"name": "job",
"type": "string",
"tableType": "left"
},
{
"namespace": "Read_A111111_1635927769820",
"name": "job",
"type": "string",
"tableType": "right"
}
]
},
{
"operator": "=",
"operand": [
{
"namespace": "Read_asset_car_tob_pudongyongda_property_1603618594544",
"name": "birthday",
"type": "string",
"tableType": "left"
},
{
"namespace": "Read_A111111_1635927769820",
"name": "birthday",
"type": "string",
"tableType": "right"
}
]
},
{
"operator": "=",
"operand": [
{
"namespace": "Read_asset_car_tob_pudongyongda_property_1603618594544",
"name": "lifecycle",
"type": "string",
"tableType": "left"
},
{
"namespace": "Read_A111111_1635927769820",
"name": "lifecycle",
"type": "string",
"tableType": "right"
}
]
},
{
"operator": "=",
"operand": [
{
"namespace": "Read_asset_car_tob_pudongyongda_property_1603618594544",
"name": "own_store",
"type": "string",
"tableType": "left"
},
{
"namespace": "Read_A111111_1635927769820",
"name": "own_store",
"type": "string",
"tableType": "right"
}
]
},
{
"operator": "=",
"operand": [
{
"namespace": "Read_asset_car_tob_pudongyongda_property_1603618594544",
"name": "own_sales",
"type": "string",
"tableType": "left"
},
{
"namespace": "Read_A111111_1635927769820",
"name": "own_sales",
"type": "string",
"tableType": "right"
}
]
},
{
"operator": "=",
"operand": [
{
"namespace": "Read_asset_car_tob_pudongyongda_property_1603618594544",
"name": "wanted_store",
"type": "string",
"tableType": "left"
},
{
"namespace": "Read_A111111_1635927769820",
"name": "wanted_store",
"type": "string",
"tableType": "right"
}
]
},
{
"operator": "=",
"operand": [
{
"namespace": "Read_asset_car_tob_pudongyongda_property_1603618594544",
"name": "wanted_carmodel",
"type": "string",
"tableType": "left"
},
{
"namespace": "Read_A111111_1635927769820",
"name": "wanted_carmodel",
"type": "string",
"tableType": "right"
}
]
},
{
"operator": "=",
"operand": [
{
"namespace": "Read_asset_car_tob_pudongyongda_property_1603618594544",
"name": "rank",
"type": "string",
"tableType": "left"
},
{
"namespace": "Read_A111111_1635927769820",
"name": "rank",
"type": "string",
"tableType": "right"
}
]
},
{
"operator": "=",
"operand": [
{
"namespace": "Read_asset_car_tob_pudongyongda_property_1603618594544",
"name": "lasttime_pudongyongda_testdrive",
"type": "string",
"tableType": "left"
},
{
"namespace": "Read_A111111_1635927769820",
"name": "lasttime_pudongyongda_testdrive",
"type": "string",
"tableType": "right"
}
]
},
{
"operator": "=",
"operand": [
{
"namespace": "Read_asset_car_tob_pudongyongda_property_1603618594544",
"name": "newcar_tasting",
"type": "string",
"tableType": "left"
},
{
"namespace": "Read_A111111_1635927769820",
"name": "newcar_tasting",
"type": "string",
"tableType": "right"
}
]
},
{
"operator": "=",
"operand": [
{
"namespace": "Read_asset_car_tob_pudongyongda_property_1603618594544",
"name": "storetimes_lastthreemonth",
"type": "string",
"tableType": "left"
},
{
"namespace": "Read_A111111_1635927769820",
"name": "storetimes_lastthreemonth",
"type": "string",
"tableType": "right"
}
]
},
{
"operator": "=",
"operand": [
{
"namespace": "Read_asset_car_tob_pudongyongda_property_1603618594544",
"name": "storenumbers_lastthreemonth",
"type": "string",
"tableType": "left"
},
{
"namespace": "Read_A111111_1635927769820",
"name": "storenumbers_lastthreemonth",
"type": "string",
"tableType": "right"
}
]
},
{
"operator": "=",
"operand": [
{
"namespace": "Read_asset_car_tob_pudongyongda_property_1603618594544",
"name": "warranty_times",
"type": "int",
"tableType": "left"
},
{
"namespace": "Read_A111111_1635927769820",
"name": "warranty_times",
"type": "int",
"tableType": "right"
}
]
},
{
"operator": "=",
"operand": [
{
"namespace": "Read_asset_car_tob_pudongyongda_property_1603618594544",
"name": "warranty_values",
"type": "string",
"tableType": "left"
},
{
"namespace": "Read_A111111_1635927769820",
"name": "warranty_values",
"type": "string",
"tableType": "right"
}
]
},
{
"operator": "=",
"operand": [
{
"namespace": "Read_asset_car_tob_pudongyongda_property_1603618594544",
"name": "pudongyongda_noentry_time",
"type": "string",
"tableType": "left"
},
{
"namespace": "Read_A111111_1635927769820",
"name": "pudongyongda_noentry_time",
"type": "string",
"tableType": "right"
}
]
},
{
"operator": "=",
"operand": [
{
"namespace": "Read_asset_car_tob_pudongyongda_property_1603618594544",
"name": "forwardtimes_lastthreemonth",
"type": "string",
"tableType": "left"
},
{
"namespace": "Read_A111111_1635927769820",
"name": "forwardtimes_lastthreemonth",
"type": "string",
"tableType": "right"
}
]
},
{
"operator": "=",
"operand": [
{
"namespace": "Read_asset_car_tob_pudongyongda_property_1603618594544",
"name": "publishtimes_lastmonth",
"type": "string",
"tableType": "left"
},
{
"namespace": "Read_A111111_1635927769820",
"name": "publishtimes_lastmonth",
"type": "string",
"tableType": "right"
}
]
},
{
"operator": "=",
"operand": [
{
"namespace": "Read_asset_car_tob_pudongyongda_property_1603618594544",
"name": "applets_opentimes_lastmonth",
"type": "int",
"tableType": "left"
},
{
"namespace": "Read_A111111_1635927769820",
"name": "applets_opentimes_lastmonth",
"type": "int",
"tableType": "right"
}
]
},
{
"operator": "=",
"operand": [
{
"namespace": "Read_asset_car_tob_pudongyongda_property_1603618594544",
"name": "optionalpackpage_opentimes_lastmonth",
"type": "int",
"tableType": "left"
},
{
"namespace": "Read_A111111_1635927769820",
"name": "optionalpackpage_opentimes_lastmonth",
"type": "int",
"tableType": "right"
}
]
},
{
"operator": "=",
"operand": [
{
"namespace": "Read_asset_car_tob_pudongyongda_property_1603618594544",
"name": "optionalpackpage_time_lastmonth",
"type": "int",
"tableType": "left"
},
{
"namespace": "Read_A111111_1635927769820",
"name": "optionalpackpage_time_lastmonth",
"type": "int",
"tableType": "right"
}
]
},
{
"operator": "=",
"operand": [
{
"namespace": "Read_asset_car_tob_pudongyongda_property_1603618594544",
"name": "last_eta",
"type": "int",
"tableType": "left"
},
{
"namespace": "Read_A111111_1635927769820",
"name": "last_eta",
"type": "int",
"tableType": "right"
}
]
},
{
"operator": "=",
"operand": [
{
"namespace": "Read_asset_car_tob_pudongyongda_property_1603618594544",
"name": "eta_modifytimes",
"type": "string",
"tableType": "left"
},
{
"namespace": "Read_A111111_1635927769820",
"name": "eta_modifytimes",
"type": "string",
"tableType": "right"
}
]
},
{
"operator": "=",
"operand": [
{
"namespace": "Read_asset_car_tob_pudongyongda_property_1603618594544",
"name": "pointuse_lastmonth",
"type": "string",
"tableType": "left"
},
{
"namespace": "Read_A111111_1635927769820",
"name": "pointuse_lastmonth",
"type": "string",
"tableType": "right"
}
]
},
{
"operator": "=",
"operand": [
{
"namespace": "Read_asset_car_tob_pudongyongda_property_1603618594544",
"name": "point_count",
"type": "string",
"tableType": "left"
},
{
"namespace": "Read_A111111_1635927769820",
"name": "point_count",
"type": "string",
"tableType": "right"
}
]
},
{
"operator": "=",
"operand": [
{
"namespace": "Read_asset_car_tob_pudongyongda_property_1603618594544",
"name": "active_lasttime",
"type": "string",
"tableType": "left"
},
{
"namespace": "Read_A111111_1635927769820",
"name": "active_lasttime",
"type": "string",
"tableType": "right"
}
]
},
{
"operator": "=",
"operand": [
{
"namespace": "Read_asset_car_tob_pudongyongda_property_1603618594544",
"name": "contact_preference",
"type": "string",
"tableType": "left"
},
{
"namespace": "Read_A111111_1635927769820",
"name": "contact_preference",
"type": "string",
"tableType": "right"
}
]
},
{
"operator": "=",
"operand": [
{
"namespace": "Read_asset_car_tob_pudongyongda_property_1603618594544",
"name": "gift_preference",
"type": "string",
"tableType": "left"
},
{
"namespace": "Read_A111111_1635927769820",
"name": "gift_preference",
"type": "string",
"tableType": "right"
}
]
},
{
"operator": "=",
"operand": [
{
"namespace": "Read_asset_car_tob_pudongyongda_property_1603618594544",
"name": "carowner",
"type": "string",
"tableType": "left"
},
{
"namespace": "Read_A111111_1635927769820",
"name": "carowner",
"type": "string",
"tableType": "right"
}
]
},
{
"operator": "=",
"operand": [
{
"namespace": "Read_asset_car_tob_pudongyongda_property_1603618594544",
"name": "salescarmodel",
"type": "string",
"tableType": "left"
},
{
"namespace": "Read_A111111_1635927769820",
"name": "salescarmodel",
"type": "string",
"tableType": "right"
}
]
},
{
"operator": "=",
"operand": [
{
"namespace": "Read_asset_car_tob_pudongyongda_property_1603618594544",
"name": "salestime",
"type": "string",
"tableType": "left"
},
{
"namespace": "Read_A111111_1635927769820",
"name": "salestime",
"type": "string",
"tableType": "right"
}
]
},
{
"operator": "=",
"operand": [
{
"namespace": "Read_asset_car_tob_pudongyongda_property_1603618594544",
"name": "carownerappvisit",
"type": "string",
"tableType": "left"
},
{
"namespace": "Read_A111111_1635927769820",
"name": "carownerappvisit",
"type": "string",
"tableType": "right"
}
]
},
{
"operator": "=",
"operand": [
{
"namespace": "Read_asset_car_tob_pudongyongda_property_1603618594544",
"name": "othercarmodel",
"type": "string",
"tableType": "left"
},
{
"namespace": "Read_A111111_1635927769820",
"name": "othercarmodel",
"type": "string",
"tableType": "right"
}
]
},
{
"operator": "=",
"operand": [
{
"namespace": "Read_asset_car_tob_pudongyongda_property_1603618594544",
"name": "interest_car_price",
"type": "string",
"tableType": "left"
},
{
"namespace": "Read_A111111_1635927769820",
"name": "interest_car_price",
"type": "string",
"tableType": "right"
}
]
},
{
"operator": "=",
"operand": [
{
"namespace": "Read_asset_car_tob_pudongyongda_property_1603618594544",
"name": "interest_car_brand_country",
"type": "string",
"tableType": "left"
},
{
"namespace": "Read_A111111_1635927769820",
"name": "interest_car_brand_country",
"type": "string",
"tableType": "right"
}
]
},
{
"operator": "=",
"operand": [
{
"namespace": "Read_asset_car_tob_pudongyongda_property_1603618594544",
"name": "interest_car_brand",
"type": "string",
"tableType": "left"
},
{
"namespace": "Read_A111111_1635927769820",
"name": "interest_car_brand",
"type": "string",
"tableType": "right"
}
]
},
{
"operator": "=",
"operand": [
{
"namespace": "Read_asset_car_tob_pudongyongda_property_1603618594544",
"name": "interest_car_other_series_type",
"type": "string",
"tableType": "left"
},
{
"namespace": "Read_A111111_1635927769820",
"name": "interest_car_other_series_type",
"type": "string",
"tableType": "right"
}
]
},
{
"operator": "=",
"operand": [
{
"namespace": "Read_asset_car_tob_pudongyongda_property_1603618594544",
"name": "interest_car_newenergy_type",
"type": "string",
"tableType": "left"
},
{
"namespace": "Read_A111111_1635927769820",
"name": "interest_car_newenergy_type",
"type": "string",
"tableType": "right"
}
]
},
{
"operator": "=",
"operand": [
{
"namespace": "Read_asset_car_tob_pudongyongda_property_1603618594544",
"name": "client_stage",
"type": "string",
"tableType": "left"
},
{
"namespace": "Read_A111111_1635927769820",
"name": "client_stage",
"type": "string",
"tableType": "right"
}
]
},
{
"operator": "=",
"operand": [
{
"namespace": "Read_asset_car_tob_pudongyongda_property_1603618594544",
"name": "channel",
"type": "string",
"tableType": "left"
},
{
"namespace": "Read_A111111_1635927769820",
"name": "channel",
"type": "string",
"tableType": "right"
}
]
},
{
"operator": "=",
"operand": [
{
"namespace": "Read_asset_car_tob_pudongyongda_property_1603618594544",
"name": "community_pv_lastweek",
"type": "int",
"tableType": "left"
},
{
"namespace": "Read_A111111_1635927769820",
"name": "community_pv_lastweek",
"type": "int",
"tableType": "right"
}
]
},
{
"operator": "=",
"operand": [
{
"namespace": "Read_asset_car_tob_pudongyongda_property_1603618594544",
"name": "community_creation_lastweek",
"type": "int",
"tableType": "left"
},
{
"namespace": "Read_A111111_1635927769820",
"name": "community_creation_lastweek",
"type": "int",
"tableType": "right"
}
]
},
{
"operator": "=",
"operand": [
{
"namespace": "Read_asset_car_tob_pudongyongda_property_1603618594544",
"name": "community_forward_lastweek",
"type": "int",
"tableType": "left"
},
{
"namespace": "Read_A111111_1635927769820",
"name": "community_forward_lastweek",
"type": "int",
"tableType": "right"
}
]
},
{
"operator": "=",
"operand": [
{
"namespace": "Read_asset_car_tob_pudongyongda_property_1603618594544",
"name": "community_recruit_lastweek",
"type": "int",
"tableType": "left"
},
{
"namespace": "Read_A111111_1635927769820",
"name": "community_recruit_lastweek",
"type": "int",
"tableType": "right"
}
]
},
{
"operator": "=",
"operand": [
{
"namespace": "Read_asset_car_tob_pudongyongda_property_1603618594544",
"name": "car_optical_pack_eagerness",
"type": "string",
"tableType": "left"
},
{
"namespace": "Read_A111111_1635927769820",
"name": "car_optical_pack_eagerness",
"type": "string",
"tableType": "right"
}
]
},
{
"operator": "=",
"operand": [
{
"namespace": "Read_asset_car_tob_pudongyongda_property_1603618594544",
"name": "car_pick_up_eagerness",
"type": "string",
"tableType": "left"
},
{
"namespace": "Read_A111111_1635927769820",
"name": "car_pick_up_eagerness",
"type": "string",
"tableType": "right"
}
]
},
{
"operator": "=",
"operand": [
{
"namespace": "Read_asset_car_tob_pudongyongda_property_1603618594544",
"name": "returned_customer",
"type": "string",
"tableType": "left"
},
{
"namespace": "Read_A111111_1635927769820",
"name": "returned_customer",
"type": "string",
"tableType": "right"
}
]
},
{
"operator": "=",
"operand": [
{
"namespace": "Read_asset_car_tob_pudongyongda_property_1603618594544",
"name": "car_price_comparison",
"type": "string",
"tableType": "left"
},
{
"namespace": "Read_A111111_1635927769820",
"name": "car_price_comparison",
"type": "string",
"tableType": "right"
}
]
},
{
"operator": "=",
"operand": [
{
"namespace": "Read_asset_car_tob_pudongyongda_property_1603618594544",
"name": "stored_many_points",
"type": "string",
"tableType": "left"
},
{
"namespace": "Read_A111111_1635927769820",
"name": "stored_many_points",
"type": "string",
"tableType": "right"
}
]
},
{
"operator": "=",
"operand": [
{
"namespace": "Read_asset_car_tob_pudongyongda_property_1603618594544",
"name": "club_freshman",
"type": "string",
"tableType": "left"
},
{
"namespace": "Read_A111111_1635927769820",
"name": "club_freshman",
"type": "string",
"tableType": "right"
}
]
},
{
"operator": "=",
"operand": [
{
"namespace": "Read_asset_car_tob_pudongyongda_property_1603618594544",
"name": "recall_values",
"type": "string",
"tableType": "left"
},
{
"namespace": "Read_A111111_1635927769820",
"name": "recall_values",
"type": "string",
"tableType": "right"
}
]
},
{
"operator": "=",
"operand": [
{
"namespace": "Read_asset_car_tob_pudongyongda_property_1603618594544",
"name": "date",
"type": "string",
"tableType": "left"
},
{
"namespace": "Read_A111111_1635927769820",
"name": "date",
"type": "string",
"tableType": "right"
}
]
}
]
},
"fields": [
{
"name": "uid",
"alias": "uid",
"type": "long",
"isSelect": true,
"typeList": [],
"tableType": "left",
"namespace": "Read_asset_car_tob_pudongyongda_property_1603618594544"
},
{
"name": "gender",
"alias": "gender",
"type": "string",
"isSelect": true,
"typeList": [],
"tableType": "left",
"namespace": "Read_asset_car_tob_pudongyongda_property_1603618594544"
},
{
"name": "age",
"alias": "age",
"type": "string",
"isSelect": true,
"typeList": [],
"tableType": "left",
"namespace": "Read_asset_car_tob_pudongyongda_property_1603618594544"
},
{
"name": "area",
"alias": "area",
"type": "string",
"isSelect": true,
"typeList": [],
"tableType": "left",
"namespace": "Read_asset_car_tob_pudongyongda_property_1603618594544"
},
{
"name": "lifestage",
"alias": "lifestage",
"type": "string",
"isSelect": true,
"typeList": [],
"tableType": "left",
"namespace": "Read_asset_car_tob_pudongyongda_property_1603618594544"
},
{
"name": "education",
"alias": "education",
"type": "string",
"isSelect": true,
"typeList": [],
"tableType": "left",
"namespace": "Read_asset_car_tob_pudongyongda_property_1603618594544"
},
{
"name": "job",
"alias": "job",
"type": "string",
"isSelect": true,
"typeList": [],
"tableType": "left",
"namespace": "Read_asset_car_tob_pudongyongda_property_1603618594544"
},
{
"name": "birthday",
"alias": "birthday",
"type": "string",
"isSelect": true,
"typeList": [],
"tableType": "left",
"namespace": "Read_asset_car_tob_pudongyongda_property_1603618594544"
},
{
"name": "lifecycle",
"alias": "lifecycle",
"type": "string",
"isSelect": true,
"typeList": [],
"tableType": "left",
"namespace": "Read_asset_car_tob_pudongyongda_property_1603618594544"
},
{
"name": "own_store",
"alias": "own_store",
"type": "string",
"isSelect": true,
"typeList": [],
"tableType": "left",
"namespace": "Read_asset_car_tob_pudongyongda_property_1603618594544"
},
{
"name": "own_sales",
"alias": "own_sales",
"type": "string",
"isSelect": true,
"typeList": [],
"tableType": "left",
"namespace": "Read_asset_car_tob_pudongyongda_property_1603618594544"
},
{
"name": "wanted_store",
"alias": "wanted_store",
"type": "string",
"isSelect": true,
"typeList": [],
"tableType": "left",
"namespace": "Read_asset_car_tob_pudongyongda_property_1603618594544"
},
{
"name": "wanted_carmodel",
"alias": "wanted_carmodel",
"type": "string",
"isSelect": true,
"typeList": [],
"tableType": "left",
"namespace": "Read_asset_car_tob_pudongyongda_property_1603618594544"
},
{
"name": "rank",
"alias": "rank",
"type": "string",
"isSelect": true,
"typeList": [],
"tableType": "left",
"namespace": "Read_asset_car_tob_pudongyongda_property_1603618594544"
},
{
"name": "lasttime_pudongyongda_testdrive",
"alias": "lasttime_pudongyongda_testdrive",
"type": "string",
"isSelect": true,
"typeList": [],
"tableType": "left",
"namespace": "Read_asset_car_tob_pudongyongda_property_1603618594544"
},
{
"name": "newcar_tasting",
"alias": "newcar_tasting",
"type": "string",
"isSelect": true,
"typeList": [],
"tableType": "left",
"namespace": "Read_asset_car_tob_pudongyongda_property_1603618594544"
},
{
"name": "storetimes_lastthreemonth",
"alias": "storetimes_lastthreemonth",
"type": "string",
"isSelect": true,
"typeList": [],
"tableType": "left",
"namespace": "Read_asset_car_tob_pudongyongda_property_1603618594544"
},
{
"name": "storenumbers_lastthreemonth",
"alias": "storenumbers_lastthreemonth",
"type": "string",
"isSelect": true,
"typeList": [],
"tableType": "left",
"namespace": "Read_asset_car_tob_pudongyongda_property_1603618594544"
},
{
"name": "warranty_times",
"alias": "warranty_times",
"type": "int",
"isSelect": true,
"typeList": [],
"tableType": "left",
"namespace": "Read_asset_car_tob_pudongyongda_property_1603618594544"
},
{
"name": "warranty_values",
"alias": "warranty_values",
"type": "string",
"isSelect": true,
"typeList": [],
"tableType": "left",
"namespace": "Read_asset_car_tob_pudongyongda_property_1603618594544"
},
{
"name": "pudongyongda_noentry_time",
"alias": "pudongyongda_noentry_time",
"type": "string",
"isSelect": true,
"typeList": [],
"tableType": "left",
"namespace": "Read_asset_car_tob_pudongyongda_property_1603618594544"
},
{
"name": "forwardtimes_lastthreemonth",
"alias": "forwardtimes_lastthreemonth",
"type": "string",
"isSelect": true,
"typeList": [],
"tableType": "left",
"namespace": "Read_asset_car_tob_pudongyongda_property_1603618594544"
},
{
"name": "publishtimes_lastmonth",
"alias": "publishtimes_lastmonth",
"type": "string",
"isSelect": true,
"typeList": [],
"tableType": "left",
"namespace": "Read_asset_car_tob_pudongyongda_property_1603618594544"
},
{
"name": "applets_opentimes_lastmonth",
"alias": "applets_opentimes_lastmonth",
"type": "int",
"isSelect": true,
"typeList": [],
"tableType": "left",
"namespace": "Read_asset_car_tob_pudongyongda_property_1603618594544"
},
{
"name": "optionalpackpage_opentimes_lastmonth",
"alias": "optionalpackpage_opentimes_lastmonth",
"type": "int",
"isSelect": true,
"typeList": [],
"tableType": "left",
"namespace": "Read_asset_car_tob_pudongyongda_property_1603618594544"
},
{
"name": "optionalpackpage_time_lastmonth",
"alias": "optionalpackpage_time_lastmonth",
"type": "int",
"isSelect": true,
"typeList": [],
"tableType": "left",
"namespace": "Read_asset_car_tob_pudongyongda_property_1603618594544"
},
{
"name": "last_eta",
"alias": "last_eta",
"type": "int",
"isSelect": true,
"typeList": [],
"tableType": "left",
"namespace": "Read_asset_car_tob_pudongyongda_property_1603618594544"
},
{
"name": "eta_modifytimes",
"alias": "eta_modifytimes",
"type": "string",
"isSelect": true,
"typeList": [],
"tableType": "left",
"namespace": "Read_asset_car_tob_pudongyongda_property_1603618594544"
},
{
"name": "pointuse_lastmonth",
"alias": "pointuse_lastmonth",
"type": "string",
"isSelect": true,
"typeList": [],
"tableType": "left",
"namespace": "Read_asset_car_tob_pudongyongda_property_1603618594544"
},
{
"name": "point_count",
"alias": "point_count",
"type": "string",
"isSelect": true,
"typeList": [],
"tableType": "left",
"namespace": "Read_asset_car_tob_pudongyongda_property_1603618594544"
},
{
"name": "active_lasttime",
"alias": "active_lasttime",
"type": "string",
"isSelect": true,
"typeList": [],
"tableType": "left",
"namespace": "Read_asset_car_tob_pudongyongda_property_1603618594544"
},
{
"name": "contact_preference",
"alias": "contact_preference",
"type": "string",
"isSelect": true,
"typeList": [],
"tableType": "left",
"namespace": "Read_asset_car_tob_pudongyongda_property_1603618594544"
},
{
"name": "gift_preference",
"alias": "gift_preference",
"type": "string",
"isSelect": true,
"typeList": [],
"tableType": "left",
"namespace": "Read_asset_car_tob_pudongyongda_property_1603618594544"
},
{
"name": "carowner",
"alias": "carowner",
"type": "string",
"isSelect": true,
"typeList": [],
"tableType": "left",
"namespace": "Read_asset_car_tob_pudongyongda_property_1603618594544"
},
{
"name": "salescarmodel",
"alias": "salescarmodel",
"type": "string",
"isSelect": true,
"typeList": [],
"tableType": "left",
"namespace": "Read_asset_car_tob_pudongyongda_property_1603618594544"
},
{
"name": "salestime",
"alias": "salestime",
"type": "string",
"isSelect": true,
"typeList": [],
"tableType": "left",
"namespace": "Read_asset_car_tob_pudongyongda_property_1603618594544"
},
{
"name": "carownerappvisit",
"alias": "carownerappvisit",
"type": "string",
"isSelect": true,
"typeList": [],
"tableType": "left",
"namespace": "Read_asset_car_tob_pudongyongda_property_1603618594544"
},
{
"name": "othercarmodel",
"alias": "othercarmodel",
"type": "string",
"isSelect": true,
"typeList": [],
"tableType": "left",
"namespace": "Read_asset_car_tob_pudongyongda_property_1603618594544"
},
{
"name": "interest_car_price",
"alias": "interest_car_price",
"type": "string",
"isSelect": true,
"typeList": [],
"tableType": "left",
"namespace": "Read_asset_car_tob_pudongyongda_property_1603618594544"
},
{
"name": "interest_car_brand_country",
"alias": "interest_car_brand_country",
"type": "string",
"isSelect": true,
"typeList": [],
"tableType": "left",
"namespace": "Read_asset_car_tob_pudongyongda_property_1603618594544"
},
{
"name": "interest_car_brand",
"alias": "interest_car_brand",
"type": "string",
"isSelect": true,
"typeList": [],
"tableType": "left",
"namespace": "Read_asset_car_tob_pudongyongda_property_1603618594544"
},
{
"name": "interest_car_other_series_type",
"alias": "interest_car_other_series_type",
"type": "string",
"isSelect": true,
"typeList": [],
"tableType": "left",
"namespace": "Read_asset_car_tob_pudongyongda_property_1603618594544"
},
{
"name": "interest_car_newenergy_type",
"alias": "interest_car_newenergy_type",
"type": "string",
"isSelect": true,
"typeList": [],
"tableType": "left",
"namespace": "Read_asset_car_tob_pudongyongda_property_1603618594544"
},
{
"name": "client_stage",
"alias": "client_stage",
"type": "string",
"isSelect": true,
"typeList": [],
"tableType": "left",
"namespace": "Read_asset_car_tob_pudongyongda_property_1603618594544"
},
{
"name": "channel",
"alias": "channel",
"type": "string",
"isSelect": true,
"typeList": [],
"tableType": "left",
"namespace": "Read_asset_car_tob_pudongyongda_property_1603618594544"
},
{
"name": "community_pv_lastweek",
"alias": "community_pv_lastweek",
"type": "int",
"isSelect": true,
"typeList": [],
"tableType": "left",
"namespace": "Read_asset_car_tob_pudongyongda_property_1603618594544"
},
{
"name": "community_creation_lastweek",
"alias": "community_creation_lastweek",
"type": "int",
"isSelect": true,
"typeList": [],
"tableType": "left",
"namespace": "Read_asset_car_tob_pudongyongda_property_1603618594544"
},
{
"name": "community_forward_lastweek",
"alias": "community_forward_lastweek",
"type": "int",
"isSelect": true,
"typeList": [],
"tableType": "left",
"namespace": "Read_asset_car_tob_pudongyongda_property_1603618594544"
},
{
"name": "community_recruit_lastweek",
"alias": "community_recruit_lastweek",
"type": "int",
"isSelect": true,
"typeList": [],
"tableType": "left",
"namespace": "Read_asset_car_tob_pudongyongda_property_1603618594544"
},
{
"name": "car_optical_pack_eagerness",
"alias": "car_optical_pack_eagerness",
"type": "string",
"isSelect": true,
"typeList": [],
"tableType": "left",
"namespace": "Read_asset_car_tob_pudongyongda_property_1603618594544"
},
{
"name": "car_pick_up_eagerness",
"alias": "car_pick_up_eagerness",
"type": "string",
"isSelect": true,
"typeList": [],
"tableType": "left",
"namespace": "Read_asset_car_tob_pudongyongda_property_1603618594544"
},
{
"name": "returned_customer",
"alias": "returned_customer",
"type": "string",
"isSelect": true,
"typeList": [],
"tableType": "left",
"namespace": "Read_asset_car_tob_pudongyongda_property_1603618594544"
},
{
"name": "car_price_comparison",
"alias": "car_price_comparison",
"type": "string",
"isSelect": true,
"typeList": [],
"tableType": "left",
"namespace": "Read_asset_car_tob_pudongyongda_property_1603618594544"
},
{
"name": "stored_many_points",
"alias": "stored_many_points",
"type": "string",
"isSelect": true,
"typeList": [],
"tableType": "left",
"namespace": "Read_asset_car_tob_pudongyongda_property_1603618594544"
},
{
"name": "club_freshman",
"alias": "club_freshman",
"type": "string",
"isSelect": true,
"typeList": [],
"tableType": "left",
"namespace": "Read_asset_car_tob_pudongyongda_property_1603618594544"
},
{
"name": "recall_values",
"alias": "recall_values",
"type": "string",
"isSelect": true,
"typeList": [],
"tableType": "left",
"namespace": "Read_asset_car_tob_pudongyongda_property_1603618594544"
},
{
"name": "date",
"alias": "date",
"type": "string",
"isSelect": true,
"typeList": [],
"tableType": "left",
"namespace": "Read_asset_car_tob_pudongyongda_property_1603618594544"
},
{
"name": "gender",
"alias": "gender_1",
"type": "string",
"isSelect": true,
"typeList": [],
"tableType": "right",
"namespace": "Read_A111111_1635927769820"
},
{
"name": "age",
"alias": "age_1",
"type": "string",
"isSelect": true,
"typeList": [],
"tableType": "right",
"namespace": "Read_A111111_1635927769820"
},
{
"name": "area",
"alias": "area_1",
"type": "string",
"isSelect": true,
"typeList": [],
"tableType": "right",
"namespace": "Read_A111111_1635927769820"
},
{
"name": "lifestage",
"alias": "lifestage_1",
"type": "string",
"isSelect": true,
"typeList": [],
"tableType": "right",
"namespace": "Read_A111111_1635927769820"
},
{
"name": "education",
"alias": "education_1",
"type": "string",
"isSelect": true,
"typeList": [],
"tableType": "right",
"namespace": "Read_A111111_1635927769820"
},
{
"name": "job",
"alias": "job_1",
"type": "string",
"isSelect": true,
"typeList": [],
"tableType": "right",
"namespace": "Read_A111111_1635927769820"
},
{
"name": "birthday",
"alias": "birthday_1",
"type": "string",
"isSelect": true,
"typeList": [],
"tableType": "right",
"namespace": "Read_A111111_1635927769820"
},
{
"name": "lifecycle",
"alias": "lifecycle_1",
"type": "string",
"isSelect": true,
"typeList": [],
"tableType": "right",
"namespace": "Read_A111111_1635927769820"
},
{
"name": "own_store",
"alias": "own_store_1",
"type": "string",
"isSelect": true,
"typeList": [],
"tableType": "right",
"namespace": "Read_A111111_1635927769820"
},
{
"name": "own_sales",
"alias": "own_sales_1",
"type": "string",
"isSelect": true,
"typeList": [],
"tableType": "right",
"namespace": "Read_A111111_1635927769820"
},
{
"name": "wanted_store",
"alias": "wanted_store_1",
"type": "string",
"isSelect": true,
"typeList": [],
"tableType": "right",
"namespace": "Read_A111111_1635927769820"
},
{
"name": "wanted_carmodel",
"alias": "wanted_carmodel_1",
"type": "string",
"isSelect": true,
"typeList": [],
"tableType": "right",
"namespace": "Read_A111111_1635927769820"
},
{
"name": "rank",
"alias": "rank_1",
"type": "string",
"isSelect": true,
"typeList": [],
"tableType": "right",
"namespace": "Read_A111111_1635927769820"
},
{
"name": "lasttime_pudongyongda_testdrive",
"alias": "lasttime_pudongyongda_testdrive_1",
"type": "string",
"isSelect": true,
"typeList": [],
"tableType": "right",
"namespace": "Read_A111111_1635927769820"
},
{
"name": "newcar_tasting",
"alias": "newcar_tasting_1",
"type": "string",
"isSelect": true,
"typeList": [],
"tableType": "right",
"namespace": "Read_A111111_1635927769820"
},
{
"name": "storetimes_lastthreemonth",
"alias": "storetimes_lastthreemonth_1",
"type": "string",
"isSelect": true,
"typeList": [],
"tableType": "right",
"namespace": "Read_A111111_1635927769820"
},
{
"name": "storenumbers_lastthreemonth",
"alias": "storenumbers_lastthreemonth_1",
"type": "string",
"isSelect": true,
"typeList": [],
"tableType": "right",
"namespace": "Read_A111111_1635927769820"
},
{
"name": "warranty_times",
"alias": "warranty_times_1",
"type": "int",
"isSelect": true,
"typeList": [],
"tableType": "right",
"namespace": "Read_A111111_1635927769820"
},
{
"name": "warranty_values",
"alias": "warranty_values_1",
"type": "string",
"isSelect": true,
"typeList": [],
"tableType": "right",
"namespace": "Read_A111111_1635927769820"
},
{
"name": "pudongyongda_noentry_time",
"alias": "pudongyongda_noentry_time_1",
"type": "string",
"isSelect": true,
"typeList": [],
"tableType": "right",
"namespace": "Read_A111111_1635927769820"
},
{
"name": "forwardtimes_lastthreemonth",
"alias": "forwardtimes_lastthreemonth_1",
"type": "string",
"isSelect": true,
"typeList": [],
"tableType": "right",
"namespace": "Read_A111111_1635927769820"
},
{
"name": "publishtimes_lastmonth",
"alias": "publishtimes_lastmonth_1",
"type": "string",
"isSelect": true,
"typeList": [],
"tableType": "right",
"namespace": "Read_A111111_1635927769820"
},
{
"name": "applets_opentimes_lastmonth",
"alias": "applets_opentimes_lastmonth_1",
"type": "int",
"isSelect": true,
"typeList": [],
"tableType": "right",
"namespace": "Read_A111111_1635927769820"
},
{
"name": "optionalpackpage_opentimes_lastmonth",
"alias": "optionalpackpage_opentimes_lastmonth_1",
"type": "int",
"isSelect": true,
"typeList": [],
"tableType": "right",
"namespace": "Read_A111111_1635927769820"
},
{
"name": "optionalpackpage_time_lastmonth",
"alias": "optionalpackpage_time_lastmonth_1",
"type": "int",
"isSelect": true,
"typeList": [],
"tableType": "right",
"namespace": "Read_A111111_1635927769820"
},
{
"name": "last_eta",
"alias": "last_eta_1",
"type": "int",
"isSelect": true,
"typeList": [],
"tableType": "right",
"namespace": "Read_A111111_1635927769820"
},
{
"name": "eta_modifytimes",
"alias": "eta_modifytimes_1",
"type": "string",
"isSelect": true,
"typeList": [],
"tableType": "right",
"namespace": "Read_A111111_1635927769820"
},
{
"name": "pointuse_lastmonth",
"alias": "pointuse_lastmonth_1",
"type": "string",
"isSelect": true,
"typeList": [],
"tableType": "right",
"namespace": "Read_A111111_1635927769820"
},
{
"name": "point_count",
"alias": "point_count_1",
"type": "string",
"isSelect": true,
"typeList": [],
"tableType": "right",
"namespace": "Read_A111111_1635927769820"
},
{
"name": "active_lasttime",
"alias": "active_lasttime_1",
"type": "string",
"isSelect": true,
"typeList": [],
"tableType": "right",
"namespace": "Read_A111111_1635927769820"
},
{
"name": "contact_preference",
"alias": "contact_preference_1",
"type": "string",
"isSelect": true,
"typeList": [],
"tableType": "right",
"namespace": "Read_A111111_1635927769820"
},
{
"name": "gift_preference",
"alias": "gift_preference_1",
"type": "string",
"isSelect": true,
"typeList": [],
"tableType": "right",
"namespace": "Read_A111111_1635927769820"
},
{
"name": "carowner",
"alias": "carowner_1",
"type": "string",
"isSelect": true,
"typeList": [],
"tableType": "right",
"namespace": "Read_A111111_1635927769820"
},
{
"name": "salescarmodel",
"alias": "salescarmodel_1",
"type": "string",
"isSelect": true,
"typeList": [],
"tableType": "right",
"namespace": "Read_A111111_1635927769820"
},
{
"name": "salestime",
"alias": "salestime_1",
"type": "string",
"isSelect": true,
"typeList": [],
"tableType": "right",
"namespace": "Read_A111111_1635927769820"
},
{
"name": "carownerappvisit",
"alias": "carownerappvisit_1",
"type": "string",
"isSelect": true,
"typeList": [],
"tableType": "right",
"namespace": "Read_A111111_1635927769820"
},
{
"name": "othercarmodel",
"alias": "othercarmodel_1",
"type": "string",
"isSelect": true,
"typeList": [],
"tableType": "right",
"namespace": "Read_A111111_1635927769820"
},
{
"name": "interest_car_price",
"alias": "interest_car_price_1",
"type": "string",
"isSelect": true,
"typeList": [],
"tableType": "right",
"namespace": "Read_A111111_1635927769820"
},
{
"name": "interest_car_brand_country",
"alias": "interest_car_brand_country_1",
"type": "string",
"isSelect": true,
"typeList": [],
"tableType": "right",
"namespace": "Read_A111111_1635927769820"
},
{
"name": "interest_car_brand",
"alias": "interest_car_brand_1",
"type": "string",
"isSelect": true,
"typeList": [],
"tableType": "right",
"namespace": "Read_A111111_1635927769820"
},
{
"name": "interest_car_other_series_type",
"alias": "interest_car_other_series_type_1",
"type": "string",
"isSelect": true,
"typeList": [],
"tableType": "right",
"namespace": "Read_A111111_1635927769820"
},
{
"name": "interest_car_newenergy_type",
"alias": "interest_car_newenergy_type_1",
"type": "string",
"isSelect": true,
"typeList": [],
"tableType": "right",
"namespace": "Read_A111111_1635927769820"
},
{
"name": "client_stage",
"alias": "client_stage_1",
"type": "string",
"isSelect": true,
"typeList": [],
"tableType": "right",
"namespace": "Read_A111111_1635927769820"
},
{
"name": "channel",
"alias": "channel_1",
"type": "string",
"isSelect": true,
"typeList": [],
"tableType": "right",
"namespace": "Read_A111111_1635927769820"
},
{
"name": "community_pv_lastweek",
"alias": "community_pv_lastweek_1",
"type": "int",
"isSelect": true,
"typeList": [],
"tableType": "right",
"namespace": "Read_A111111_1635927769820"
},
{
"name": "community_creation_lastweek",
"alias": "community_creation_lastweek_1",
"type": "int",
"isSelect": true,
"typeList": [],
"tableType": "right",
"namespace": "Read_A111111_1635927769820"
},
{
"name": "community_forward_lastweek",
"alias": "community_forward_lastweek_1",
"type": "int",
"isSelect": true,
"typeList": [],
"tableType": "right",
"namespace": "Read_A111111_1635927769820"
},
{
"name": "community_recruit_lastweek",
"alias": "community_recruit_lastweek_1",
"type": "int",
"isSelect": true,
"typeList": [],
"tableType": "right",
"namespace": "Read_A111111_1635927769820"
},
{
"name": "car_optical_pack_eagerness",
"alias": "car_optical_pack_eagerness_1",
"type": "string",
"isSelect": true,
"typeList": [],
"tableType": "right",
"namespace": "Read_A111111_1635927769820"
},
{
"name": "car_pick_up_eagerness",
"alias": "car_pick_up_eagerness_1",
"type": "string",
"isSelect": true,
"typeList": [],
"tableType": "right",
"namespace": "Read_A111111_1635927769820"
},
{
"name": "returned_customer",
"alias": "returned_customer_1",
"type": "string",
"isSelect": true,
"typeList": [],
"tableType": "right",
"namespace": "Read_A111111_1635927769820"
},
{
"name": "car_price_comparison",
"alias": "car_price_comparison_1",
"type": "string",
"isSelect": true,
"typeList": [],
"tableType": "right",
"namespace": "Read_A111111_1635927769820"
},
{
"name": "stored_many_points",
"alias": "stored_many_points_1",
"type": "string",
"isSelect": true,
"typeList": [],
"tableType": "right",
"namespace": "Read_A111111_1635927769820"
},
{
"name": "club_freshman",
"alias": "club_freshman_1",
"type": "string",
"isSelect": true,
"typeList": [],
"tableType": "right",
"namespace": "Read_A111111_1635927769820"
},
{
"name": "recall_values",
"alias": "recall_values_1",
"type": "string",
"isSelect": true,
"typeList": [],
"tableType": "right",
"namespace": "Read_A111111_1635927769820"
},
{
"name": "date",
"alias": "date_1",
"type": "string",
"isSelect": true,
"typeList": [],
"tableType": "right",
"namespace": "Read_A111111_1635927769820"
},
{
"name": "uid",
"alias": "uid_1",
"type": "long",
"isSelect": true,
"typeList": [],
"tableType": "right",
"namespace": "Read_A111111_1635927769820"
}
]
}
},
{
"key": "Load_1635927852514",
"name": "输出_1",
"type": "Load",
"dataType": "hive",
"nodeStatus": "DEFAULT",
"connection": {
"dbName": "aeolus",
"tableName": "dfgdfg",
"partitions": [
"area"
]
}
},
{
"key": "SparkUnionOperator_1635927905727",
"name": "合并行_1",
"type": "SparkUnionOperator",
"dataType": "Default",
"nodeStatus": "SUCCEEDED",
"operators": {
"fields": [
{
"name": "age",
"alias": "age[意向评级标注_Read_asset_car_tob_pudongyongda_property_1603618594544]",
"type": "string",
"isSelect": true,
"fieldMap": [
{
"preNodeKey": "Read_asset_car_tob_pudongyongda_property_1603618594544",
"fieldName": "age"
}
]
},
{
"name": "own_store",
"alias": "own_store[意向评级标注_Read_asset_car_tob_pudongyongda_property_1603618594544]",
"type": "string",
"isSelect": true,
"fieldMap": [
{
"preNodeKey": "Read_asset_car_tob_pudongyongda_property_1603618594544",
"fieldName": "own_store"
}
]
},
{
"name": "gender",
"alias": "gender[意向评级标注_Read_asset_car_tob_pudongyongda_property_1603618594544]",
"type": "string",
"isSelect": true,
"fieldMap": [
{
"preNodeKey": "Read_asset_car_tob_pudongyongda_property_1603618594544",
"fieldName": "gender"
}
]
},
{
"name": "area",
"alias": "area[意向评级标注_Read_asset_car_tob_pudongyongda_property_1603618594544]",
"type": "string",
"isSelect": true,
"fieldMap": [
{
"preNodeKey": "Read_asset_car_tob_pudongyongda_property_1603618594544",
"fieldName": "area"
}
]
},
{
"name": "lifestage",
"alias": "lifestage[意向评级标注_Read_asset_car_tob_pudongyongda_property_1603618594544]",
"type": "string",
"isSelect": true,
"fieldMap": [
{
"preNodeKey": "Read_asset_car_tob_pudongyongda_property_1603618594544",
"fieldName": "lifestage"
}
]
},
{
"name": "education",
"alias": "education[意向评级标注_Read_asset_car_tob_pudongyongda_property_1603618594544]",
"type": "string",
"isSelect": true,
"fieldMap": [
{
"preNodeKey": "Read_asset_car_tob_pudongyongda_property_1603618594544",
"fieldName": "education"
}
]
},
{
"name": "job",
"alias": "job[意向评级标注_Read_asset_car_tob_pudongyongda_property_1603618594544]",
"type": "string",
"isSelect": true,
"fieldMap": [
{
"preNodeKey": "Read_asset_car_tob_pudongyongda_property_1603618594544",
"fieldName": "job"
}
]
},
{
"name": "birthday",
"alias": "birthday[意向评级标注_Read_asset_car_tob_pudongyongda_property_1603618594544]",
"type": "string",
"isSelect": true,
"fieldMap": [
{
"preNodeKey": "Read_asset_car_tob_pudongyongda_property_1603618594544",
"fieldName": "birthday"
}
]
},
{
"name": "lifecycle",
"alias": "lifecycle[意向评级标注_Read_asset_car_tob_pudongyongda_property_1603618594544]",
"type": "string",
"isSelect": true,
"fieldMap": [
{
"preNodeKey": "Read_asset_car_tob_pudongyongda_property_1603618594544",
"fieldName": "lifecycle"
}
]
},
{
"name": "wanted_store",
"alias": "wanted_store[意向评级标注_Read_asset_car_tob_pudongyongda_property_1603618594544]",
"type": "string",
"isSelect": true,
"fieldMap": [
{
"preNodeKey": "Read_asset_car_tob_pudongyongda_property_1603618594544",
"fieldName": "wanted_store"
}
]
},
{
"name": "wanted_carmodel",
"alias": "wanted_carmodel[意向评级标注_Read_asset_car_tob_pudongyongda_property_1603618594544]",
"type": "string",
"isSelect": true,
"fieldMap": [
{
"preNodeKey": "Read_asset_car_tob_pudongyongda_property_1603618594544",
"fieldName": "wanted_carmodel"
}
]
},
{
"name": "rank",
"alias": "rank[意向评级标注_Read_asset_car_tob_pudongyongda_property_1603618594544]",
"type": "string",
"isSelect": true,
"fieldMap": [
{
"preNodeKey": "Read_asset_car_tob_pudongyongda_property_1603618594544",
"fieldName": "rank"
}
]
},
{
"name": "lasttime_pudongyongda_testdrive",
"alias": "lasttime_pudongyongda_testdrive[意向评级标注_Read_asset_car_tob_pudongyongda_property_1603618594544]",
"type": "string",
"isSelect": true,
"fieldMap": [
{
"preNodeKey": "Read_asset_car_tob_pudongyongda_property_1603618594544",
"fieldName": "lasttime_pudongyongda_testdrive"
}
]
},
{
"name": "newcar_tasting",
"alias": "newcar_tasting[意向评级标注_Read_asset_car_tob_pudongyongda_property_1603618594544]",
"type": "string",
"isSelect": true,
"fieldMap": [
{
"preNodeKey": "Read_asset_car_tob_pudongyongda_property_1603618594544",
"fieldName": "newcar_tasting"
}
]
},
{
"name": "storetimes_lastthreemonth",
"alias": "storetimes_lastthreemonth[意向评级标注_Read_asset_car_tob_pudongyongda_property_1603618594544]",
"type": "string",
"isSelect": true,
"fieldMap": [
{
"preNodeKey": "Read_asset_car_tob_pudongyongda_property_1603618594544",
"fieldName": "storetimes_lastthreemonth"
}
]
},
{
"name": "storenumbers_lastthreemonth",
"alias": "storenumbers_lastthreemonth[意向评级标注_Read_asset_car_tob_pudongyongda_property_1603618594544]",
"type": "string",
"isSelect": true,
"fieldMap": [
{
"preNodeKey": "Read_asset_car_tob_pudongyongda_property_1603618594544",
"fieldName": "storenumbers_lastthreemonth"
}
]
},
{
"name": "warranty_times",
"alias": "warranty_times[意向评级标注_Read_asset_car_tob_pudongyongda_property_1603618594544]",
"type": "int",
"isSelect": true,
"fieldMap": [
{
"preNodeKey": "Read_asset_car_tob_pudongyongda_property_1603618594544",
"fieldName": "warranty_times"
}
]
},
{
"name": "warranty_values",
"alias": "warranty_values[意向评级标注_Read_asset_car_tob_pudongyongda_property_1603618594544]",
"type": "string",
"isSelect": true,
"fieldMap": [
{
"preNodeKey": "Read_asset_car_tob_pudongyongda_property_1603618594544",
"fieldName": "warranty_values"
}
]
},
{
"name": "pudongyongda_noentry_time",
"alias": "pudongyongda_noentry_time[意向评级标注_Read_asset_car_tob_pudongyongda_property_1603618594544]",
"type": "string",
"isSelect": true,
"fieldMap": [
{
"preNodeKey": "Read_asset_car_tob_pudongyongda_property_1603618594544",
"fieldName": "pudongyongda_noentry_time"
}
]
},
{
"name": "forwardtimes_lastthreemonth",
"alias": "forwardtimes_lastthreemonth[意向评级标注_Read_asset_car_tob_pudongyongda_property_1603618594544]",
"type": "string",
"isSelect": true,
"fieldMap": [
{
"preNodeKey": "Read_asset_car_tob_pudongyongda_property_1603618594544",
"fieldName": "forwardtimes_lastthreemonth"
}
]
},
{
"name": "publishtimes_lastmonth",
"alias": "publishtimes_lastmonth[意向评级标注_Read_asset_car_tob_pudongyongda_property_1603618594544]",
"type": "string",
"isSelect": true,
"fieldMap": [
{
"preNodeKey": "Read_asset_car_tob_pudongyongda_property_1603618594544",
"fieldName": "publishtimes_lastmonth"
}
]
},
{
"name": "applets_opentimes_lastmonth",
"alias": "applets_opentimes_lastmonth[意向评级标注_Read_asset_car_tob_pudongyongda_property_1603618594544]",
"type": "int",
"isSelect": true,
"fieldMap": [
{
"preNodeKey": "Read_asset_car_tob_pudongyongda_property_1603618594544",
"fieldName": "applets_opentimes_lastmonth"
}
]
},
{
"name": "optionalpackpage_opentimes_lastmonth",
"alias": "optionalpackpage_opentimes_lastmonth[意向评级标注_Read_asset_car_tob_pudongyongda_property_1603618594544]",
"type": "int",
"isSelect": true,
"fieldMap": [
{
"preNodeKey": "Read_asset_car_tob_pudongyongda_property_1603618594544",
"fieldName": "optionalpackpage_opentimes_lastmonth"
}
]
},
{
"name": "optionalpackpage_time_lastmonth",
"alias": "optionalpackpage_time_lastmonth[意向评级标注_Read_asset_car_tob_pudongyongda_property_1603618594544]",
"type": "int",
"isSelect": true,
"fieldMap": [
{
"preNodeKey": "Read_asset_car_tob_pudongyongda_property_1603618594544",
"fieldName": "optionalpackpage_time_lastmonth"
}
]
},
{
"name": "last_eta",
"alias": "last_eta[意向评级标注_Read_asset_car_tob_pudongyongda_property_1603618594544]",
"type": "int",
"isSelect": true,
"fieldMap": [
{
"preNodeKey": "Read_asset_car_tob_pudongyongda_property_1603618594544",
"fieldName": "last_eta"
}
]
},
{
"name": "eta_modifytimes",
"alias": "eta_modifytimes[意向评级标注_Read_asset_car_tob_pudongyongda_property_1603618594544]",
"type": "string",
"isSelect": true,
"fieldMap": [
{
"preNodeKey": "Read_asset_car_tob_pudongyongda_property_1603618594544",
"fieldName": "eta_modifytimes"
}
]
},
{
"name": "pointuse_lastmonth",
"alias": "pointuse_lastmonth[意向评级标注_Read_asset_car_tob_pudongyongda_property_1603618594544]",
"type": "string",
"isSelect": true,
"fieldMap": [
{
"preNodeKey": "Read_asset_car_tob_pudongyongda_property_1603618594544",
"fieldName": "pointuse_lastmonth"
}
]
},
{
"name": "point_count",
"alias": "point_count[意向评级标注_Read_asset_car_tob_pudongyongda_property_1603618594544]",
"type": "string",
"isSelect": true,
"fieldMap": [
{
"preNodeKey": "Read_asset_car_tob_pudongyongda_property_1603618594544",
"fieldName": "point_count"
}
]
},
{
"name": "active_lasttime",
"alias": "active_lasttime[意向评级标注_Read_asset_car_tob_pudongyongda_property_1603618594544]",
"type": "string",
"isSelect": true,
"fieldMap": [
{
"preNodeKey": "Read_asset_car_tob_pudongyongda_property_1603618594544",
"fieldName": "active_lasttime"
}
]
},
{
"name": "contact_preference",
"alias": "contact_preference[意向评级标注_Read_asset_car_tob_pudongyongda_property_1603618594544]",
"type": "string",
"isSelect": true,
"fieldMap": [
{
"preNodeKey": "Read_asset_car_tob_pudongyongda_property_1603618594544",
"fieldName": "contact_preference"
}
]
},
{
"name": "gift_preference",
"alias": "gift_preference[意向评级标注_Read_asset_car_tob_pudongyongda_property_1603618594544]",
"type": "string",
"isSelect": true,
"fieldMap": [
{
"preNodeKey": "Read_asset_car_tob_pudongyongda_property_1603618594544",
"fieldName": "gift_preference"
}
]
},
{
"name": "carowner",
"alias": "carowner[意向评级标注_Read_asset_car_tob_pudongyongda_property_1603618594544]",
"type": "string",
"isSelect": true,
"fieldMap": [
{
"preNodeKey": "Read_asset_car_tob_pudongyongda_property_1603618594544",
"fieldName": "carowner"
}
]
},
{
"name": "salescarmodel",
"alias": "salescarmodel[意向评级标注_Read_asset_car_tob_pudongyongda_property_1603618594544]",
"type": "string",
"isSelect": true,
"fieldMap": [
{
"preNodeKey": "Read_asset_car_tob_pudongyongda_property_1603618594544",
"fieldName": "salescarmodel"
}
]
},
{
"name": "salestime",
"alias": "salestime[意向评级标注_Read_asset_car_tob_pudongyongda_property_1603618594544]",
"type": "string",
"isSelect": true,
"fieldMap": [
{
"preNodeKey": "Read_asset_car_tob_pudongyongda_property_1603618594544",
"fieldName": "salestime"
}
]
},
{
"name": "carownerappvisit",
"alias": "carownerappvisit[意向评级标注_Read_asset_car_tob_pudongyongda_property_1603618594544]",
"type": "string",
"isSelect": true,
"fieldMap": [
{
"preNodeKey": "Read_asset_car_tob_pudongyongda_property_1603618594544",
"fieldName": "carownerappvisit"
}
]
},
{
"name": "othercarmodel",
"alias": "othercarmodel[意向评级标注_Read_asset_car_tob_pudongyongda_property_1603618594544]",
"type": "string",
"isSelect": true,
"fieldMap": [
{
"preNodeKey": "Read_asset_car_tob_pudongyongda_property_1603618594544",
"fieldName": "othercarmodel"
}
]
},
{
"name": "interest_car_price",
"alias": "interest_car_price[意向评级标注_Read_asset_car_tob_pudongyongda_property_1603618594544]",
"type": "string",
"isSelect": true,
"fieldMap": [
{
"preNodeKey": "Read_asset_car_tob_pudongyongda_property_1603618594544",
"fieldName": "interest_car_price"
}
]
},
{
"name": "interest_car_brand_country",
"alias": "interest_car_brand_country[意向评级标注_Read_asset_car_tob_pudongyongda_property_1603618594544]",
"type": "string",
"isSelect": true,
"fieldMap": [
{
"preNodeKey": "Read_asset_car_tob_pudongyongda_property_1603618594544",
"fieldName": "interest_car_brand_country"
}
]
},
{
"name": "interest_car_brand",
"alias": "interest_car_brand[意向评级标注_Read_asset_car_tob_pudongyongda_property_1603618594544]",
"type": "string",
"isSelect": true,
"fieldMap": [
{
"preNodeKey": "Read_asset_car_tob_pudongyongda_property_1603618594544",
"fieldName": "interest_car_brand"
}
]
},
{
"name": "interest_car_other_series_type",
"alias": "interest_car_other_series_type[意向评级标注_Read_asset_car_tob_pudongyongda_property_1603618594544]",
"type": "string",
"isSelect": true,
"fieldMap": [
{
"preNodeKey": "Read_asset_car_tob_pudongyongda_property_1603618594544",
"fieldName": "interest_car_other_series_type"
}
]
},
{
"name": "interest_car_newenergy_type",
"alias": "interest_car_newenergy_type[意向评级标注_Read_asset_car_tob_pudongyongda_property_1603618594544]",
"type": "string",
"isSelect": true,
"fieldMap": [
{
"preNodeKey": "Read_asset_car_tob_pudongyongda_property_1603618594544",
"fieldName": "interest_car_newenergy_type"
}
]
},
{
"name": "client_stage",
"alias": "client_stage[意向评级标注_Read_asset_car_tob_pudongyongda_property_1603618594544]",
"type": "string",
"isSelect": true,
"fieldMap": [
{
"preNodeKey": "Read_asset_car_tob_pudongyongda_property_1603618594544",
"fieldName": "client_stage"
}
]
},
{
"name": "channel",
"alias": "channel[意向评级标注_Read_asset_car_tob_pudongyongda_property_1603618594544]",
"type": "string",
"isSelect": true,
"fieldMap": [
{
"preNodeKey": "Read_asset_car_tob_pudongyongda_property_1603618594544",
"fieldName": "channel"
}
]
},
{
"name": "community_pv_lastweek",
"alias": "community_pv_lastweek[意向评级标注_Read_asset_car_tob_pudongyongda_property_1603618594544]",
"type": "int",
"isSelect": true,
"fieldMap": [
{
"preNodeKey": "Read_asset_car_tob_pudongyongda_property_1603618594544",
"fieldName": "community_pv_lastweek"
}
]
},
{
"name": "community_creation_lastweek",
"alias": "community_creation_lastweek[意向评级标注_Read_asset_car_tob_pudongyongda_property_1603618594544]",
"type": "int",
"isSelect": true,
"fieldMap": [
{
"preNodeKey": "Read_asset_car_tob_pudongyongda_property_1603618594544",
"fieldName": "community_creation_lastweek"
}
]
},
{
"name": "community_forward_lastweek",
"alias": "community_forward_lastweek[意向评级标注_Read_asset_car_tob_pudongyongda_property_1603618594544]",
"type": "int",
"isSelect": true,
"fieldMap": [
{
"preNodeKey": "Read_asset_car_tob_pudongyongda_property_1603618594544",
"fieldName": "community_forward_lastweek"
}
]
},
{
"name": "own_sales",
"alias": "own_sales[意向评级标注_Read_asset_car_tob_pudongyongda_property_1603618594544]",
"type": "string",
"isSelect": true,
"fieldMap": [
{
"preNodeKey": "Read_asset_car_tob_pudongyongda_property_1603618594544",
"fieldName": "own_sales"
}
]
},
{
"name": "car_optical_pack_eagerness",
"alias": "car_optical_pack_eagerness[意向评级标注_Read_asset_car_tob_pudongyongda_property_1603618594544]",
"type": "string",
"isSelect": true,
"fieldMap": [
{
"preNodeKey": "Read_asset_car_tob_pudongyongda_property_1603618594544",
"fieldName": "car_optical_pack_eagerness"
}
]
},
{
"name": "car_pick_up_eagerness",
"alias": "car_pick_up_eagerness[意向评级标注_Read_asset_car_tob_pudongyongda_property_1603618594544]",
"type": "string",
"isSelect": true,
"fieldMap": [
{
"preNodeKey": "Read_asset_car_tob_pudongyongda_property_1603618594544",
"fieldName": "car_pick_up_eagerness"
}
]
},
{
"name": "returned_customer",
"alias": "returned_customer[意向评级标注_Read_asset_car_tob_pudongyongda_property_1603618594544]",
"type": "string",
"isSelect": true,
"fieldMap": [
{
"preNodeKey": "Read_asset_car_tob_pudongyongda_property_1603618594544",
"fieldName": "returned_customer"
}
]
},
{
"name": "car_price_comparison",
"alias": "car_price_comparison[意向评级标注_Read_asset_car_tob_pudongyongda_property_1603618594544]",
"type": "string",
"isSelect": true,
"fieldMap": [
{
"preNodeKey": "Read_asset_car_tob_pudongyongda_property_1603618594544",
"fieldName": "car_price_comparison"
}
]
},
{
"name": "stored_many_points",
"alias": "stored_many_points[意向评级标注_Read_asset_car_tob_pudongyongda_property_1603618594544]",
"type": "string",
"isSelect": true,
"fieldMap": [
{
"preNodeKey": "Read_asset_car_tob_pudongyongda_property_1603618594544",
"fieldName": "stored_many_points"
}
]
},
{
"name": "club_freshman",
"alias": "club_freshman[意向评级标注_Read_asset_car_tob_pudongyongda_property_1603618594544]",
"type": "string",
"isSelect": true,
"fieldMap": [
{
"preNodeKey": "Read_asset_car_tob_pudongyongda_property_1603618594544",
"fieldName": "club_freshman"
}
]
},
{
"name": "recall_values",
"alias": "recall_values[意向评级标注_Read_asset_car_tob_pudongyongda_property_1603618594544]",
"type": "string",
"isSelect": true,
"fieldMap": [
{
"preNodeKey": "Read_asset_car_tob_pudongyongda_property_1603618594544",
"fieldName": "recall_values"
}
]
},
{
"name": "date",
"alias": "date[意向评级标注_Read_asset_car_tob_pudongyongda_property_1603618594544]",
"type": "string",
"isSelect": true,
"fieldMap": [
{
"preNodeKey": "Read_asset_car_tob_pudongyongda_property_1603618594544",
"fieldName": "date"
}
]
},
{
"name": "upstream_node",
"alias": "upstream_node[意向评级标注_Read_asset_car_tob_pudongyongda_property_1603618594544]",
"type": "string",
"isSelect": true,
"fieldMap": [
{
"preNodeKey": "Read_asset_car_tob_pudongyongda_property_1603618594544",
"fieldName": "upstream_node"
}
]
},
{
"name": "community_recruit_lastweek",
"alias": "community_recruit_lastweek[意向评级标注_Read_asset_car_tob_pudongyongda_property_1603618594544]",
"type": "int",
"isSelect": true,
"fieldMap": [
{
"preNodeKey": "Read_asset_car_tob_pudongyongda_property_1603618594544",
"fieldName": "community_recruit_lastweek"
}
]
},
{
"name": "uid",
"alias": "uid[意向评级标注_Read_asset_car_tob_pudongyongda_property_1603618594544]",
"type": "long",
"isSelect": true,
"fieldMap": [
{
"preNodeKey": "Read_asset_car_tob_pudongyongda_property_1603618594544",
"fieldName": "uid"
}
]
}
],
"preNodeInfos": [
{
"nodeName": "意向评级标注",
"nodeKey": "Read_asset_car_tob_pudongyongda_property_1603618594544",
"sourceNodeFieldName": "upstream_node"
}
]
}
},
{
"key": "aggregation_1635928051887",
"name": "聚合_1",
"type": "Agg",
"dataType": "Udaf",
"nodeStatus": "SUCCEEDED",
"operators": {
"group": [
{
"name": "age",
"type": "string"
}
],
"fields": [
{
"name": "birthday",
"type": "string",
"alias": "birthday",
"aggregation": "max",
"aggregationList": [
"max",
"min",
"cnt",
"cnt(distinct)"
],
"error": [],
"value": "max",
"distinct": false
}
]
}
},
{
"key": "compute_col_1635928149557",
"name": "计算列_1",
"type": "Add",
"dataType": "Expr",
"nodeStatus": "SUCCEEDED",
"operators": {
"fields": [
{
"value": "base64;Y2VpbChgYWdlYCk=",
"type": "double",
"name": "aa"
}
]
}
},
{
"key": "filter_row_1635928290715",
"name": "筛选行_1",
"type": "Filter",
"dataType": "Row",
"nodeStatus": "SUCCEEDED",
"operators": {
"filters": {
"logic": true,
"children": [
{
"groupId": 2,
"type": "string",
"operator": "=",
"delimiter": "comma",
"operand": [
{
"name": "age"
},
{
"type": "string",
"value": "19"
}
]
}
]
}
}
},
{
"key": "SparkUnpivotOperator_1635928347743",
"name": "列转行_1",
"type": "SparkUnpivotOperator",
"dataType": "Row",
"nodeStatus": "SUCCEEDED",
"operators": {
"unpivotConf": {
"columnNames": [
"aa"
],
"newColumnName": "aakey",
"newValueColumnName": "aavalue"
}
}
},
{
"key": "SparkPivotOperator_1635928422702",
"name": "行转列_1",
"type": "SparkPivotOperator",
"dataType": "Row",
"nodeStatus": "SUCCEEDED",
"operators": {
"pivotConf": {
"pivotField": "age",
"pivotFieldEnum": [
"aavalue"
],
"pivotFieldEnumAlias": [
"dsd"
],
"pivotValueField": {
"name": "aavalue",
"aggregation": "sum",
"value": "sum",
"distinct": false
},
"groupByFields": [
"aakey",
"birthday"
]
}
}
}
],
"flows": [
{
"from": "Read_asset_car_tob_pudongyongda_property_1603618594544",
"to": "reset_column_1603681051791",
"fromPort": "output",
"toPort": "input"
},
{
"from": "Read_asset_car_tob_pudongyongda_property_1603618594544",
"to": "SparkJoinOperator_1635927787704",
"fromPort": "output",
"toPort": "left"
},
{
"from": "Read_A111111_1635927769820",
"to": "SparkJoinOperator_1635927787704",
"fromPort": "output",
"toPort": "right"
},
{
"from": "SparkJoinOperator_1635927787704",
"to": "Load_1635927852514",
"fromPort": "output",
"toPort": "input"
},
{
"from": "Read_asset_car_tob_pudongyongda_property_1603618594544",
"to": "SparkUnionOperator_1635927905727",
"fromPort": "output",
"toPort": "multiInput"
},
{
"from": "SparkUnionOperator_1635927905727",
"to": "aggregation_1635928051887",
"fromPort": "output",
"toPort": "input"
},
{
"from": "aggregation_1635928051887",
"to": "compute_col_1635928149557",
"fromPort": "output",
"toPort": "input"
},
{
"from": "compute_col_1635928149557",
"to": "filter_row_1635928290715",
"fromPort": "output",
"toPort": "input"
},
{
"from": "filter_row_1635928290715",
"to": "SparkUnpivotOperator_1635928347743",
"fromPort": "output",
"toPort": "input"
},
{
"from": "SparkUnpivotOperator_1635928347743",
"to": "SparkPivotOperator_1635928422702",
"fromPort": "output",
"toPort": "input"
}
]
}
},
"scheduleConf": {
"dependencyNodes": [
{
"nodeKey": "Load_1635927852514",
"dependencyMethod": 0
}
]
}
}
观远算子
https://demo.guandata.com/data-flows/new
{
"version": 1,
"dataFlowId": "c96315bd8c74c4ce4aa3478d",
"name": "New Transform1111",
"parentDirId": "dec37b3c53b4341328dd9876",
"actions": [
{
"id": "id_1636446767144",
"name": "列转行",
"type": "COLLAPSE_COLUMNS",
"sources": [
"id_1636446380244"
],
"position": {
"x": 690,
"y": 320
},
"dimName": "列名称",
"metricName": "列值",
"columns": [
{
"name": "省份",
"newName": "省份"
}
],
"sameAsOld": false
},
{
"id": "id_1636445667563",
"name": "添加计算列",
"type": "CALCULATOR",
"sources": [
"id_1636445329495"
],
"position": {
"x": 370,
"y": 110
},
"formulas": [
{
"name": "订购取上限",
"type": "DOUBLE",
"expr": "CEIL([订购数量])",
"key": "KZagmUdZZf"
}
]
},
{
"id": "id_1636447345184",
"name": "Null值替换",
"type": "SINGLE_VALUE_MAPPER",
"sources": [
"id_1636447282500"
],
"position": {
"x": 100,
"y": 510
},
"mappings": [
{
"colName": "海南省",
"toValue": "000"
}
]
},
{
"id": "id_1636445346992",
"name": "1111",
"type": "OUTPUT_DATASET",
"sources": [],
"position": {
"x": 1320,
"y": 650
},
"outputDsName": "1111",
"outputDsDesc": "",
"parentDirId": "h1f1d5f35fa8c41f6a57d0ef",
"dataSource": {
"parentDirId": "h1f1d5f35fa8c41f6a57d0ef",
"parentDirName": "【提示】试用客户仅允许上传文件类型数据集。如需创建数据库数据集，请联系观远人员"
}
},
{
"id": "id_1636446331252",
"name": "选择列",
"type": "SELECt_COLUMNS",
"sources": [
"id_1636446213015"
],
"position": {
"x": 300,
"y": 320
},
"columns": [
{
"name": "城市",
"fdType": "STRING",
"metaType": "DIM",
"dsKey": "id_1636446213015",
"isIgnored": false,
"key": "tVxjzCKhwO",
"newName": "城市--改名了"
},
{
"name": "省份",
"fdType": "STRING",
"metaType": "DIM",
"dsKey": "id_1636446213015",
"isIgnored": false,
"key": "huLAdiSHCS"
},
{
"name": "区县",
"fdType": "STRING",
"metaType": "DIM",
"dsKey": "id_1636446213015",
"isIgnored": false,
"key": "xDnnEDJWRW"
},
{
"name": "商品分类",
"fdType": "STRING",
"metaType": "DIM",
"dsKey": "id_1636446213015",
"isIgnored": false,
"key": "ovmmfangND"
},
{
"name": "合并列",
"fdType": "STRING",
"metaType": "DIM",
"dsKey": "id_1636446213015",
"isIgnored": false,
"key": "ZEjJwtzRGt"
},
{
"name": "零售价",
"fdType": "DOUBLE",
"metaType": "METRIC",
"dsKey": "id_1636446213015",
"isIgnored": false,
"key": "gxajQmDcFU"
},
{
"name": "订购数量",
"fdType": "LONG",
"metaType": "METRIC",
"dsKey": "id_1636446213015",
"isIgnored": false,
"key": "QjLOgyHGOs"
},
{
"name": "订购取上限",
"fdType": "DOUBLE",
"metaType": "METRIC",
"dsKey": "id_1636446213015",
"isIgnored": false,
"key": "MajzCKZQEd"
}
]
},
{
"id": "id_1636447664441",
"name": "产品试用数据集",
"type": "INPUT_DATASET",
"sources": [],
"position": {
"x": 60,
"y": 680
},
"displayType": "CSV",
"inputDsId": "q13fcdaae7e3a40239371353",
"cascadeUpdateEnabled": false,
"preview": {
"scope": "ALL",
"config": {}
}
},
{
"id": "id_1636447223497",
"name": "去重",
"type": "REMOVE_DUPLICATES",
"sources": [
"id_1636447105689"
],
"position": {
"x": 1100,
"y": 320
},
"columnNames": [
"零售价"
]
},
{
"id": "id_1636447631696",
"name": "关联数据",
"type": "JOIN_DATA",
"sources": [
"id_1636447664441",
"id_1636447345184"
],
"position": {
"x": 260,
"y": 660
},
"dataFusion": {
"selectedColumns": [
{
"name": "城市--改名了",
"isIgnored": false,
"dsKey": "id_1636447345184",
"fdType": "STRING",
"metaType": "DIM"
},
{
"name": "区县",
"isIgnored": false,
"dsKey": "id_1636447345184",
"fdType": "STRING",
"metaType": "DIM"
},
{
"name": "商品分类",
"isIgnored": false,
"dsKey": "id_1636447345184",
"fdType": "STRING",
"metaType": "DIM"
},
{
"name": "合并列",
"isIgnored": false,
"dsKey": "id_1636447345184",
"fdType": "STRING",
"metaType": "DIM"
},
{
"name": "零售价",
"isIgnored": false,
"dsKey": "id_1636447345184",
"fdType": "DOUBLE",
"metaType": "METRIC"
},
{
"name": "订购数量",
"isIgnored": false,
"dsKey": "id_1636447345184",
"fdType": "LONG",
"metaType": "METRIC"
},
{
"name": "订购取上限",
"isIgnored": false,
"dsKey": "id_1636447345184",
"fdType": "DOUBLE",
"metaType": "METRIC"
},
{
"name": "海南省",
"isIgnored": false,
"dsKey": "id_1636447345184",
"fdType": "DOUBLE",
"metaType": "METRIC"
},
{
"name": "列名称",
"isIgnored": false,
"dsKey": "id_1636447345184",
"fdType": "STRING",
"metaType": "DIM"
},
{
"name": "列值",
"isIgnored": false,
"dsKey": "id_1636447345184",
"fdType": "STRING",
"metaType": "DIM"
},
{
"name": "新列值",
"isIgnored": false,
"dsKey": "id_1636447345184",
"fdType": "STRING",
"metaType": "DIM"
},
{
"name": "编号ID",
"isIgnored": false,
"dsKey": "id_1636447664441",
"fdType": "LONG",
"metaType": "METRIC"
},
{
"name": "省份",
"isIgnored": false,
"dsKey": "id_1636447664441",
"fdType": "STRING",
"metaType": "DIM"
},
{
"name": "省份代码",
"isIgnored": false,
"dsKey": "id_1636447664441",
"fdType": "LONG",
"metaType": "METRIC"
},
{
"name": "城市",
"isIgnored": false,
"dsKey": "id_1636447664441",
"fdType": "STRING",
"metaType": "DIM"
},
{
"name": "城市代码",
"isIgnored": false,
"dsKey": "id_1636447664441",
"fdType": "LONG",
"metaType": "METRIC"
},
{
"name": "区县",
"isIgnored": true,
"dsKey": "id_1636447664441",
"fdType": "STRING",
"metaType": "DIM"
},
{
"name": "区县代码",
"isIgnored": false,
"dsKey": "id_1636447664441",
"fdType": "LONG",
"metaType": "METRIC"
},
{
"name": "日期",
"isIgnored": false,
"dsKey": "id_1636447664441",
"fdType": "DATE",
"metaType": "DIM"
},
{
"name": "商品分类",
"isIgnored": true,
"dsKey": "id_1636447664441",
"fdType": "STRING",
"metaType": "DIM"
},
{
"name": "商品编号",
"isIgnored": false,
"dsKey": "id_1636447664441",
"fdType": "LONG",
"metaType": "METRIC"
},
{
"name": "商品条码",
"isIgnored": false,
"dsKey": "id_1636447664441",
"fdType": "LONG",
"metaType": "METRIC"
},
{
"name": "商品名称",
"isIgnored": false,
"dsKey": "id_1636447664441",
"fdType": "STRING",
"metaType": "DIM"
},
{
"name": "规格",
"isIgnored": false,
"dsKey": "id_1636447664441",
"fdType": "STRING",
"metaType": "DIM"
},
{
"name": "单位",
"isIgnored": false,
"dsKey": "id_1636447664441",
"fdType": "STRING",
"metaType": "DIM"
},
{
"name": "产地",
"isIgnored": false,
"dsKey": "id_1636447664441",
"fdType": "STRING",
"metaType": "DIM"
},
{
"name": "库存状况",
"isIgnored": false,
"dsKey": "id_1636447664441",
"fdType": "STRING",
"metaType": "DIM"
},
{
"name": "含税价",
"isIgnored": false,
"dsKey": "id_1636447664441",
"fdType": "DOUBLE",
"metaType": "METRIC"
},
{
"name": "零售价",
"isIgnored": true,
"dsKey": "id_1636447664441",
"fdType": "DOUBLE",
"metaType": "METRIC"
},
{
"name": "订购数量",
"isIgnored": true,
"dsKey": "id_1636447664441",
"fdType": "LONG",
"metaType": "METRIC"
},
{
"name": "销售金额",
"isIgnored": false,
"dsKey": "id_1636447664441",
"fdType": "DOUBLE",
"metaType": "METRIC"
},
{
"name": "配送数",
"isIgnored": false,
"dsKey": "id_1636447664441",
"fdType": "LONG",
"metaType": "METRIC"
},
{
"name": "销售数量",
"isIgnored": false,
"dsKey": "id_1636447664441",
"fdType": "LONG",
"metaType": "METRIC"
},
{
"name": "经度",
"isIgnored": false,
"dsKey": "id_1636447664441",
"fdType": "DOUBLE",
"metaType": "METRIC"
},
{
"name": "纬度",
"isIgnored": false,
"dsKey": "id_1636447664441",
"fdType": "DOUBLE",
"metaType": "METRIC"
},
{
"name": "大区",
"isIgnored": false,
"dsKey": "id_1636447664441",
"fdType": "STRING",
"metaType": "DIM"
}
],
"fusionType": "COLUMN",
"dataSources": [
{
"key": "id_1636447345184",
"name": "Null值替换"
},
{
"key": "id_1636447664441",
"name": "产品试用数据集"
}
],
"columnFuses": [
{
"leftKey": "id_1636447345184",
"rightKey": "id_1636447664441",
"joinType": "INNER",
"predicates": [
{
"leftColumn": "城市--改名了",
"rightColumn": "城市"
}
]
},
{
"leftKey": "id_1636447345184",
"rightKey": "id_1636447664441",
"joinType": "INNER",
"predicates": [
{
"leftColumn": "商品分类",
"rightColumn": "商品分类"
}
]
}
]
}
},
{
"id": "id_1636446213015",
"name": "分组聚合",
"type": "GROUP_BY",
"sources": [
"id_1636446121728"
],
"position": {
"x": 150,
"y": 320
},
"zoneData": {
"row": [
{
"editable": true,
"zoneId": "row",
"name": "城市",
"granularity": null,
"parentFdName": null,
"fdType": "STRING",
"fdId": "i1f14cab21d204ff2a38c754",
"removable": true,
"key": "MbkvqwauZy",
"metaType": "DIM"
},
{
"editable": true,
"zoneId": "row",
"name": "省份",
"granularity": null,
"parentFdName": null,
"fdType": "STRING",
"fdId": "m8b4521ee84b54ee19177c5b",
"removable": true,
"key": "WYaoSjjYdA",
"metaType": "DIM"
},
{
"editable": true,
"zoneId": "row",
"name": "区县",
"granularity": null,
"parentFdName": null,
"fdType": "STRING",
"fdId": "xe8e65b3e380248c2a335a49",
"removable": true,
"key": "AwuSOKbegi",
"metaType": "DIM"
},
{
"editable": true,
"zoneId": "row",
"name": "商品分类",
"granularity": null,
"parentFdName": null,
"fdType": "STRING",
"fdId": "v8e82a56e45c2462497937c8",
"removable": true,
"key": "XizGnFhygQ",
"metaType": "DIM"
},
{
"editable": true,
"zoneId": "row",
"name": "合并列",
"granularity": null,
"parentFdName": null,
"fdType": "STRING",
"removable": true,
"key": "vWYEFynVZf",
"metaType": "DIM"
}
],
"metric": [
{
"editable": true,
"zoneId": "metric",
"aggrType": "SUM",
"name": "零售价",
"label": "",
"fdType": "DOUBLE",
"fdId": "o3f9005fd812c445cbd37427",
"removable": true,
"key": "hJecyggkUq",
"metaType": "METRIC"
},
{
"editable": true,
"zoneId": "metric",
"aggrType": "SUM",
"name": "订购数量",
"label": "",
"fdType": "LONG",
"fdId": "uf1e3f10c2b0442b689cfd1c",
"removable": true,
"key": "DjdstXekYU",
"metaType": "METRIC"
},
{
"editable": true,
"zoneId": "metric",
"aggrType": "SUM",
"name": "订购取上限",
"label": "",
"fdType": "DOUBLE",
"removable": true,
"key": "XgiDAntgFR",
"metaType": "METRIC"
}
]
},
"newDim": [],
"newMetric": []
},
{
"id": "id_1636447105689",
"name": "筛选数据行",
"type": "FILTER_ROWS",
"sources": [
"id_1636446767144"
],
"position": {
"x": 860,
"y": 310
},
"conditions": [
{
"name": "城市--改名了",
"filterType": "STARTSWITH",
"fdType": "STRING",
"filterValue": [
{
"v": "南阳市",
"type": "VALUE"
}
]
}
],
"combineType": "OR"
},
{
"id": "id_1636446380244",
"name": "行转列",
"type": "UNCOLLAPSE_COLUMNS",
"sources": [
"id_1636446331252"
],
"position": {
"x": 470,
"y": 320
},
"column": "省份",
"aggrColumn": "订购取上限",
"aggrType": "NUL",
"groupBy": [
"城市--改名了",
"省份",
"区县",
"商品分类",
"合并列",
"零售价",
"订购数量",
"订购取上限"
],
"sameAsOld": true,
"fields": [
{
"targetName": "海南省",
"keyValue": "海南省",
"key": "JvOzNoFIdO"
}
]
},
{
"id": "id_1636448121368",
"name": "qyj",
"type": "OUTPUT_DATASET",
"sources": [
"id_1636447849440"
],
"position": {
"x": 720,
"y": 700
},
"outputDsName": "qyj",
"outputDsDesc": "",
"parentDirId": "h1f1d5f35fa8c41f6a57d0ef",
"dataSource": {
"parentDirId": "h1f1d5f35fa8c41f6a57d0ef",
"parentDirName": "【提示】试用客户仅允许上传文件类型数据集。如需创建数据库数据集，请联系观远人员"
}
},
{
"id": "id_1636447282500",
"name": "值替换",
"type": "VALUE_MAPPER",
"sources": [
"id_1636447223497"
],
"position": {
"x": 1230,
"y": 340
},
"column": "城市--改名了",
"targetField": "新列值",
"defaultValue": {
"value": null,
"fromColumn": "城市--改名了"
},
"mappings": [
{
"from": "南阳市",
"to": "南阳"
}
]
},
{
"id": "id_1636446121728",
"name": "合并列",
"type": "COMBINE_COLUMNS",
"sources": [
"id_1636445667563"
],
"position": {
"x": 640,
"y": 120
},
"targetFieldName": "合并列",
"separator": ",",
"removeSelectedFields": false,
"fields": [
"订购取上限",
"大区",
"纬度",
"经度"
]
},
{
"id": "id_1636447849440",
"name": "SQL输入",
"type": "SQL_script",
"sources": [
"id_1636447631696"
],
"position": {
"x": 480,
"y": 690
},
"sql": "SELECT *, input1.`经度`+input1.`纬度` AS he from input1",
"sqlStatus": "valid",
"schemaStatus": "verified"
},
{
"id": "id_1636445329495",
"name": "产品试用数据集",
"type": "INPUT_DATASET",
"sources": [],
"position": {
"x": 40,
"y": 95
},
"displayType": "CSV",
"inputDsId": "q13fcdaae7e3a40239371353",
"cascadeUpdateEnabled": false,
"preview": {
"scope": "ALL",
"config": {}
}
}
],
"config": {
"priority": "HIGH",
"timeoutLimitInMinutes": ""
},
"annotation": {
"list": [],
"hidden": true
},
"triggerType": "MANUALLY"
}
