Search Articles — Sudonull

Search Results

In this project

ClickHouse Materialized Views: Nuances and Solutions

https://sudonull.com/clickhouse-materialized-views-nuances-and-solutions

How MV Works in ClickHouse? Critical Differences from Classical DBMS, UPDATE/DELETE Limitations and Best Practices. Learn How to Avoid Design Errors.

ClickHouse Materialized Views: triggers on INSERT

https://sudonull.com/clickhouse-materialized-views-triggers-on-insert

How MV work in ClickHouse: incremental aggregation, chains minute→hour→day, Null+Kafka pattern, POPULATE and its dangers. Examples with SummingMergeTree and AggregatingMergeTree.

MV in ClickHouse: data loss and control

https://sudonull.com/mv-in-clickhouse-data-loss-and-control

Analysis of risks of materialized views in ClickHouse: schema errors, block insert, monitoring system.query_views_log. How to avoid losses in production. Practical code examples.

ClickHouse: deduplication and losses in MV

https://sudonull.com/clickhouse-deduplication-and-losses-in-mv

Analysis of data losses in ClickHouse due to block deduplication in materialized views. Settings insert_deduplicate=0 and deduplicate_blocks_in_dependent_materialized_views=1. Configure lossless storage — read the details.

SummingMergeTree and AggregatingMergeTree in ClickHouse

https://sudonull.com/summingmergetree-and-aggregatingmergetree-in-clickhouse

Incremental aggregation in ClickHouse: how SummingMergeTree and AggregatingMergeTree speed up dashboards by 100 times. Examples, materialized views, pitfalls, and comparison.

From other projects

UK Sanctions Easing: Fuel Imports from Russia

https://ymaho.com/uk-sanctions-easing-fuel-imports-from-russia

Why London Allowed Imports of Diesel and Aviation Kerosene from Russian Raw Materials and How It Will Change the Market. Find Out Who Benefits from the Sanctions Adjustment.

Brent crude $113: price shock in the Middle East

https://ymaho.com/brent-crude-113-price-shock-in-the-middle-east

Brent crude has settled above $113 due to the crisis in the Strait of Hormuz. We analyze the causes of the surge, market reaction, and analyst forecasts up to $150. Find out how geopolitics affects prices.

Oil prices below $102: record drop in inventories

https://ymaho.com/oil-prices-below-102-record-drop-in-inventories

Oil corrected to $101, but IEA sounds alarm over record inventory drawdown. Find out why the market expects a price explosion and how to prepare for it.

Brent oil $112: why the collapse of US-Iran talks is just the beginning

https://ymaho.com/brent-oil-112-why-the-collapse-of-us-iran-talks-is-just-the-beginning

The collapse of US-Iran talks halted 'gray' oil exports, creating a deficit of 900,000 barrels per day. We analyze the real reasons for Brent's jump to $112 and a forecast up to $118. Read insider analysis.

Trending Now