The following query in the Data Lake should tally number of events logged by the platform (desktop, tablet, phone, other) for the EditAttemptStep schema:
SELECT event.platform, count(*) AS num_events FROM event.editattemptstep WHERE year=2018 AND month=11 GROUP BY event.platform;
However, the query only finds events for the desktop platform, as seen in this output from running it shortly before writing this task:
platform num_events desktop 1674894 Time taken: 34.216 seconds, Fetched: 1 row(s)
Running a comparable query over the most recent data for the Edit schema in the log database results in events for several platforms:
SELECT event_platform, count(*) AS num_events FROM Edit_17541122 WHERE timestamp >= '20181001000000' AND timestamp < '20181101000000' GROUP BY event_platform; +----------------+------------+ | event_platform | num_events | +----------------+------------+ | desktop | 10976304 | | other | 4 | | phone | 2113612 | +----------------+------------+ 3 rows in set (1 min 27.60 sec)
So, is mobile edit events logged for the EditAttemptStep schema?