Adding MC-NIB support

[ric-app/mc.git] / mc-core / mc / queries / release_req_time.gsql

diff --git a/mc-core/mc/queries/release_req_time.gsql b/mc-core/mc/queries/release_req_time.gsql
index 91e4b53..e1d0dee 100644 (file)
--- a/mc-core/mc/queries/release_req_time.gsql
+++ b/mc-core/mc/queries/release_req_time.gsql
@@ -1,4 +1,6 @@
-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,
@@ -8,10 +10,13 @@ select timestamp_ms as timestamp,
        gnb_id,
        0 as event_type
 from RELREQ.release_req
-where schemaId=801
+// 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,
@@ -21,17 +26,21 @@ select timestamp_ms as timestamp,
        gnb_id,
        1 as event_type
 from CONRELEASE.dc_release
-where schemaId=201
+// 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
@@ -40,7 +49,10 @@ group by gUE_ID, gnb_id, timestamp / $window as TB
 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,