i have a base table which update with more than 500 item per second and whole table contain almost 500 million data. how create continuous-aggregates from this table by interval 1m?
if i create the Create continuous-aggregates will it goes to loop? because handle this much data will take time while in this time new data comes