Create view for huge records table

[karthi djax]

Hi,

I have a table which get new records inserted every hour. From this tables am taking aggregation of some columns in a query which takes around 5 sec to complete. Wanted to create View which has this query result and the same need to update every hour.

Followed as in below link but am the data is not updating in vie wproperly.

https://medium.com/left-join/working-with-materialized-views-in-clickhouse-277b2e62e19

Can anyone guide me plz. Thanks in Advance.

Regards,

Karthikeyan D.