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
12 DEFINE{query_name 'reconfig_status_success';
15 select timestamp_ms as timestamp,
17 non_temporal(timestamp_ms) as end_time,
18 id_MeNB_UE_X2AP_ID as eUE_ID,
21 from RECONCOMPLETE.reconfig_success
24 DEFINE{query_name 'reconfig_status_events';}
26 merge p1.timestamp : p2.timestamp
27 from reconfig_status_start p1, reconfig_status_success p2
31 DEFINE{query_name 'reconfig_status_merge';
32 max_lfta_disorder '1'; max_hfta_disorder '1';
35 select eUE_ID, gnb_id, TB,
36 max(start_time) as max_start_time,
37 max(end_time) as max_end_time
38 from reconfig_status_events
39 group by eUE_ID, gnb_id, timestamp / $window as TB
42 DEFINE{query_name 'reconfig_status_success_rate';
43 max_lfta_disorder '1'; max_hfta_disorder '1';
44 comment 'fraction of DC connect requests which are successful';
47 select gnb_id as GNB_ID,
48 ($window*(TB+1))/1000 as TS,
49 $window/1000.0 as measurementInterval,
50 count(*) as total_reconfiguration_requests,
51 sum( GEQ(max_end_time,1) ) as successful_reconfiguration_requests,
52 (1.0*sum( GEQ( max_end_time,1) ))/count(*) as success_rate,
53 1.0 - ( (1.0*sum( GEQ( max_end_time,1) ))/count(*) ) as failure_rate
54 from reconfig_status_merge
58 DEFINE{query_name 'reconfig_status_join';
59 max_lfta_disorder '1'; max_hfta_disorder '1';
60 comment 'Associate gtp_teid using eUE_ID';
63 Select r.eUE_ID, M.gTP_TEID, r.gnb_id, r.TB,
64 r.max_start_time, r.max_end_time
65 INNER_JOIN from reconfig_status_merge r, gnb_ueid_teid_map M
66 where r.eUE_ID=M.id_MeNB_UE_X2AP_ID and r.gnb_id=M.GNB_ID and r.TB=M.TB
69 DEFINE{query_name 'reconfig_status_success_rate_gtp_teid';
70 max_lfta_disorder '1'; max_hfta_disorder '1';
71 comment 'fraction of DC connect requests which are successful, on a per-user (gtp_teid) basis.';
74 select gnb_id as GNB_ID, gTP_TEID,
75 ($window*(TB+1))/1000 as TS,
76 $window/1000.0 as measurementInterval,
77 count(*) as total_reconfiguration_requests,
78 sum( GEQ(max_end_time,1) ) as successful_reconfiguration_requests,
79 (1.0*sum( GEQ( max_end_time,1) ))/count(*) as success_rate,
80 1.0 - ( (1.0*sum( GEQ( max_end_time,1) ))/count(*) ) as failure_rate
81 from reconfig_status_join
82 group by gnb_id, gTP_TEID, TB
86 // ----------------------------------------------
87 // Merge in reconfig_reject causes and aggregate with this.
88 DEFINE{query_name 'reconfig_status_reject_cause';
89 max_lfta_disorder '1'; max_hfta_disorder '1';
90 comment 'distribution of causes for DC rejection';
93 Select gnb_id as GNB_ID, TB,
94 count(*) as total_reconfig_reject,
95 sum( GEQ(cause_radio_network,0) ) as count_radio_network,
96 sum( GEQ(cause_transport,0) ) as count_transport,
97 sum( GEQ(cause_protocol,0) ) as count_protocol,
98 sum( GEQ(cause_misc,0) ) as count_misc
99 from ADDREQREJECT.sgnb_add_req_reject
100 group by gnb_id, timestamp_ms / $window as TB
103 DEFINE{query_name 'reconfig_status_reject_join';
104 max_lfta_disorder '1'; max_hfta_disorder '1';
105 comment 'Associate gtp_teid using eUE_ID';
107 PARAM{ window uint; }
108 Select r.id_MeNB_UE_X2AP_ID, M.gTP_TEID, r.gnb_id, M.TB,
109 r.cause_radio_network, r.cause_transport,
110 r.cause_protocol, r.cause_misc
111 INNER_JOIN from ADDREQREJECT.sgnb_add_req_reject r, gnb_ueid_teid_map M
112 where r.id_MeNB_UE_X2AP_ID=M.id_MeNB_UE_X2AP_ID and r.gnb_id=M.GNB_ID
113 and r.timestamp_ms/$window=M.TB
116 DEFINE{query_name 'reconfig_status_reject_cause_gtp_teid';
117 max_lfta_disorder '1'; max_hfta_disorder '1';
118 comment 'distribution of causes for DC rejection on a per-ue (gtp-teid) basis';
120 PARAM{ window uint; }
121 Select gnb_id as GNB_ID, gTP_TEID, TB,
122 count(*) as total_reconfig_reject,
123 sum( GEQ(cause_radio_network,0) ) as count_radio_network,
124 sum( GEQ(cause_transport,0) ) as count_transport,
125 sum( GEQ(cause_protocol,0) ) as count_protocol,
126 sum( GEQ(cause_misc,0) ) as count_misc
127 from reconfig_status_reject_join
128 group by gnb_id, gTP_TEID, TB
131 DEFINE{query_name 'reconfig_complete_reject_cause';
132 max_lfta_disorder '1'; max_hfta_disorder '1';
134 PARAM{ window uint; }
136 count(*) as total_reconfig_reject,
137 sum( GEQ(cause_radio_network,0) ) as count_radio_network,
138 sum( GEQ(cause_transport,0) ) as count_transport,
139 sum( GEQ(cause_protocol,0) ) as count_protocol,
140 sum( GEQ(cause_misc,0) ) as count_misc
141 from RECONCOMPLETE.reconfig_reject
142 group by gnb_id, timestamp_ms / $window as TB
145 DEFINE{query_name 'reconfig_reject_merge';}
146 PARAM{ window uint; }
148 from reconfig_status_reject_cause p1, reconfig_complete_reject_cause p2
151 DEFINE{query_name 'reconfig_reject_cause';
152 max_lfta_disorder '1'; max_hfta_disorder '1';
154 PARAM{ window uint; }
155 Select gnb_id as GNB_ID, ($window*(TB+1))/1000 as TS,
156 $window/1000.0 as measurementInterval,
157 sum(total_reconfig_refuse) as total_reconfig_refuse,
158 sum(count_radio_network) as count_radio_network,
159 sum(count_transport) as count_transport,
160 sum(count_protocol) as count_protocol,
161 sum(count_misc) as count_misc
162 from reconfig_cause_merge
166 // ----------------------------------------------
168 DEFINE{query_name 'mod_status_refuse_cause_base';
169 max_lfta_disorder '1'; max_hfta_disorder '1';
170 comment 'distribution of causes for a sgnb modification refusal (base)';
172 PARAM{ window uint; }
173 Select gnb_id as GNB_ID, TB,
174 id_MeNB_UE_X2AP_ID, id_SgNB_UE_X2AP_ID,
175 count(*) as total_reconfig_refuse,
176 sum( GEQ(cause_radio_network,0) ) as count_radio_network,
177 sum( GEQ(cause_transport,0) ) as count_transport,
178 sum( GEQ(cause_protocol,0) ) as count_protocol,
179 sum( GEQ(cause_misc,0) ) as count_misc
180 from SGNBMODREFUSE.sgnb_mod_refuse
181 group by gnb_id, timestamp_ms / $window as TB,
182 id_MeNB_UE_X2AP_ID, id_SgNB_UE_X2AP_ID
185 DEFINE{query_name 'mod_status_refuse_cause';
186 max_lfta_disorder '1'; max_hfta_disorder '1';
187 comment 'distribution of causes for a sgnb modification refusal (base)';
189 PARAM{ window uint; }
190 Select GNB_ID, ($window*(TB+1))/1000 as TS,
191 $window/1000.0 as measurementInterval,
192 sum(total_reconfig_refuse) as total_reconfig_refuse,
193 sum( count_radio_network ) as count_radio_network,
194 sum( count_transport ) as count_transport,
195 sum( count_protocol ) as count_protocol,
196 sum( count_misc ) as count_misc
197 from mod_status_refuse_cause_base
201 DEFINE{query_name 'mod_req_reject_cause_base';
202 max_lfta_disorder '1'; max_hfta_disorder '1';
203 comment 'distribution of causes for a sgnb modification request reject (base)';
205 PARAM{ window uint; }
206 Select gnb_id as GNB_ID, TB,
207 id_MeNB_UE_X2AP_ID, id_SgNB_UE_X2AP_ID,
208 count(*) as total_reconfig_refuse,
209 sum( GEQ(cause_radio_network,0) ) as count_radio_network,
210 sum( GEQ(cause_transport,0) ) as count_transport,
211 sum( GEQ(cause_protocol,0) ) as count_protocol,
212 sum( GEQ(cause_misc,0) ) as count_misc
213 from SGNBMODREQREJECT.sgnb_mod_req_reject
214 group by gnb_id, timestamp_ms / $window as TB,
215 id_MeNB_UE_X2AP_ID, id_SgNB_UE_X2AP_ID
218 DEFINE{query_name 'mod_status_refuse_cause_base_gtp_teid';
219 max_lfta_disorder '1'; max_hfta_disorder '1';
220 comment 'distribution of causes for a sgnb modification refusal (base), labeled with gtp_teid';
222 PARAM{ window uint; }
223 Select b.GNB_ID, b.TB,
225 b.total_reconfig_refuse,
226 b.count_radio_network,
230 LEFT_OUTER_JOIN from mod_status_refuse_cause_base b,
232 where b.TB=m.TB and b.GNB_ID=m.GNB_ID and
233 b.id_MeNB_UE_X2AP_ID=m.id_MeNB_UE_X2AP_ID
236 DEFINE{query_name 'mod_req_reject_cause_base_gtp_teid';
237 max_lfta_disorder '1'; max_hfta_disorder '1';
238 comment 'distribution of causes for a sgnb modification request reject (base), labeled with gtp_teid';
240 PARAM{ window uint; }
241 Select b.GNB_ID, b.TB,
243 b.total_reconfig_refuse,
244 b.count_radio_network,
248 LEFT_OUTER_JOIN from mod_req_reject_cause_base b,
250 where b.TB=m.TB and b.GNB_ID=m.GNB_ID and
251 b.id_MeNB_UE_X2AP_ID=m.id_MeNB_UE_X2AP_ID
254 DEFINE{query_name 'mod_failure_cause_merge';
255 max_lfta_disorder '1'; max_hfta_disorder '1';
256 comment 'distribution of causes for a sgnb modification request reject (base), labeled with gtp_teid';
258 PARAM{ window uint; }
260 from mod_req_reject_cause_base_gtp_teid p1, mod_status_refuse_cause_base_gtp_teid p2
263 DEFINE{query_name 'mod_failure_cause_gtp_teid';
264 max_lfta_disorder '1'; max_hfta_disorder '1';
265 comment 'distribution of causes for a sgnb modification failure, by UE (gtp_teid)';
267 PARAM{ window uint; }
268 Select GNB_ID, gTP_TEID, ($window*(TB+1))/1000 as TS,
269 $window/1000.0 as measurementInterval,
270 sum(total_reconfig_refuse) as total_reconfig_refuse,
271 sum( count_radio_network ) as count_radio_network,
272 sum( count_transport ) as count_transport,
273 sum( count_protocol ) as count_protocol,
274 sum( count_misc ) as count_misc
275 from mod_failure_cause_merge
276 group by GNB_ID, gTP_TEID, TB
280 // ----------------------------------------------
282 DEFINE{query_name 'release_rqd_cause_base';
283 max_lfta_disorder '1'; max_hfta_disorder '1';
285 PARAM{ window uint; }
286 Select gnb_id, TB, id_MeNB_UE_X2AP_ID,
287 count(*) as total_reconfig_refuse,
288 sum( GEQ(cause_radio_network,0) ) as count_radio_network,
289 sum( GEQ(cause_transport,0) ) as count_transport,
290 sum( GEQ(cause_protocol,0) ) as count_protocol,
291 sum( GEQ(cause_misc,0) ) as count_misc
292 from SGNBRELEASERQD.SgNB_release_rqd
293 group by gnb_id, timestamp_ms / $window as TB, id_MeNB_UE_X2AP_ID
296 DEFINE{query_name 'release_request_cause_base';
297 max_lfta_disorder '1'; max_hfta_disorder '1';
299 PARAM{ window uint; }
300 Select gnb_id, TB, id_MeNB_UE_X2AP_ID,
301 count(*) as total_reconfig_refuse,
302 sum( GEQ(cause_radio_network,0) ) as count_radio_network,
303 sum( GEQ(cause_transport,0) ) as count_transport,
304 sum( GEQ(cause_protocol,0) ) as count_protocol,
305 sum( GEQ(cause_misc,0) ) as count_misc
306 from RELREQ.release_req
307 group by gnb_id, timestamp_ms / $window as TB, id_MeNB_UE_X2AP_ID
310 DEFINE{query_name 'reconfig_cause_merge';}
311 PARAM{ window uint; }
313 from release_rqd_cause_base p1, release_request_cause_base p2
316 DEFINE{query_name 'release_cause';
317 max_lfta_disorder '1'; max_hfta_disorder '1';
318 comment 'distribution of the causes of a DC release';
320 PARAM{ window uint; }
321 Select gnb_id as GNB_ID, ($window*(TB+1))/1000 as TS,
322 $window/1000.0 as measurementInterval,
323 sum(total_reconfig_refuse) as total_reconfig_refuse,
324 sum(count_radio_network) as count_radio_network,
325 sum(count_transport) as count_transport,
326 sum(count_protocol) as count_protocol,
327 sum(count_misc) as count_misc
328 from reconfig_cause_merge
332 DEFINE{query_name 'release_cause_join';
333 max_lfta_disorder '1'; max_hfta_disorder '1';
334 comment 'distribution of the causes of a DC release';
336 PARAM{ window uint; }
337 Select r.gnb_id, r.TB, m.gTP_TEID,
338 r.total_reconfig_refuse, r.count_radio_network,
339 r.count_transport, r.count_protocol, r.count_misc
340 LEFT_OUTER_JOIN from reconfig_cause_merge r, gnb_ueid_teid_map m
341 Where r.gnb_id=m.GNB_ID and r.id_MeNB_UE_X2AP_ID=m.id_MeNB_UE_X2AP_ID
345 DEFINE{query_name 'release_cause_gtp_ueid';
346 max_lfta_disorder '1'; max_hfta_disorder '1';
347 comment 'distribution of the causes of a DC release by UE (gtp_teid)';
349 PARAM{ window uint; }
350 Select gnb_id as GNB_ID, gTP_TEID, ($window*(TB+1))/1000 as TS,
351 $window/1000.0 as measurementInterval,
352 sum(total_reconfig_refuse) as total_reconfig_refuse,
353 sum(count_radio_network) as count_radio_network,
354 sum(count_transport) as count_transport,
355 sum(count_protocol) as count_protocol,
356 sum(count_misc) as count_misc
357 from release_cause_join
358 group by gnb_id, TB, gTP_TEID