You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
I re-downloaded the data.dump just in case mine mismatched the repo but when following along I don't get the same data.
WITH deduped_events AS (
SELECT
user_id,
url,
event_time,
DATE(event_time) AS event_date
FROM events
WHERE user_id IS NOT NULLAND url IN ('/signup', '/api/v1/users')
GROUP BY user_id, url, event_time, DATE(event_time)
)
SELECTd1.user_id, d1.url, d2.url, d1.event_time, d2.event_timeFROM deduped_events d1
JOIN deduped_events d2
ONd1.user_id=d2.user_idANDd1.event_date=d2.event_dateANDd2.event_time>d1.event_timeWHEREd1.url='/signup'ANDd2.url='/api/v1/users'
returns no data
I do get a bunch of data for /signup /api/v1/users does not match
I do have /api/v1/login
Not a blocker, continuing with replacing/api/v1/users with /api/v1/login for now
The text was updated successfully, but these errors were encountered:
I re-downloaded the data.dump just in case mine mismatched the repo but when following along I don't get the same data.
returns no data
I do get a bunch of data for
/signup
/api/v1/users
does not matchI do have
/api/v1/login
Not a blocker, continuing with replacing
/api/v1/users
with/api/v1/login
for nowThe text was updated successfully, but these errors were encountered: