The input data is big. So we use ValueState<Bitmap> to store all the distinct userIds from 00:00:00 to last minute. For current minute, we union the minute's data with ValueState<Bitmap> to obtain a new ValueState<Bitmap> and output the current uv.
The problem is how to translate the java code to sql? We expect the sql to be like this:
select incrementWindow_end, dimension, distinct(userId) from table group by incrementWindow(Time.days(1), Time.minutes(1)), dimension
Anyone can give me some suggestions? Thank you very much.