Joal has submitted this change and it was merged. (
https://gerrit.wikimedia.org/r/404297 )
Change subject: Load cassandra with ISO country codes instead of country names
......................................................................
Load cassandra with ISO country codes instead of country names
Because using country names in the top by country endpoint would have
been unpractical for internationalisation and machine use, we're
changing the format to the human readable letter country codes,
like United States => US.
Bug: T184911
Change-Id: Iffb6412a92a3cd45b20e96be2afa03c9a01fe8c6
---
M oozie/cassandra/monthly/pageview_top_bycountry.hql
1 file changed, 1 insertion(+), 1 deletion(-)
Approvals:
Joal: Verified; Looks good to me, approved
diff --git a/oozie/cassandra/monthly/pageview_top_bycountry.hql
b/oozie/cassandra/monthly/pageview_top_bycountry.hql
index dc38c03..a215ff2 100644
--- a/oozie/cassandra/monthly/pageview_top_bycountry.hql
+++ b/oozie/cassandra/monthly/pageview_top_bycountry.hql
@@ -36,7 +36,7 @@
SELECT
COALESCE(project, 'all-projects') AS project,
COALESCE(regexp_replace(access_method, ' ', '-'), 'all-access') AS
access,
- country_name(country_code) as country,
+ country_code as country,
LPAD(year, 4, "0") as year,
LPAD(month, 2, "0") as month,
SUM(view_count) as raw_views,
--
To view, visit https://gerrit.wikimedia.org/r/404297
To unsubscribe, visit https://gerrit.wikimedia.org/r/settings
Gerrit-MessageType: merged
Gerrit-Change-Id: Iffb6412a92a3cd45b20e96be2afa03c9a01fe8c6
Gerrit-PatchSet: 2
Gerrit-Project: analytics/refinery
Gerrit-Branch: master
Gerrit-Owner: Fdans <[email protected]>
Gerrit-Reviewer: Fdans <[email protected]>
Gerrit-Reviewer: Joal <[email protected]>
Gerrit-Reviewer: Ottomata <[email protected]>
_______________________________________________
MediaWiki-commits mailing list
[email protected]
https://lists.wikimedia.org/mailman/listinfo/mediawiki-commits
