pm_5g

5gpm数据导入

正式环境部署位置

192.168.10.7/data/pm_5g

测试环境部署位置

192.168.50.3/data1/pm_5g

pm数据接口

当前lte pm数据入库程序部署位置 133.96.94.108 /data1/pm

5Gpm小时数据导出：10.17.180.55:/data/out2/pm_5g_hour/pm_5g_hour_2022072910.csv

数据源 10.17.180.55 /data/out2/pm_4g_hour pm_4g_hour_2022053005.csv

133.96.94.19 esbftp Esb2019ftp! nokia Nokia*123

xxl-job-server访问地址

admin @XXL-job133413

统计各小时数据

select rpt_time,
       count(1)
from tsfx.dw_sa_omc_ci_h
group by rpt_time
order by rpt_time desc;

检查重复数据

select nci,
       count(1)
from tsfx.dw_sa_omc_ci_h
where rpt_time = '2022-12-25 19:00:00'
group by nci
having count(1) > 1;