Grouping statistics by period


I need to make statistics on latest periods for example for user views like this:

userId | Hour | Day | Month | Year

Now I was planning to do how:
Create 4 windows aggregation query


and then create join table

create table ALL_STATISTIC as select 
h.userId, h.val as hour, d.val as day, m.val as month, y.val as year
from table_views_by_hour h
JOIN table_views_by_day d on ...
JOIN table_views_by_month m on ...
JOIN table_views_by_year y on ..

How is this the best option? Or do you have tips on how to do better?


Or is it impossible to do this in ksqldb? because it turns out you need to take the penultimate value of the period

This topic was automatically closed after 30 days. New replies are no longer allowed.