The FlowETL QA checks count_imsis, count_imeis, max_msisdns_per_imsi and max_msisdns_per_imei count NULL as a valid IMEI/IMSI value. This is particularly problematic for max_msisdns_per_imsi/max_msisdns_per_imei, since these checks will return a very large count if a portion of the events are missing an imei or imsi.
These checks should instead operate only on events with non-null imei/imsi. We have other checks to count the rows where these fields are null.
The FlowETL QA checks
count_imsis,count_imeis,max_msisdns_per_imsiandmax_msisdns_per_imeicountNULLas a valid IMEI/IMSI value. This is particularly problematic formax_msisdns_per_imsi/max_msisdns_per_imei, since these checks will return a very large count if a portion of the events are missing animeiorimsi.These checks should instead operate only on events with non-null
imei/imsi. We have other checks to count the rows where these fields are null.