dm_brd.dm_cfg_bast_f_base_term
2022-10-28 12:02:33 3 举报
AI智能生成
登录查看完整内容
逻辑梳理
作者其他创作
大纲/内容
dwd_mobile_5gps_n11_h_inc c where rat = 10 (无线接入类型=5G SA/NR)and hour_id>=00 and hour_id<=23'1' as is_support_nsa_sa
ads_pub_zhw_1_versi_brand_dwhere ( brand is not null and brand <> '' and os_type <> 'IOS') or ( os_type = 'IOS' and firmware_ostype='' )
mid_pub_5g_ai_tac_new2_d_inc
dm_brd.dm_cfg_bast_f_base_terminal_all_m
mid_pub_mobile_device_2g_type_d_last
ADS_PUB_ZHW_1_BRAND_FIRMWARE_D终端品牌规范化分类
dwd_mobile_5gps_n11_h_inc t1
mid_pub_5g_ai_tac_new2_d_inc t2
mid_pub_msisdn7_belong_d_last t3
t1 left join t2t1 left join t3
DM_USE_LOGIN_5G_USER_LIST_Dterminal_brand和terminal_type数据加工
1.补充IOS软件版本的时候排除掉操作系统为IOS ,固件版本有信息的数据2.关联条件添加上imeimid_pub_5g_ai_tac_new2_d_incwhere h.terminal_brand='苹果'
ADS_PUB_ZHW_1_VERSI_BRAND_D
mid_pub_5g_ai_tac_new_d_inc
dws_user_profile_info_d_inc
子主题
ADS_PUB_ZHW_3_TML_FIRMWARE_D5G终端 = 1D跟踪区更新中的5g终端的固件版本号软件是否支持
ads_pub_zhw_3_tml_firmware_d
ads_pub_zhw_1_brand_firmware_d 固件型号case when (b.tac is null and b.firmware_version is null) then '0' when (b.tac is not null and b.firmware_version is not null) then '1' else '2' end as is_support_5g_sa
ads_pub_zhw_3_5g_tml_firm_d
ue_5g_flag as is_5g_openfont color=\"#ff0000\
ADS_PUB_ZHW_3_5G_TML_FIRM_D
ADS_PUB_ZHW_3_TML_STATISTICS_D
dim_pub_mobile_device_type_m_ss
ads_pub_zhw_3_terminal_merge_new_d1.软件识别优先级:硬件不支持 软件支持,修改软件支持为不支持 其他情况依据识别结果2.sa开关识别优先级:硬件不支持,sa开关打开,修改sa开关为关闭3.软件不支持,sa开关打开,修改sa开关为关闭 ,其他情况依据识别结果
ads_pub_zhw_3_terminal_merge_new_dcase when sum(a.used_5g_SA)>0 or sum(a.used_5g_NSA)>0 then 'TRUE' when sum(a.is_5g_open)>0 then 'TRUE' WHEN sum(a.is_5g_open)=0 THEN 'FALSE' ELSE 'NULL' END AS is_5g_open
dws_user_profile_location_insight_d_inc
dws_user_serviceaware_exp_d_inc
ads_PUB_ZHW_3_TML_STATISTICS_MID_Dis_5g_open
mid_pub_city_region_d_last
mid_pub_province_region_d_last
mid_pub_msisdn7_belong_d_last
ads_pub_zhw_3_tml_statistics_mid_d
ads_PUB_ZHW_3_TML_STATISTICS_D
ADS_PUB_ZHW_3_STATISTICS_RESLUT_D
dm_use_5g_tml_statistics_datatraffic_d
ads_pub_zhw_3_tml_statistics_d
dm_use_5g_tml_statistics_reslut_d
mid_pub_mobile_device_type_d_last dwhere miit5g=1 硬件5G
mid_pub_5g_ai_tac_new_d_inc b
三张表全连接,按bdc的顺序取不为空的值case when b.is_support_nsa_sa is not null then b.is_support_nsa_sa when d.miit5g is not null then d.miit5g else c.is_support_nsa_sa end as is_support_nsa_sa
mid_pub_5g_ai_tac_new2_d_incis_support_nsa_sa数据加工
mid_pub_5g_ai_tac_new_d_inc更新机制:用mid前一天的数据union all dm_brd合并以后,取最早的一条数据mid_ref_5g_sansa_imei_taclength(imei_tac_5g)=8
dm_brd.dm_cfg_bast_f_base_terminal_all_m'1' as is_support_nsa_sawhere terminal_type_5g='1'
0 条评论
回复 删除
下一页