gnb_id,
0 as event_type
from SGNB_ADDITION_REQ.sgnb_addreq_for_ue
-where schemaId=401
;
DEFINE{query_name 'add_req_success';}
gnb_id,
1 as event_type
from RECONCOMPLETE.reconfig_success
-where schemaId=101
;
DEFINE{query_name 'addreq_events';}
;
-DEFINE{query_name 'addreq_success_time';}
+DEFINE{query_name 'addreq_success_time';
+ max_lfta_disorder '1'; max_hfta_disorder '1';
+}
PARAM{ window uint; }
select eUE_ID, gnb_id, TB,
UINT(max(end_time)-max(start_time)) as success_time
having max(end_time)>0 and max(start_time)>0 and max(end_time)>max(start_time)
;
-DEFINE{query_name 'addreq_success_stats';}
+DEFINE{query_name 'addreq_success_stats';
+ max_lfta_disorder '1'; max_hfta_disorder '1';
+ comment 'statistics on the time to successfully make a DC connection';
+}
PARAM{ window uint; }
select gnb_id as GNB_ID,
($window*(TB+1))/1000 as TS,