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
85 DEFINE{query_name 'reconfig_status_join_pci';
86 max_lfta_disorder '1'; max_hfta_disorder '1';
87 comment 'Associate gtp_teid using eUE_ID';
90 Select r.eUE_ID, M.physCellId, r.gnb_id, r.TB,
91 r.max_start_time, r.max_end_time
92 INNER_JOIN from reconfig_status_merge r, gnb_ueid_cellid_map M
93 where r.eUE_ID=M.id_MeNB_UE_X2AP_ID and r.gnb_id=M.GNB_ID and r.TB=M.TB
96 DEFINE{query_name 'reconfig_status_success_rate_pci';
97 max_lfta_disorder '1'; max_hfta_disorder '1';
98 comment 'fraction of DC connect requests which are successful, on a per-user (gtp_teid) basis.';
100 PARAM{ window uint; }
101 select gnb_id as GNB_ID, physCellId,
102 ($window*(TB+1))/1000 as TS,
103 $window/1000.0 as measurementInterval,
104 count(*) as total_reconfiguration_requests,
105 sum( GEQ(max_end_time,1) ) as successful_reconfiguration_requests,
106 (1.0*sum( GEQ( max_end_time,1) ))/count(*) as success_rate,
107 1.0 - ( (1.0*sum( GEQ( max_end_time,1) ))/count(*) ) as failure_rate
108 from reconfig_status_join_pci
109 group by gnb_id, TB, physCellId
114 // ----------------------------------------------
115 // Merge in reconfig_reject causes and aggregate with this.
116 DEFINE{query_name 'reconfig_status_reject_cause';
117 max_lfta_disorder '1'; max_hfta_disorder '1';
118 comment 'distribution of causes for DC rejection';
120 PARAM{ window uint; }
121 Select gnb_id as GNB_ID, TB,
122 non_temporal( ($window*(TB+1))/1000 ) as TS,
123 $window/1000.0 as measurementInterval,
124 count(*) as total_reconfig_reject,
125 sum( GEQ(cause_radio_network,0) ) as count_radio_network,
126 sum( GEQ(cause_transport,0) ) as count_transport,
127 sum( GEQ(cause_protocol,0) ) as count_protocol,
128 sum( GEQ(cause_misc,0) ) as count_misc
129 from ADDREQREJECT.sgnb_add_req_reject
130 group by gnb_id, timestamp_ms / $window as TB
133 DEFINE{query_name 'sgnb_add_req_reject_pci_join';
134 max_lfta_disorder '1'; max_hfta_disorder '1';
135 comment 'Join sgnb_add_req_reject with gnb_ueid_cellid_map to create data stream for reconfig_status_reject_cause';
137 PARAM{ window uint; }
138 select M.TB, M.GNB_ID, M.physCellId, g.cause_radio_network,
139 g.cause_transport, g.cause_protocol, g.cause_misc
140 INNER_JOIN from ADDREQREJECT.sgnb_add_req_reject g, gnb_ueid_cellid_map M
141 Where g.gnb_id=M.GNB_ID and g.id_MeNB_UE_X2AP_ID=M.id_MeNB_UE_X2AP_ID
142 and g.timestamp_ms/$window=M.TB
145 DEFINE{query_name 'reconfig_status_reject_cause_pci';
146 max_lfta_disorder '1'; max_hfta_disorder '1';
147 comment 'distribution of causes for DC rejection';
149 PARAM{ window uint; }
151 non_temporal( ($window*(TB+1))/1000 ) as TS, physCellId,
152 $window/1000.0 as measurementInterval,
153 count(*) as total_reconfig_reject,
154 sum( GEQ(cause_radio_network,0) ) as count_radio_network,
155 sum( GEQ(cause_transport,0) ) as count_transport,
156 sum( GEQ(cause_protocol,0) ) as count_protocol,
157 sum( GEQ(cause_misc,0) ) as count_misc
158 from sgnb_add_req_reject_pci_join
159 group by GNB_ID, TB, physCellId
163 DEFINE{query_name 'reconfig_status_reject_join';
164 max_lfta_disorder '1'; max_hfta_disorder '1';
165 comment 'Associate gtp_teid using eUE_ID';
167 PARAM{ window uint; }
168 Select r.id_MeNB_UE_X2AP_ID, M.gTP_TEID, r.gnb_id, M.TB,
169 r.cause_radio_network, r.cause_transport,
170 r.cause_protocol, r.cause_misc
171 INNER_JOIN from ADDREQREJECT.sgnb_add_req_reject r, gnb_ueid_teid_map M
172 where r.id_MeNB_UE_X2AP_ID=M.id_MeNB_UE_X2AP_ID and r.gnb_id=M.GNB_ID
173 and r.timestamp_ms/$window=M.TB
176 DEFINE{query_name 'reconfig_status_reject_cause_gtp_teid';
177 max_lfta_disorder '1'; max_hfta_disorder '1';
178 comment 'distribution of causes for DC rejection on a per-ue (gtp-teid) basis';
180 PARAM{ window uint; }
181 Select gnb_id as GNB_ID, gTP_TEID, TB,
182 non_temporal( ($window*(TB+1))/1000 ) as TS,
183 $window/1000.0 as measurementInterval,
184 count(*) as total_reconfig_reject,
185 sum( GEQ(cause_radio_network,0) ) as count_radio_network,
186 sum( GEQ(cause_transport,0) ) as count_transport,
187 sum( GEQ(cause_protocol,0) ) as count_protocol,
188 sum( GEQ(cause_misc,0) ) as count_misc
189 from reconfig_status_reject_join
190 group by gnb_id, gTP_TEID, TB
193 DEFINE{query_name 'reconfig_complete_reject_cause';
194 max_lfta_disorder '1'; max_hfta_disorder '1';
196 PARAM{ window uint; }
198 count(*) as total_reconfig_reject,
199 sum( GEQ(cause_radio_network,0) ) as count_radio_network,
200 sum( GEQ(cause_transport,0) ) as count_transport,
201 sum( GEQ(cause_protocol,0) ) as count_protocol,
202 sum( GEQ(cause_misc,0) ) as count_misc
203 from RECONCOMPLETE.reconfig_reject
204 group by gnb_id, timestamp_ms / $window as TB
207 DEFINE{query_name 'reconfig_reject_merge';}
208 PARAM{ window uint; }
210 from reconfig_status_reject_cause p1, reconfig_complete_reject_cause p2
213 DEFINE{query_name 'reconfig_reject_cause';
214 max_lfta_disorder '1'; max_hfta_disorder '1';
216 PARAM{ window uint; }
217 Select gnb_id as GNB_ID, ($window*(TB+1))/1000 as TS,
218 $window/1000.0 as measurementInterval,
219 sum(total_reconfig_refuse) as total_reconfig_refuse,
220 sum(count_radio_network) as count_radio_network,
221 sum(count_transport) as count_transport,
222 sum(count_protocol) as count_protocol,
223 sum(count_misc) as count_misc
224 from reconfig_cause_merge
228 // ----------------------------------------------
230 DEFINE{query_name 'mod_status_refuse_cause_base';
231 max_lfta_disorder '1'; max_hfta_disorder '1';
232 comment 'distribution of causes for a sgnb modification refusal (base)';
234 PARAM{ window uint; }
235 Select gnb_id as GNB_ID, TB,
236 id_MeNB_UE_X2AP_ID, id_SgNB_UE_X2AP_ID,
237 count(*) as total_reconfig_refuse,
238 sum( GEQ(cause_radio_network,0) ) as count_radio_network,
239 sum( GEQ(cause_transport,0) ) as count_transport,
240 sum( GEQ(cause_protocol,0) ) as count_protocol,
241 sum( GEQ(cause_misc,0) ) as count_misc
242 from SGNBMODREFUSE.sgnb_mod_refuse
243 group by gnb_id, timestamp_ms / $window as TB,
244 id_MeNB_UE_X2AP_ID, id_SgNB_UE_X2AP_ID
247 DEFINE{query_name 'mod_status_refuse_cause';
248 max_lfta_disorder '1'; max_hfta_disorder '1';
249 comment 'distribution of causes for a sgnb modification refusal (base)';
251 PARAM{ window uint; }
252 Select GNB_ID, ($window*(TB+1))/1000 as TS,
253 $window/1000.0 as measurementInterval,
254 sum(total_reconfig_refuse) as total_reconfig_refuse,
255 sum( count_radio_network ) as count_radio_network,
256 sum( count_transport ) as count_transport,
257 sum( count_protocol ) as count_protocol,
258 sum( count_misc ) as count_misc
259 from mod_status_refuse_cause_base
263 DEFINE{query_name 'mod_status_refuse_cause_pci_join';
264 max_lfta_disorder '1'; max_hfta_disorder '1';
265 comment 'Join mod_status_refuse_cause_base with gnb_ueid_cellid_map to create data stream for mod_status_refuse_cause_pci';
267 PARAM{ window uint; }
268 select M.TB, M.GNB_ID, M.physCellId,
269 g.total_reconfig_refuse, g.count_radio_network,
270 g.count_transport, g.count_protocol, g.count_misc
271 INNER_JOIN from mod_status_refuse_cause_base g, gnb_ueid_cellid_map M
272 Where g.GNB_ID=M.GNB_ID and g.id_MeNB_UE_X2AP_ID=M.id_MeNB_UE_X2AP_ID
276 DEFINE{query_name 'mod_status_refuse_cause_pci';
277 max_lfta_disorder '1'; max_hfta_disorder '1';
278 comment 'distribution of causes for a sgnb modification refusal (base)';
280 PARAM{ window uint; }
281 Select GNB_ID, ($window*(TB+1))/1000 as TS, physCellId,
282 $window/1000.0 as measurementInterval,
283 sum(total_reconfig_refuse) as total_reconfig_refuse,
284 sum( count_radio_network ) as count_radio_network,
285 sum( count_transport ) as count_transport,
286 sum( count_protocol ) as count_protocol,
287 sum( count_misc ) as count_misc
288 from mod_status_refuse_cause_pci_join
289 group by GNB_ID, TB, physCellId
292 DEFINE{query_name 'mod_req_reject_cause_base';
293 max_lfta_disorder '1'; max_hfta_disorder '1';
294 comment 'distribution of causes for a sgnb modification request reject (base)';
296 PARAM{ window uint; }
297 Select gnb_id as GNB_ID, TB,
298 id_MeNB_UE_X2AP_ID, id_SgNB_UE_X2AP_ID,
299 count(*) as total_reconfig_refuse,
300 sum( GEQ(cause_radio_network,0) ) as count_radio_network,
301 sum( GEQ(cause_transport,0) ) as count_transport,
302 sum( GEQ(cause_protocol,0) ) as count_protocol,
303 sum( GEQ(cause_misc,0) ) as count_misc
304 from SGNBMODREQREJECT.sgnb_mod_req_reject
305 group by gnb_id, timestamp_ms / $window as TB,
306 id_MeNB_UE_X2AP_ID, id_SgNB_UE_X2AP_ID
309 DEFINE{query_name 'mod_status_refuse_cause_base_gtp_teid';
310 max_lfta_disorder '1'; max_hfta_disorder '1';
311 comment 'distribution of causes for a sgnb modification refusal (base), labeled with gtp_teid';
313 PARAM{ window uint; }
314 Select b.GNB_ID, b.TB,
316 b.total_reconfig_refuse,
317 b.count_radio_network,
321 LEFT_OUTER_JOIN from mod_status_refuse_cause_base b,
323 where b.TB=m.TB and b.GNB_ID=m.GNB_ID and
324 b.id_MeNB_UE_X2AP_ID=m.id_MeNB_UE_X2AP_ID
327 DEFINE{query_name 'mod_req_reject_cause_base_gtp_teid';
328 max_lfta_disorder '1'; max_hfta_disorder '1';
329 comment 'distribution of causes for a sgnb modification request reject (base), labeled with gtp_teid';
331 PARAM{ window uint; }
332 Select b.GNB_ID, b.TB,
334 b.total_reconfig_refuse,
335 b.count_radio_network,
339 LEFT_OUTER_JOIN from mod_req_reject_cause_base b,
341 where b.TB=m.TB and b.GNB_ID=m.GNB_ID and
342 b.id_MeNB_UE_X2AP_ID=m.id_MeNB_UE_X2AP_ID
345 DEFINE{query_name 'mod_failure_cause_merge';
346 max_lfta_disorder '1'; max_hfta_disorder '1';
347 comment 'distribution of causes for a sgnb modification request reject (base), labeled with gtp_teid';
349 PARAM{ window uint; }
351 from mod_req_reject_cause_base_gtp_teid p1, mod_status_refuse_cause_base_gtp_teid p2
354 DEFINE{query_name 'mod_failure_cause_gtp_teid';
355 max_lfta_disorder '1'; max_hfta_disorder '1';
356 comment 'distribution of causes for a sgnb modification failure, by UE (gtp_teid)';
358 PARAM{ window uint; }
359 Select GNB_ID, gTP_TEID, ($window*(TB+1))/1000 as TS,
360 $window/1000.0 as measurementInterval,
361 sum(total_reconfig_refuse) as total_reconfig_refuse,
362 sum( count_radio_network ) as count_radio_network,
363 sum( count_transport ) as count_transport,
364 sum( count_protocol ) as count_protocol,
365 sum( count_misc ) as count_misc
366 from mod_failure_cause_merge
367 group by GNB_ID, gTP_TEID, TB
371 // ----------------------------------------------
373 DEFINE{query_name 'release_rqd_cause_base';
374 max_lfta_disorder '1'; max_hfta_disorder '1';
376 PARAM{ window uint; }
377 Select gnb_id, TB, id_MeNB_UE_X2AP_ID,
378 count(*) as total_reconfig_refuse,
379 sum( GEQ(cause_radio_network,0) ) as count_radio_network,
380 sum( GEQ(cause_transport,0) ) as count_transport,
381 sum( GEQ(cause_protocol,0) ) as count_protocol,
382 sum( GEQ(cause_misc,0) ) as count_misc
383 from SGNBRELEASERQD.SgNB_release_rqd
384 group by gnb_id, timestamp_ms / $window as TB, id_MeNB_UE_X2AP_ID
387 DEFINE{query_name 'release_request_cause_base';
388 max_lfta_disorder '1'; max_hfta_disorder '1';
390 PARAM{ window uint; }
391 Select gnb_id, TB, id_MeNB_UE_X2AP_ID,
392 count(*) as total_reconfig_refuse,
393 sum( GEQ(cause_radio_network,0) ) as count_radio_network,
394 sum( GEQ(cause_transport,0) ) as count_transport,
395 sum( GEQ(cause_protocol,0) ) as count_protocol,
396 sum( GEQ(cause_misc,0) ) as count_misc
397 from RELREQ.release_req
398 group by gnb_id, timestamp_ms / $window as TB, id_MeNB_UE_X2AP_ID
401 DEFINE{query_name 'reconfig_cause_merge';}
402 PARAM{ window uint; }
404 from release_rqd_cause_base p1, release_request_cause_base p2
407 DEFINE{query_name 'release_cause';
408 max_lfta_disorder '1'; max_hfta_disorder '1';
409 comment 'distribution of the causes of a DC release';
411 PARAM{ window uint; }
412 Select gnb_id as GNB_ID, ($window*(TB+1))/1000 as TS,
413 $window/1000.0 as measurementInterval,
414 sum(total_reconfig_refuse) as total_reconfig_refuse,
415 sum(count_radio_network) as count_radio_network,
416 sum(count_transport) as count_transport,
417 sum(count_protocol) as count_protocol,
418 sum(count_misc) as count_misc
419 from reconfig_cause_merge
423 DEFINE{query_name 'release_cause_join';
424 max_lfta_disorder '1'; max_hfta_disorder '1';
425 comment 'distribution of the causes of a DC release';
427 PARAM{ window uint; }
428 Select r.gnb_id, r.TB, m.gTP_TEID,
429 r.total_reconfig_refuse, r.count_radio_network,
430 r.count_transport, r.count_protocol, r.count_misc
431 LEFT_OUTER_JOIN from reconfig_cause_merge r, gnb_ueid_teid_map m
432 Where r.gnb_id=m.GNB_ID and r.id_MeNB_UE_X2AP_ID=m.id_MeNB_UE_X2AP_ID
436 DEFINE{query_name 'release_cause_gtp_ueid';
437 max_lfta_disorder '1'; max_hfta_disorder '1';
438 comment 'distribution of the causes of a DC release by UE (gtp_teid)';
440 PARAM{ window uint; }
441 Select gnb_id as GNB_ID, gTP_TEID, ($window*(TB+1))/1000 as TS,
442 $window/1000.0 as measurementInterval,
443 sum(total_reconfig_refuse) as total_reconfig_refuse,
444 sum(count_radio_network) as count_radio_network,
445 sum(count_transport) as count_transport,
446 sum(count_protocol) as count_protocol,
447 sum(count_misc) as count_misc
448 from release_cause_join
449 group by gnb_id, TB, gTP_TEID