| 12345678910111213141516171819202122 |
- select station_sid,cell_oid,siteid,kid --AAUµÄÊÇ¿òºÅ
- from sqmdb_cost.station_aau
- select distinct station_sid,cid,
- (regexp_split_to_array(cid,'\.'))[2] as siteid,
- (regexp_split_to_array(cid,'\.'))[3] as ci
- from
- (select station_sid,unnest(string_to_array(cell_oid,'|')) as cid from sqmdb_cost.station_rru) r
- select r2.station_sid,se.enodeb_id
- from sqmdb_cost.sc_enodeb se
- join sqmdb_cost.roomid ri
- on se.room_id=ri.room_id
- join sqmdb_cost.room r2
- on ri.room_sid=r2.room_sid
- select r2.station_sid,sg.gnodeb_id
- from sqmdb_cost.sc_gnodeb sg
- join sqmdb_cost.roomid ri
- on sg.room_id=ri.room_id
- join sqmdb_cost.room r2
- on ri.room_sid=r2.room_sid
|
