I want to know whether it is possible to query tracking user who purchased on a certain day.
select dt, count(distinct userid) as uv, count(*) as pv
where dt between ‘2016-08-02’ and ‘2016-08-07’
and userid in
select userid from order where dt = '2016-08-01'
group by dt
How to query this? Is it possible in Druid?