Joal has uploaded a new change for review.
https://gerrit.wikimedia.org/r/228011
Change subject: Remove empty projects from intermediate pageviews
......................................................................
Remove empty projects from intermediate pageviews
Change-Id: I5d24a669e3c59c52071fb6783767fba89aad7784
---
M oozie/pageview/hourly/pageview_hourly.hql
1 file changed, 1 insertion(+), 0 deletions(-)
git pull ssh://gerrit.wikimedia.org:29418/analytics/refinery
refs/changes/11/228011/1
diff --git a/oozie/pageview/hourly/pageview_hourly.hql
b/oozie/pageview/hourly/pageview_hourly.hql
index 198b926..0cf273f 100644
--- a/oozie/pageview/hourly/pageview_hourly.hql
+++ b/oozie/pageview/hourly/pageview_hourly.hql
@@ -51,6 +51,7 @@
WHERE webrequest_source IN ('text', 'mobile') AND
year=${year} AND month=${month} AND day=${day} AND hour=${hour}
AND is_pageview = TRUE
+ AND COALESCE(pageview_info['project'], '') != ''
GROUP BY
pageview_info['project'],
pageview_info['language_variant'],
--
To view, visit https://gerrit.wikimedia.org/r/228011
To unsubscribe, visit https://gerrit.wikimedia.org/r/settings
Gerrit-MessageType: newchange
Gerrit-Change-Id: I5d24a669e3c59c52071fb6783767fba89aad7784
Gerrit-PatchSet: 1
Gerrit-Project: analytics/refinery
Gerrit-Branch: master
Gerrit-Owner: Joal <[email protected]>
_______________________________________________
MediaWiki-commits mailing list
[email protected]
https://lists.wikimedia.org/mailman/listinfo/mediawiki-commits
