Fdans has uploaded a new change for review. (
https://gerrit.wikimedia.org/r/404297 )
Change subject: Use ISO country codes instead of country names
......................................................................
Use ISO country codes instead of country names
Because using country names in the 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(-)
git pull ssh://gerrit.wikimedia.org:29418/analytics/refinery
refs/changes/97/404297/1
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: newchange
Gerrit-Change-Id: Iffb6412a92a3cd45b20e96be2afa03c9a01fe8c6
Gerrit-PatchSet: 1
Gerrit-Project: analytics/refinery
Gerrit-Branch: master
Gerrit-Owner: Fdans <[email protected]>
_______________________________________________
MediaWiki-commits mailing list
[email protected]
https://lists.wikimedia.org/mailman/listinfo/mediawiki-commits
