1 DEFINE{query_name 'reconfig_status_start';}
3 select timestamp_ms as timestamp,
4 non_temporal(timestamp_ms) as start_time,
6 id_MeNB_UE_X2AP_ID as eUE_ID,
9 from SGNB_ADDITION_REQ.sgnb_addreq_for_ue
13 DEFINE{query_name 'reconfig_status_success';
16 select timestamp_ms as timestamp,
18 non_temporal(timestamp_ms) as end_time,
19 id_MeNB_UE_X2AP_ID as eUE_ID,
22 from RECONCOMPLETE.reconfig_success
26 DEFINE{query_name 'reconfig_status_events';}
28 merge p1.timestamp : p2.timestamp
29 from reconfig_status_start p1, reconfig_status_success p2
33 DEFINE{query_name 'reconfig_status_merge';
34 max_lfta_disorder '1'; max_hfta_disorder '1';
37 select eUE_ID, gnb_id, TB,
38 max(start_time) as max_start_time,
39 max(end_time) as max_end_time
40 from reconfig_status_events
41 group by eUE_ID, gnb_id, timestamp / $window as TB
44 DEFINE{query_name 'reconfig_status_success_rate';
45 max_lfta_disorder '1'; max_hfta_disorder '1';
46 comment 'fraction of DC connect requests which are successful';
49 select gnb_id as GNB_ID,
50 ($window*(TB+1))/1000 as TS,
51 $window/1000.0 as measurementInterval,
52 count(*) as total_reconfiguration_requests,
53 sum(GEQ(max_end_time,ULLONG(1))) as successful_reconfiguration_requests,
54 FLOAT(sum(GEQ(max_end_time,ULLONG(1))))/count(*) as success_rate
55 from reconfig_status_merge
59 // ----------------------------------------------
60 // Merge in reconfig_reject causes and aggregate with this.
61 DEFINE{query_name 'reconfig_status_reject_cause';
62 max_lfta_disorder '1'; max_hfta_disorder '1';
63 comment 'distribution of causes for DC rejection';
67 count(*) as total_reconfig_reject,
68 sum(GEQ(UINT(cause_radio_network),0)) as count_radio_network,
69 sum(GEQ(UINT(cause_transport),0)) as count_transport,
70 sum(GEQ(UINT(cause_protocol),0)) as count_protocol,
71 sum(GEQ(UINT(cause_misc),0)) as count_misc
72 from ADDREQREJECT.sgnb_add_req_reject
74 group by gnb_id, timestamp_ms / $window as TB
77 DEFINE{query_name 'reconfig_complete_reject_cause';
78 max_lfta_disorder '1'; max_hfta_disorder '1';
82 count(*) as total_reconfig_reject,
83 sum(GEQ(UINT(cause_radio_network),0)) as count_radio_network,
84 sum(GEQ(UINT(cause_transport),0)) as count_transport,
85 sum(GEQ(UINT(cause_protocol),0)) as count_protocol,
86 sum(GEQ(UINT(cause_misc),0)) as count_misc
87 from RECONCOMPLETE.reconfig_reject
89 group by gnb_id, timestamp_ms / $window as TB
92 DEFINE{query_name 'reconfig_reject_merge';}
95 from reconfig_status_reject_cause p1, reconfig_complete_reject_cause p2
98 DEFINE{query_name 'reconfig_reject_cause';
99 max_lfta_disorder '1'; max_hfta_disorder '1';
101 PARAM{ window uint; }
102 Select gnb_id as GNB_ID, ($window*(TB+1))/1000 as TS,
103 $window/1000.0 as measurementInterval,
104 sum(total_reconfig_refuse) as total_reconfig_refuse,
105 sum(count_radio_network) as count_radio_network,
106 sum(count_transport) as count_transport,
107 sum(count_protocol) as count_protocol,
108 sum(count_misc) as count_misc
109 from reconfig_cause_merge
113 // ----------------------------------------------
115 DEFINE{query_name 'mod_status_refuse_cause';
116 max_lfta_disorder '1'; max_hfta_disorder '1';
117 comment 'distribution of causes for a sgnb modification refusal';
119 PARAM{ window uint; }
120 Select gnb_id as GNB_ID, ($window*(TB+1))/1000 as TS,
121 $window/1000.0 as measurementInterval,
122 count(*) as total_reconfig_refuse,
123 sum(GEQ(UINT(cause_radio_network),0)) as count_radio_network,
124 sum(GEQ(UINT(cause_transport),0)) as count_transport,
125 sum(GEQ(UINT(cause_protocol),0)) as count_protocol,
126 sum(GEQ(UINT(cause_misc),0)) as count_misc
127 from SGNBMODREFUSE.sgnb_mod_refuse
128 // where schemaId=1401
129 group by gnb_id, timestamp_ms / $window as TB
132 // ----------------------------------------------
133 DEFINE{query_name 'release_rqd_cause';
134 max_lfta_disorder '1'; max_hfta_disorder '1';
136 PARAM{ window uint; }
138 count(*) as total_reconfig_refuse,
139 sum(GEQ(UINT(cause_radio_network),0)) as count_radio_network,
140 sum(GEQ(UINT(cause_transport),0)) as count_transport,
141 sum(GEQ(UINT(cause_protocol),0)) as count_protocol,
142 sum(GEQ(UINT(cause_misc),0)) as count_misc
143 from SGNBRELEASERQD.SgNB_release_rqd
144 // where schemaId=1001
145 group by gnb_id, timestamp_ms / $window as TB
148 DEFINE{query_name 'release_request_cause';
149 max_lfta_disorder '1'; max_hfta_disorder '1';
151 PARAM{ window uint; }
153 count(*) as total_reconfig_refuse,
154 sum(GEQ(UINT(cause_radio_network),0)) as count_radio_network,
155 sum(GEQ(UINT(cause_transport),0)) as count_transport,
156 sum(GEQ(UINT(cause_protocol),0)) as count_protocol,
157 sum(GEQ(UINT(cause_misc),0)) as count_misc
158 from RELREQ.release_req
159 // where schemaId=801
160 group by gnb_id, timestamp_ms / $window as TB
163 DEFINE{query_name 'reconfig_cause_merge';}
164 PARAM{ window uint; }
166 from release_rqd_cause p1, release_request_cause p2
169 DEFINE{query_name 'release_cause';
170 max_lfta_disorder '1'; max_hfta_disorder '1';
171 comment 'distribution of the causes of a DC release';
173 PARAM{ window uint; }
174 Select gnb_id as GNB_ID, ($window*(TB+1))/1000 as TS,
175 $window/1000.0 as measurementInterval,
176 sum(total_reconfig_refuse) as total_reconfig_refuse,
177 sum(count_radio_network) as count_radio_network,
178 sum(count_transport) as count_transport,
179 sum(count_protocol) as count_protocol,
180 sum(count_misc) as count_misc
181 from reconfig_cause_merge