Code Review
/
ric-app
/
mc.git
/ blobdiff
commit
grep
author
committer
pickaxe
?
search:
re
summary
|
shortlog
|
log
|
commit
|
commitdiff
|
review
|
tree
raw
|
inline
| side by side
Bump up mc-core image release tag
[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
..
38c3ffd
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,
PARAM{ window uint; }
select timestamp_ms as timestamp,
non_temporal(timestamp_ms) as start_time,
@@
-8,10
+10,12
@@
select timestamp_ms as timestamp,
gnb_id,
0 as event_type
from RELREQ.release_req
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,
PARAM{ window uint; }
select timestamp_ms as timestamp,
0ULL as start_time,
@@
-21,17
+25,20
@@
select timestamp_ms as timestamp,
gnb_id,
1 as event_type
from CONRELEASE.dc_release
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
;
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
PARAM{ window uint; }
select gUE_ID, gnb_id, TB,
UINT(max(end_time)-max(start_time)) as success_time
@@
-40,7
+47,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)
;
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,
PARAM{ window uint; }
select gnb_id as GNB_ID,
($window*(TB+1))/1000 as TS,