[HN Gopher] ClickHouse Materialized Views for Fast Aggregation a...
       ___________________________________________________________________
        
       ClickHouse Materialized Views for Fast Aggregation and Queries
        
       Author : podoman
       Score  : 13 points
       Date   : 2024-02-02 15:48 UTC (7 hours ago)
        
 (HTM) web link (www.highlight.io)
 (TXT) w3m dump (www.highlight.io)
        
       | jdpedrie wrote:
       | Shown in the article but not called out specifically, I recommend
       | avoiding implicit tables entirely when using clickhouse
       | materialized views. We use clickhouse for similar purposes, and
       | there are several cases where views are listening to tables
       | populated by another view. So [table] "events" -> [view]
       | "mv_events_to_view1" -> [table] "view1" -> [view]
       | "mv_view1_to_view2" -> [table] "view2". If you use implicit
       | tables, the 2nd view will never receive data.
       | 
       | This document provides a ton of great information if you're doing
       | anything with materialized views in clickhouse: https://den-
       | crane.github.io/Everything_you_should_know_about...
        
       ___________________________________________________________________
       (page generated 2024-02-02 23:01 UTC)