Grouping statistics by period

Hello.

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

table_views_by_hour
table_views_by_day
table_views_by_month
table_views_by_year

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?

image

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.