MaxSem has uploaded a new change for review.
https://gerrit.wikimedia.org/r/325719
Change subject: Add another schema version
......................................................................
Add another schema version
Just keeps existing data flowing, new parameter will be taken into
account as part of T152559.
Bug: T152513
Change-Id: Iff4cab884cc2a318e3f521ba3ba45e926a568881
Depends-On: Ieb757994f91d4f2760dc4919c322abca5200fc0a
---
M interactive/events.sql
1 file changed, 20 insertions(+), 0 deletions(-)
git pull ssh://gerrit.wikimedia.org:29418/analytics/discovery-stats
refs/changes/19/325719/1
diff --git a/interactive/events.sql b/interactive/events.sql
index e915b15..5e93a00 100644
--- a/interactive/events.sql
+++ b/interactive/events.sql
@@ -15,4 +15,24 @@
'hashopen'
)
GROUP BY event_action, event_feature
+
+UNION ALL
+
+SELECT
+ DATE(timestamp) AS day,
+ event_action AS action,
+ event_feature AS feature,
+ SUM(event_sampling) AS events
+ FROM Kartographer_16132745
+ WHERE
+ ('{wiki}' = 'all' OR wiki = '{wiki}')
+ AND timestamp >= '{from_timestamp}'
+ AND timestamp < '{to_timestamp}'
+ AND event_action IN (
+ 'view',
+ 'open',
+ 'close',
+ 'hashopen'
+ )
+ GROUP BY event_action, event_feature
;
--
To view, visit https://gerrit.wikimedia.org/r/325719
To unsubscribe, visit https://gerrit.wikimedia.org/r/settings
Gerrit-MessageType: newchange
Gerrit-Change-Id: Iff4cab884cc2a318e3f521ba3ba45e926a568881
Gerrit-PatchSet: 1
Gerrit-Project: analytics/discovery-stats
Gerrit-Branch: master
Gerrit-Owner: MaxSem <[email protected]>
_______________________________________________
MediaWiki-commits mailing list
[email protected]
https://lists.wikimedia.org/mailman/listinfo/mediawiki-commits
