dm_brd.dm_cfg_bast_f_base_term
2022-10-28 12:02:33 3 举报
AI智能生成
逻辑梳理
作者其他创作
大纲/内容
mid_pub_5g_ai_tac_new_d_inc<br>更新机制:<br>用mid前一天的数据union all dm_brd合并以后,<br>取最早的一条数据<br><br>mid_ref_5g_sansa_imei_tac<br>length(imei_tac_5g)=8<br>
mid_pub_5g_ai_tac_new2_d_inc
ADS_PUB_ZHW_1_BRAND_FIRMWARE_D<br>终端品牌规范化分类
dwd_mobile_5gps_n11_h_inc c<br> where rat = 10 (无线接入类型=5G SA/NR)<br>and hour_id>=00 and hour_id<=23<br>'1' as is_support_nsa_sa
ads_pub_zhw_1_versi_brand_d<br>where ( brand is not null<br> and brand <> ''<br> and os_type <> 'IOS')<br> or ( os_type = 'IOS'<br> and firmware_ostype='' )<br>
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
DM_USE_LOGIN_5G_USER_LIST_D<br>terminal_brand和terminal_type数据加工<br>
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 t2<br>t1 left join t3
ADS_PUB_ZHW_3_TML_FIRMWARE_D<br>5G终端 = 1<br>D跟踪区更新中的5g终端的固件版本号<br>软件是否支持<br>
子主题
1.补充IOS软件版本的时候排除掉操作系统为IOS ,固件版本有信息的数据<br>2.关联条件添加上imei<br>mid_pub_5g_ai_tac_new2_d_inc<br>where h.terminal_brand='苹果'<br>
ADS_PUB_ZHW_1_VERSI_BRAND_D
mid_pub_5g_ai_tac_new_d_inc
dws_user_profile_info_d_inc
子主题
mid_pub_5g_ai_tac_new2_d_inc<br>is_support_nsa_sa数据加工<br>
dwd_mobile_5gps_n11_h_inc c<br> where rat = 10 (无线接入类型=5G SA/NR)<br>and hour_id>=00 and hour_id<=23<br>'1' as is_support_nsa_sa<br>
mid_pub_mobile_device_type_d_last d<br>where miit5g=1 硬件5G<br>
mid_pub_5g_ai_tac_new_d_inc b
三张表全连接,按bdc的顺序取不为空的值<br>case when <br>b.is_support_nsa_sa is not null then b.is_support_nsa_sa <br>when d.miit5g is not null then d.miit5g <br>else c.is_support_nsa_sa end as is_support_nsa_sa<br>
0 条评论
下一页