Ottomata has uploaded a new change for review. (
https://gerrit.wikimedia.org/r/325961 )
Change subject: Fix select_missing_sequence_runs query to report seqs on edges
of holes, not in
......................................................................
Fix select_missing_sequence_runs query to report seqs on edges of holes, not in
Also fix query result documentation
Change-Id: I8fb1364d44b22669948d7ac518dc07de563b61f2
---
M hive/webrequest/select_missing_sequence_runs.hql
1 file changed, 7 insertions(+), 7 deletions(-)
git pull ssh://gerrit.wikimedia.org:29418/analytics/refinery
refs/changes/61/325961/1
diff --git a/hive/webrequest/select_missing_sequence_runs.hql
b/hive/webrequest/select_missing_sequence_runs.hql
index 6ad981c..362adf9 100644
--- a/hive/webrequest/select_missing_sequence_runs.hql
+++ b/hive/webrequest/select_missing_sequence_runs.hql
@@ -2,11 +2,11 @@
--
-- Sample output:
--
--- hostname missing_start missing_end missing_count
--- -------- ------------- ----------- -------------
--- cp4003.ulsfo.wmnet 1302837053 1302837055 1
--- cp4003.ulsfo.wmnet 1302837059 1302837061 1
--- cp4003.ulsfo.wmnet 1302837066 1302837070 3
+-- hostname before_missing after_missing missing_count
+-- -------- -------------- ------------- -------------
+-- cp4003.ulsfo.wmnet 1302837053 1302837055 1
+-- cp4003.ulsfo.wmnet 1302837059 1302837061 1
+-- cp4003.ulsfo.wmnet 1302837066 1302837070 3
--
-- Parameters:
-- table_name -- Fully qualified table name to look for missing
@@ -34,8 +34,8 @@
SELECT
hostname,
- sequence + 1 AS missing_start,
- next_sequence - 1 AS missing_end,
+ sequence AS before_missing,
+ next_sequence AS after_missing,
next_sequence - sequence - 1 AS missing_count,
dt dt_before_missing,
next_dt dt_after_missing
--
To view, visit https://gerrit.wikimedia.org/r/325961
To unsubscribe, visit https://gerrit.wikimedia.org/r/settings
Gerrit-MessageType: newchange
Gerrit-Change-Id: I8fb1364d44b22669948d7ac518dc07de563b61f2
Gerrit-PatchSet: 1
Gerrit-Project: analytics/refinery
Gerrit-Branch: master
Gerrit-Owner: Ottomata <o...@wikimedia.org>
_______________________________________________
MediaWiki-commits mailing list
MediaWiki-commits@lists.wikimedia.org
https://lists.wikimedia.org/mailman/listinfo/mediawiki-commits
