【Mysql系列】数据集算子数据结构

2023-09-25 7 0

💝💝💝欢迎来到我的博客,很高兴能够在这里和您见面!希望您在这里可以感受到一份轻松愉快的氛围,不仅可以获得有趣的内容和知识,也可以畅所欲言、分享您的想法和见解。
img

  • 推荐:kuan 的首页,持续学习,不断总结,共同进步,活到老学到老
  • 导航
    • 檀越剑指大厂系列:全面总结 java 核心技术点,如集合,jvm,并发编程 redis,kafka,Spring,微服务,Netty 等
    • 常用开发工具系列:罗列常用的开发工具,如 IDEA,Mac,Alfred,electerm,Git,typora,apifox 等
    • 数据库系列:详细总结了常用数据库 mysql 技术点,以及工作中遇到的 mysql 问题等
    • 懒人运维系列:总结好用的命令,解放双手不香吗?能用一个命令完成绝不用两个操作
    • 数据结构与算法系列:总结数据结构和算法,不同类型针对性训练,提升编程思维,剑指大厂

非常期待和您一起在这个小小的网络世界里共同探索、学习和成长。💝💝💝 ✨✨ 欢迎订阅本专栏 ✨✨

博客目录

    • 一.火山引擎算子
    • 二.观远算子

一.火山引擎算子

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"
}

觉得有用的话点个赞 👍🏻 呗。

❤️❤️❤️本人水平有限,如有纰漏,欢迎各位大佬评论批评指正!😄😄😄

💘💘💘如果觉得这篇文对你有帮助的话,也请给个点赞、收藏下吧,非常感谢!👍 👍 👍

🔥🔥🔥Stay Hungry Stay Foolish 道阻且长,行则将至,让我们一起加油吧!🌙🌙🌙

img

代码编程
赞赏

相关文章

Google以21亿美元的价格收购了健康追踪器Fitbit
增长模型拆解:分享有礼裂变玩法的底层逻辑与细节设计
怎么做好B端数据运营?
基于两个实际案例,分享自己2020年运营的一些心得
数字化营销时代:企业如何从“推时代”进阶“拉时代”
谷歌三星杀进来了,高通为啥一点不怕?