Some BYTES entries return a null value from `udf.bits_to_days_since_seen`. See [this SQL query](https://sql.telemetry.mozilla.org/queries/89036/source) for some example fields. The easy fix is to switch to the [alternate algorithm](https://github.com/mozilla/bigquery-etl/blob/main/sql/moz-fx-data-shared-prod/udf/bits_to_days_since_seen/udf.sql#L8), but I would prefer we keep things fast and find out what the cause actually is. Note that when we reverse the BYTES string, it works correctly.
Bug 1803786 Comment 0 Edit History
Note: The actual edited comment in the bug view page will always show the original commenter’s name and original timestamp.
Some BYTES entries return a null value from `udf.bits_to_days_since_seen`. See [this SQL query](https://sql.telemetry.mozilla.org/queries/89036/source) for some example fields. The easy fix is to switch to the [alternate algorithm](https://github.com/mozilla/bigquery-etl/blob/main/sql/moz-fx-data-shared-prod/udf/bits_to_days_since_seen/udf.sql#L8), but I would prefer we keep things fast and find out what the cause actually is. Note that when we invert the BYTES string, it works correctly.