Create view for huge records table

15 views
Skip to first unread message

karthi djax

unread,
Apr 11, 2022, 8:50:53 AMApr 11
to ClickHouse
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.

Can anyone guide me plz. Thanks in Advance.

Regards,
Karthikeyan D.
Reply all
Reply to author
Forward
0 new messages