Ottomata has submitted this change and it was merged.
Change subject: Remove empty projects from intermediate pageviews
......................................................................
Remove empty projects from intermediate pageviews
Change-Id: I54b117c3240ed60bf0adce142e010d1a69466055
---
M oozie/pageview/hourly/pageview_hourly.hql
1 file changed, 1 insertion(+), 0 deletions(-)
Approvals:
Ottomata: Verified; Looks good to me, approved
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/228247
To unsubscribe, visit https://gerrit.wikimedia.org/r/settings
Gerrit-MessageType: merged
Gerrit-Change-Id: I54b117c3240ed60bf0adce142e010d1a69466055
Gerrit-PatchSet: 1
Gerrit-Project: analytics/refinery
Gerrit-Branch: master
Gerrit-Owner: Joal <[email protected]>
Gerrit-Reviewer: Ottomata <[email protected]>
_______________________________________________
MediaWiki-commits mailing list
[email protected]
https://lists.wikimedia.org/mailman/listinfo/mediawiki-commits
