1、-ne_idselect extend(extend(current,year to hour),year to second) first_result,tcc_ne_press_date compress_date,tcc_ne_frame.related_ne2 ne_id,130 ne_type, time_id,time_type,s_hour,s_weekday,s_month, sum(total_bsc) total_bsc,sum(total_btssite) total_btssite,sum(total_cell) total_cell,sum(single_cell)
2、single_cell,sum(double_cell) double_cell,sum(treble_cell) treble_cell,sum(four_cell) four_cell,sum(micro_total_cell) micro_total_cell,sum(repeater_nbr) repeater_nbr,sum(total_traffic_ch) total_traffic_ch,sum(total_signal_ch) total_signal_ch,sum(total_carrier) total_carrier,sum(radio_capacity) radio_
3、capacity,sum(0) total_hlr,sum(total_9btssite) total_9btssite,sum(total_18btssite) total_18btssite,sum(total_18carrier) total_18carrier,sum(total_18cell) total_18cell,sum(total_18traf_ch) total_18traf_chfrom tpa_gsma_unic_sum,tcc_ne_framewhere tpa_gsma_unic_sum.first_result=extend(date(current)-0,yea
4、r to second) and tpa_gsma_unic_sum.ne_type = 200and tcc_ne_frame.ne_id= tpa_gsma_unic_sum.ne_idand tcc_ne_frame.related_type2=130group by 1,2,3,5,6,7,8,9 into temp zsq001_bsc with no log;- tpa_gsma_unic_sumselect * from tpa_gsma_unic_sum where first_result=extend(date(current)-0,year to second) and
5、ne_type = 200 - ne_id tcc_ne_framerelated_ne2select * from tcc_ne_frame where related_type2=130 and ne_id in (-2074216710,-2036715905,-1874654102,-1779299273,-1711906792,-1710065966,-1709392599,-1595863831,-1236134305,-1165521925,-1051384119,-998751257,-971396116,-847201427,-610236726,-551636258,-53
6、4120219,-414958340,-258466768,-125588491,-94332420,6644118,54171907,72834330,144935298,265178523,357922308,416395888,681030332,698675848,708351594,779006628,794511333,949747350,983093334,1287292616,1335676416,1338682153,1351789631,1482454899,1524954243,1564452604,1597092714,1612268867,1852103550,195
7、0198165,1973289494,2012946797,2026470669,2125228131);-related_ne1int_idobjectsrelated_ne1realted_ne2select related_ne1,object_class,* from nrmdb:objects where int_id=1257844101;select related_ne1,object_class,* from nrmdb:objects where int_id=-551703392;select related_ne1,object_class,* from nrmdb:o
8、bjects where int_id=157305046;update tcc_ne_frame set related_ne2=1564173633 where ne_id=-1236134305 and related_ne1=1257844101;update tcc_ne_frame set related_ne2=1564173633 where ne_id=-1051384119 and related_ne1=-551703392;update tcc_ne_frame set related_ne2=1564173633 where ne_id=1597092714 and
9、related_ne1=-551703392;update tcc_ne_frame set related_ne2=776143755 where ne_id=144935298 and related_ne1=157305046;update nrmdb:objects set related_ne2=1564173633 where int_id =-1236134305 ;update nrmdb:objects set related_ne2=1564173633 where int_id =-1051384119;update nrmdb:objects set related_ne2=1564173633 where int_id =1597092714 ;update nrmdb:objects set related_ne2=776143755 where int_id =144935298 ;-.8/export/home/npmuser/zsq/tpa_gsma_unic_sw_sum.sh
