Bug 1655385 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.

Original comment by
on 
Some of the pings are sent with `null` value.

```
SELECT 
    CAST(metrics.timespan.mozphab_usage_command_time.value/1000 AS INT64) AS seconds,
    metrics.counter.mozphab_submission_commits_count AS commits

FROM mozphab.usage 
WHERE
    DATE(submission_timestamp) >= DATE_SUB(CURRENT_DATE(), INTERVAL 1 DAY)
    AND metrics.counter.mozphab_submission_commits_count IS null
```
Revision 1 by
on 
Some of the pings are sent with `null` value.

This query has found 4 pings within the last 24h.
```
SELECT 
    CAST(metrics.timespan.mozphab_usage_command_time.value/1000 AS INT64) AS seconds,
    metrics.counter.mozphab_submission_commits_count AS commits

FROM mozphab.usage 
WHERE
    DATE(submission_timestamp) >= DATE_SUB(CURRENT_DATE(), INTERVAL 1 DAY)
    AND metrics.counter.mozphab_submission_commits_count IS null
```

Back to Bug 1655385 Comment 0