search

ngulam-ai / Sherlock

0 stars 0 forks source link

DAta discrepancy (due to sessions not finishing at midnight?) #38

Closed ngulamai closed 6 years ago

ngulamai commented 6 years ago

We have noticed a discrepancy between sessions and streaming tables. Do you know why is that? Thanks

SeLECT date, count(*) Hits FROM TABLE_DATE_RANGE([MMGStreaming.sessions], TIMESTAMP('20180529'), TIMESTAMP('20180529')) WHERE hits.eventInfo.eventCategory == "AdClick" GROUP BY date ORDER BY date DESC

SELECT date, count(*) Hits FROM TABLE_DATE_RANGE([MMGStreaming.streaming], TIMESTAMP('20180529'), TIMESTAMP('20180529')) WHERE eventInfo.eventCategory == "AdClick" GROUP BY date ORDER BY date DESC

akolchin-MM commented 6 years ago

35