# 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访问地址](http://192.168.10.7:8087/xxl-job-admin)

admin
@XXL-job133413

## 统计各小时数据

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

## 检查重复数据
```sql
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;
```