SET partition_date = UNIX_EPOCH_TO_DATE(time);
SET event_time = UNIX_EPOCH_TO_DATE(data.clientEventTime);
// GENERATED @ 2020-11-16T01:32:29.510858Z
SELECT PARTITION_TIME(partition_date) AS partition_date:TIMESTAMP,
time AS processing_time:TIMESTAMP,
data.payload.eventName AS event_name:STRING,
event_time AS event_time:TIMESTAMP,
count(*) as event_count:DOUBLE
FROM "upsolver-tutorials-mobile-users"
GROUP BY event_time, partition_time(partition_date), time, data.payload.eventName