+DEFINE{query_name 'sgnb_add_req_reject_pci_join';
+ max_lfta_disorder '1'; max_hfta_disorder '1';
+ comment 'Join sgnb_add_req_reject with gnb_ueid_cellid_map to create data stream for reconfig_status_reject_cause';
+}
+PARAM{ window uint; }
+select M.TB, M.GNB_ID, M.physCellId, g.cause_radio_network,
+ g.cause_transport, g.cause_protocol, g.cause_misc
+INNER_JOIN from ADDREQREJECT.sgnb_add_req_reject g, gnb_ueid_cellid_map M
+Where g.gnb_id=M.GNB_ID and g.id_MeNB_UE_X2AP_ID=M.id_MeNB_UE_X2AP_ID
+ and g.timestamp_ms/$window=M.TB
+;
+
+DEFINE{query_name 'reconfig_status_reject_cause_pci';
+ max_lfta_disorder '1'; max_hfta_disorder '1';
+ comment 'distribution of causes for DC rejection';
+}
+PARAM{ window uint; }
+Select GNB_ID, TB,
+ non_temporal( ($window*(TB+1))/1000 ) as TS, physCellId,
+ $window/1000.0 as measurementInterval,
+ count(*) as total_reconfig_reject,
+ sum( GEQ(cause_radio_network,0) ) as count_radio_network,
+ sum( GEQ(cause_transport,0) ) as count_transport,
+ sum( GEQ(cause_protocol,0) ) as count_protocol,
+ sum( GEQ(cause_misc,0) ) as count_misc
+from sgnb_add_req_reject_pci_join
+group by GNB_ID, TB, physCellId
+;
+
+
+DEFINE{query_name 'reconfig_status_reject_join';
+ max_lfta_disorder '1'; max_hfta_disorder '1';
+ comment 'Associate gtp_teid using eUE_ID';
+}
+PARAM{ window uint; }
+Select r.id_MeNB_UE_X2AP_ID, M.gTP_TEID, r.gnb_id, M.TB,
+ r.cause_radio_network, r.cause_transport,
+ r.cause_protocol, r.cause_misc
+INNER_JOIN from ADDREQREJECT.sgnb_add_req_reject r, gnb_ueid_teid_map M
+where r.id_MeNB_UE_X2AP_ID=M.id_MeNB_UE_X2AP_ID and r.gnb_id=M.GNB_ID
+ and r.timestamp_ms/$window=M.TB
+;
+
+DEFINE{query_name 'reconfig_status_reject_cause_gtp_teid';
+ max_lfta_disorder '1'; max_hfta_disorder '1';
+ comment 'distribution of causes for DC rejection on a per-ue (gtp-teid) basis';
+}
+PARAM{ window uint; }
+Select gnb_id as GNB_ID, gTP_TEID, TB,
+ non_temporal( ($window*(TB+1))/1000 ) as TS,
+ $window/1000.0 as measurementInterval,
+ count(*) as total_reconfig_reject,
+ sum( GEQ(cause_radio_network,0) ) as count_radio_network,
+ sum( GEQ(cause_transport,0) ) as count_transport,
+ sum( GEQ(cause_protocol,0) ) as count_protocol,
+ sum( GEQ(cause_misc,0) ) as count_misc
+from reconfig_status_reject_join
+group by gnb_id, gTP_TEID, TB
+;
+