-DEFINE{query_name 'release_req_start';}
+DEFINE{query_name 'release_req_start';
+ max_lfta_disorder '1'; max_hfta_disorder '1';
+}
PARAM{ window uint; }
select timestamp_ms as timestamp,
non_temporal(timestamp_ms) as start_time,
gnb_id,
0 as event_type
from RELREQ.release_req
-where schemaId=801
;
-DEFINE{query_name 'release_req_success';}
+DEFINE{query_name 'release_req_success';
+ max_lfta_disorder '1'; max_hfta_disorder '1';
+ comment 'statistics on the time to delease a DC connection';
+}
PARAM{ window uint; }
select timestamp_ms as timestamp,
0ULL as start_time,
gnb_id,
1 as event_type
from CONRELEASE.dc_release
-where schemaId=201
;
-DEFINE{query_name 'release_req_events';}
+DEFINE{query_name 'release_req_events';
+ max_lfta_disorder '1'; max_hfta_disorder '1';
+}
PARAM{ window uint; }
merge p1.timestamp : p2.timestamp
from release_req_start p1, release_req_success p2
;
-DEFINE{query_name 'release_req_success_time';}
+DEFINE{query_name 'release_req_success_time';
+ max_lfta_disorder '1'; max_hfta_disorder '1';
+}
PARAM{ window uint; }
select gUE_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 'release_req_success_stats';}
+DEFINE{query_name 'release_req_success_stats';
+ max_lfta_disorder '1'; max_hfta_disorder '1';
+ comment 'statistics on the time to delease a DC connection';
+}
PARAM{ window uint; }
select gnb_id as GNB_ID,
($window*(TB+1))/1000 as TS,