-DEFINE{query_name 'dc_connect';}
+DEFINE{query_name 'dc_connect';
+ max_lfta_disorder '1'; max_hfta_disorder '1';
+}
PARAM{ window uint; }
select timestamp_ms as timestamp,
UINT(id_MeNB_UE_X2AP_ID) as eUE_ID,
UINT(id_SgNB_UE_X2AP_ID) as gUE_ID,
1 as event_type
from RECONCOMPLETE.reconfig_success
-where schemaId=101
+// where schemaId=101
;
-DEFINE{query_name 'dc_terminate';}
+DEFINE{query_name 'dc_terminate';
+ max_lfta_disorder '1'; max_hfta_disorder '1';
+}
PARAM{ window uint; }
select timestamp_ms as timestamp,
UINT(id_Old_eNB_UE_X2AP_ID) as eUE_ID,
id_SgNB_UE_X2AP_ID as gUE_ID,
0 as event_type
from CONRELEASE.dc_release
-where schemaId=201
+// where schemaId=201
;
DEFINE{query_name 'dc_events';}
;
-DEFINE{ query_name 'mc_connected_ues'; }
+DEFINE{ query_name 'mc_connected_ues';
+ max_lfta_disorder '1'; max_hfta_disorder '1';
+}
PARAM{ window uint; }
SELECT TB, UE_ID,
((TB+1)*$window-LAST(timestamp))/1000.0 as connected_time
CLOSING_WHEN LAST(event_type) = 0
;
-DEFINE{ query_name 'mc_connected_cnt'; }
+DEFINE{ query_name 'mc_connected_cnt';
+ max_lfta_disorder '1'; max_hfta_disorder '1';
+ comment 'Number of dual connected users';
+}
PARAM{ window uint; }
SELECT ($window*(TB+1))/1000 as TS,
$window/1000.0 as measurementInterval, // standard_name
GROUP BY TB
;
-DEFINE{ query_name 'mc_disconnected_ues'; }
+DEFINE{ query_name 'mc_disconnected_ues';
+ max_lfta_disorder '1'; max_hfta_disorder '1';
+}
PARAM{ window uint; }
SELECT TB_1000, UE_ID,
UINT((LAST(timestamp) - FIRST(timestamp))) as connected_time
;
-DEFINE{ query_name 'mc_connection_stats'; }
+DEFINE{ query_name 'mc_connection_stats';
+ max_lfta_disorder '1'; max_hfta_disorder '1';
+ comment 'statistics about the length of dual connected sessions';
+}
PARAM{ window uint; }
SELECT ($window*(TB+1))/1000 as TS,
$window/1000.0 as measurementInterval, // standard_name
;
-DEFINE{ query_name 'mc_connects_cnt'; }
+DEFINE{ query_name 'mc_connects_cnt';
+ max_lfta_disorder '1'; max_hfta_disorder '1';
+ comment 'number of DC connection requests';
+}
PARAM{ window uint; }
SELECT ($window*(TB+1))/1000 as TS,
$window/1000.0 as measurementInterval, // standard_name
GROUP BY timestamp / $window as TB
;
-DEFINE{ query_name 'mc_disconnects_cnt'; }
+DEFINE{ query_name 'mc_disconnects_cnt';
+ max_lfta_disorder '1'; max_hfta_disorder '1';
+ comment 'number of DC connection releases';
+}
PARAM{ window uint; }
SELECT ($window*(TB+1))/1000 as TS,
$window/1000.0 as measurementInterval, // standard_name
GROUP BY timestamp / $window as TB
;
-DEFINE{ query_name 'mc_unique_ues'; }
+DEFINE{ query_name 'mc_unique_ues';
+ max_lfta_disorder '1'; max_hfta_disorder '1';
+}
PARAM{ window uint; }
SELECT TB, UE_ID
FROM dc_events
GROUP BY timestamp / $window as TB, gUE_ID as UE_ID
;
-DEFINE{ query_name 'mc_unique_ue_cnt'; }
+DEFINE{ query_name 'mc_unique_ue_cnt';
+ max_lfta_disorder '1'; max_hfta_disorder '1';
+ comment 'Number of distinct UEs making a DC request or release';
+}
PARAM{ window uint; }
SELECT ($window*(TB+1))/1000 as TS,
$window/1000.0 as measurementInterval, // standard_name