nuria · July 22, 2019 20:17
diff --git a/select-events-per-day.hql b/select-events-per-day.hql
 select CONCAT(year, '-', LPAD(month, 2, '0'), '-', LPAD(day, 2, '0')) AS date,
 count(1) as n_events
 from event.externalguidance
 where year=2019 and month=6
 and not useragent.is_bot
 and event.action = 'init'
 group by year, month, day
 order by date
 limit 1000000
	select CONCAT(year, '-', LPAD(month, 2, '0'), '-', LPAD(day, 2, '0')) AS date,
	count(1) as n_events
	from event.externalguidance
	where year=2019 and month=6
	and not useragent.is_bot
	and event.action = 'init'
	group by year, month, day
	order by date
	limit 1000000