Milimetric has uploaded a new change for review. (
https://gerrit.wikimedia.org/r/365806 )
Change subject: Implement Wikistats metrics as Druid queries
......................................................................
Implement Wikistats metrics as Druid queries
Bug: T170882
Change-Id: I0f2a8af2071fca68bc36663e9c427c09301d5d6c
---
A druid/mediawiki/metrics/active-editors.json
A druid/mediawiki/metrics/new-articles.json
2 files changed, 69 insertions(+), 0 deletions(-)
git pull ssh://gerrit.wikimedia.org:29418/analytics/refinery
refs/changes/06/365806/1
diff --git a/druid/mediawiki/metrics/active-editors.json
b/druid/mediawiki/metrics/active-editors.json
new file mode 100644
index 0000000..c101fdb
--- /dev/null
+++ b/druid/mediawiki/metrics/active-editors.json
@@ -0,0 +1,45 @@
+{
+ "queryType": "groupBy",
+ "dataSource": {
+ "type": "query",
+ "query": {
+ "queryType": "groupBy",
+ "dataSource": "test-wks2-metrics",
+ "granularity": "day",
+ "dimensions": ["wiki_db", "event_user_id"],
+ "filter": {
+ "type": "and",
+ "fields": [
+ { "type": "selector", "dimension": "wiki_db", "value":
"enwiki" },
+ { "type": "selector", "dimension": "event_entity",
"value": "revision" },
+ { "type": "selector", "dimension": "event_type", "value":
"create" },
+ { "type": "selector", "dimension":
"revision_is_deleted_current_month", "value": "0" },
+
+ { "type": "not", "field": {
+ "type": "selector", "dimension": "event_user_groups",
"value": "bot"
+ }},
+ { "type": "selector", "dimension":
"event_user_is_anonymous", "value": "0" },
+ { "type": "selector", "dimension":
"event_user_is_bot_by_name", "value": "0" }
+ ]
+ },
+ "aggregations": [
+ { "type": "longSum", "name": "edit_count", "fieldName":
"events" }
+ ],
+ "having": {
+ "type": "and",
+ "havingSpecs": [
+ { "type": "greaterThan", "aggregation": "edit_count",
"value": 4 },
+ { "type": "lessThan", "aggregation": "edit_count",
"value": 100 }
+ ]
+ },
+ "intervals": [ "2017-04-01T00:00:00.000/2017-05-01T00:00:00.000" ]
+ }
+ },
+
+ "granularity": "day",
+ "dimensions": ["wiki_db"],
+ "aggregations": [
+ { "type": "count", "name": "active_editors" }
+ ],
+ "intervals": [ "2017-04-01T00:00:00.000/2017-05-01T00:00:00.000" ]
+}
diff --git a/druid/mediawiki/metrics/new-articles.json
b/druid/mediawiki/metrics/new-articles.json
new file mode 100644
index 0000000..3b65996
--- /dev/null
+++ b/druid/mediawiki/metrics/new-articles.json
@@ -0,0 +1,24 @@
+{
+ "queryType": "groupBy",
+ "dataSource": "test-wks2-metrics",
+ "granularity": "day",
+ "dimensions": ["wiki_db"],
+ "filter": {
+ "type": "and",
+ "fields": [
+ { "type": "selector", "dimension": "wiki_db", "value": "enwiki" },
+ { "type": "selector", "dimension": "event_entity", "value": "page"
},
+ { "type": "selector", "dimension": "event_type", "value": "create"
},
+
+ { "type": "not", "field": {
+ "type": "selector", "dimension": "event_user_groups", "value":
"bot"
+ }},
+ { "type": "selector", "dimension": "event_user_is_anonymous",
"value": "0" },
+ { "type": "selector", "dimension": "event_user_is_bot_by_name",
"value": "0" }
+ ]
+ },
+ "aggregations": [
+ { "type": "count", "name": "new_articles" }
+ ],
+ "intervals": [ "2017-04-01T00:00:00.000/2017-05-01T00:00:00.000" ]
+}
--
To view, visit https://gerrit.wikimedia.org/r/365806
To unsubscribe, visit https://gerrit.wikimedia.org/r/settings
Gerrit-MessageType: newchange
Gerrit-Change-Id: I0f2a8af2071fca68bc36663e9c427c09301d5d6c
Gerrit-PatchSet: 1
Gerrit-Project: analytics/refinery
Gerrit-Branch: master
Gerrit-Owner: Milimetric <[email protected]>
_______________________________________________
MediaWiki-commits mailing list
[email protected]
https://lists.wikimedia.org/mailman/listinfo/mediawiki-commits
