X-Git-Url: https://gerrit.o-ran-sc.org/r/gitweb?a=blobdiff_plain;f=mc-core%2Fmc%2Fqueries%2Frrcx_stats_cell.gsql;fp=mc-core%2Fmc%2Fqueries%2Frrcx_stats_cell.gsql;h=affb1f98e7715dc8743664aad52c06c053d15e6b;hb=31d238a2cba18b87e05a7d9b4820db2c5186c658;hp=0000000000000000000000000000000000000000;hpb=fe2bd3618e4748333078f91c26a8a3f5dcf184c4;p=ric-app%2Fmc.git

diff --git a/mc-core/mc/queries/rrcx_stats_cell.gsql b/mc-core/mc/queries/rrcx_stats_cell.gsql
new file mode 100644
index 0000000..affb1f9
--- /dev/null
+++ b/mc-core/mc/queries/rrcx_stats_cell.gsql
@@ -0,0 +1,27 @@
+PARAM{ window uint;}
+//	rsrp, rsrq, sinr ranges are 0 .. 127
+
+select $window*(tb+1) as TS, $window as measurementInterval,
+	physCellId as CELL_ID,
+	count(*) as cnt,
+	min(rsrp) as min_rsrp,
+	min(rsrp)+0.05*(max(rsrp)-min(rsrp)) as pctl_05_rsrp,
+	min(rsrp)+0.5*(max(rsrp)-min(rsrp)) as median_rsrp,
+	min(rsrp)+0.95*(max(rsrp)-min(rsrp)) as pctl_95_rsrp,
+	sqrt( sum(FLOAT(rsrp)*FLOAT(rsrp)) - sum(FLOAT(rsrp))*sum(FLOAT(rsrp))/count(*)) / count(*) as stddev_rsrp,
+	max(rsrp) as max_rsrp,
+	min(rsrq) as min_rsrq,
+	min(rsrq)+0.05*(max(rsrq)-min(rsrq)) as pctl_05_rsrq,
+	min(rsrq)+0.5*(max(rsrq)-min(rsrq)) as median_rsrq,
+	min(rsrq)+0.95*(max(rsrq)-min(rsrq)) as pctl_95_rsrq,
+	sqrt( sum(FLOAT(rsrq)*FLOAT(rsrq)) - sum(FLOAT(rsrq))*sum(FLOAT(rsrq))/count(*)) / count(*) as stddev_rsrq,
+	max(rsrq) as max_rsrq,
+	min(sinr) as min_sinr,
+	min(sinr)+0.05*(max(sinr)-min(sinr)) as pctl_05_sinr,
+	min(sinr)+0.5*(max(sinr)-min(sinr)) as median_sinr,
+	min(sinr)+0.95*(max(sinr)-min(sinr)) as pctl_95_sinr,
+	sqrt( sum(FLOAT(sinr)*FLOAT(sinr)) - sum(FLOAT(sinr))*sum(FLOAT(sinr))/count(*)) / count(*) as stddev_sinr,
+	max(sinr) as max_sinr
+from RRCXFER.serv_nr_cell
+where schemaId = 1
+group by systemTime/$window as tb, physCellId