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

admin Richr00t#

统计各小时数据

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;