Chelsyx has submitted this change and it was merged.
Change subject: Revise PV definition for referral counting
......................................................................
Revise PV definition for referral counting
Makes the Hive query more in line with the query in pageviews.R
Change-Id: Ida097618bfbb8cab917d8549d076bdafd97e336d
---
M portal/referers.R
1 file changed, 4 insertions(+), 1 deletion(-)
Approvals:
Chelsyx: Verified; Looks good to me, approved
diff --git a/portal/referers.R b/portal/referers.R
index 81f583f..4b8a385 100644
--- a/portal/referers.R
+++ b/portal/referers.R
@@ -20,7 +20,7 @@
is_external_search(referer) AS is_search,
classify_referer(referer) AS referer_class,
get_engine(referer) as search_engine,
- COUNT(*) AS pageviews
+ COUNT(1) AS pageviews
FROM webrequest",
clause_data$date_clause,
" AND webrequest_source = 'text'
@@ -32,6 +32,9 @@
NOT referer
RLIKE('^(https?://www\\.)?wikipedia.org/+search-redirect.php')
)
AND NOT referer RLIKE('^http://localhost')
+ AND agent_type = 'user'
+ AND referer_class != 'unknown'
+ AND http_status IN('200', '304')
GROUP BY
is_external_search(referer),
classify_referer(referer),
--
To view, visit https://gerrit.wikimedia.org/r/310053
To unsubscribe, visit https://gerrit.wikimedia.org/r/settings
Gerrit-MessageType: merged
Gerrit-Change-Id: Ida097618bfbb8cab917d8549d076bdafd97e336d
Gerrit-PatchSet: 2
Gerrit-Project: wikimedia/discovery/golden
Gerrit-Branch: master
Gerrit-Owner: Bearloga <[email protected]>
Gerrit-Reviewer: Chelsyx <[email protected]>
_______________________________________________
MediaWiki-commits mailing list
[email protected]
https://lists.wikimedia.org/mailman/listinfo/mediawiki-commits
