🕷️ Crawler Inspector

URL Lookup

Direct Parameter Lookup

Raw Queries and Responses

1. Shard Calculation

Query:

Response:

Calculated Shard: 89 (from laksa088)

2. Crawled Status Check

Query:

curl -X POST \
  'http://laksa089.int.ahrefs:8124/' \
  -H 'Content-Type: text/plain' \
  -H 'X-ClickHouse-Database: crawler3' \
  -H 'Authorization: Basic YXBpOg==' \
  -d 'SELECT getAhrefsURLFromUnparsed(src_unparsed) AS found_url, ifNull(toUnixTimestamp(download_stamp), 0) AS crawl_time, ifNull(toUnixTimestamp(props_url_first_seen), 0) AS first_indexed_time, download_http_code AS http_code, src_unparsed AS src_unparsed, src_root_hash AS src_root_hash, history_drop_reason AS history_drop_reason, meta_title AS meta_title, meta_descriptions AS meta_descriptions, attrs_boilerpipe_text AS attrs_boilerpipe_text, attrs_markdown AS attrs_markdown, attrs_readable_markdown AS attrs_readable_markdown, meta_canonical AS meta_canonical FROM crawler3.page_info_local FINAL PREWHERE (src_root_hash, src_unparsed) IN ((getAhrefsRootHashFromUnparsed(getAhrefsUnparsedNoserviceFromURL(\'https://clickhouse.com/videos/how-to-compute-running-aggregation-in-clickhouse\')), getAhrefsUnparsedNoserviceFromURL(\'https://clickhouse.com/videos/how-to-compute-running-aggregation-in-clickhouse\'))) FORMAT JSONEachRow'

Response:

{"found_url":"https:\/\/clickhouse.com\/videos\/how-to-compute-running-aggregation-in-clickhouse","crawl_time":1776481943,"first_indexed_time":1696257918,"http_code":200,"src_unparsed":"com,clickhouse!\/videos\/how-to-compute-running-aggregation-in-clickhouse s443","src_root_hash":"12633450985039531489","history_drop_reason":null,"meta_title":"How to Compute a Running Aggregation in ClickHouse","meta_descriptions":[""],"attrs_boilerpipe_text":"Rich Raposa\nDirector, Global Learning, ClickHouse\nUsing aggregate functions in a materialized view in ClickHouse can lead to surprising results if you don't define them properly. The AggregatingMergeTree table engine requires special column types for representing and storing intermediate (running) totals of aggregations like avg, max, min, uniq, count, and all the other aggregate functions in ClickHouse.\nFollow us","attrs_markdown":"[![ClickHouse logo](https:\/\/clickhouse.com\/_next\/static\/media\/logo-full.ac8102d5.svg)](https:\/\/clickhouse.com\/)\n\nCopy logo as SVG\n\n[Download full logo](https:\/\/clickhouse.com\/brand-assets\/clickhouse-logo.zip)[Download logomark](https:\/\/clickhouse.com\/brand-assets\/clickhouse-logomark.zip)\n\nOpen search\n\nOpen region selector\n\n- [English](https:\/\/clickhouse.com\/?country=en)\n- [Japanese](https:\/\/clickhouse.com\/jp?country=jp)\n\nOpen menu\n\n- [Products](https:\/\/clickhouse.com\/videos\/[slug])\n  \n  **Products**\n  \n  - [![ClickHouse Cloud](https:\/\/clickhouse.com\/images\/nav\/icon-clickhouse-cloud.svg)ClickHouse Cloud The best way to use ClickHouse. Available on AWS, GCP, and Azure.](https:\/\/clickhouse.com\/cloud)\n  - [![ClickHouse BYOC](https:\/\/clickhouse.com\/images\/nav\/icon-byoc.svg)Bring Your Own Cloud A fully managed ClickHouse service, deployed in your own AWS, GCP, or Azure account.](https:\/\/clickhouse.com\/cloud\/bring-your-own-cloud)\n  - [![Postgres ClickHouse Cloud](https:\/\/clickhouse.com\/images\/nav\/icon-postgres.svg)Postgres managed by ClickHouse Unified data stack for transactions and analytics.](https:\/\/clickhouse.com\/cloud\/postgres)\n  - [![Managed ClickStack](https:\/\/clickhouse.com\/images\/nav\/icon-managed-clickstack.svg)Managed ClickStack Managed observability with high-performance queries and long-term retention.](https:\/\/clickhouse.com\/cloud\/clickstack)\n  - [![Langfuse Cloud](https:\/\/clickhouse.com\/images\/nav\/icon-langfuse.svg)Langfuse Cloud LLM observability and evaluations for reliable AI applications and agents.](https:\/\/langfuse.com\/?utm_source=clickhouse_topnav)\n  \n  **Open source**\n  \n  - [![ClickHouse](https:\/\/clickhouse.com\/images\/nav\/icon-clickhouse.svg)ClickHouse Fast open-source OLAP database for real-time analytics.](https:\/\/clickhouse.com\/clickhouse)\n  - [![ClickStack](https:\/\/clickhouse.com\/images\/nav\/icon-clickstack.svg)ClickStack Open-source observability stack for logs, metrics, traces, and session replays.](https:\/\/clickhouse.com\/clickstack)\n  - [![Agentic Data Stack](https:\/\/clickhouse.com\/images\/nav\/icon-agentic-data-stack.svg)Agentic Data Stack Build AI-powered applications with ClickHouse.](https:\/\/clickhouse.com\/ai)\n  - [![chDB](https:\/\/clickhouse.com\/images\/nav\/icon-chdb.svg)chDB In-process SQL Engine powered by ClickHouse, with a Pandas-compatible API](https:\/\/clickhouse.com\/chdb)\n- [Solutions](https:\/\/clickhouse.com\/videos\/[slug])\n  \n  **Use cases**\n  \n  - [Real-time analytics](https:\/\/clickhouse.com\/use-cases\/real-time-analytics)\n  - [Observability](https:\/\/clickhouse.com\/cloud\/clickstack)\n  - [Data warehousing](https:\/\/clickhouse.com\/use-cases\/data-warehousing)\n  - [Machine learning and GenAI](https:\/\/clickhouse.com\/use-cases\/machine-learning-and-data-science)\n  - [All use cases](https:\/\/clickhouse.com\/use-cases)\n  \n  [All use cases \\-\\>\\-\\>](https:\/\/clickhouse.com\/use-cases)\n  \n  **Industries**\n  \n  - [Cybersecurity](https:\/\/clickhouse.com\/industries\/cybersecurity)\n  - [Gaming and entertainment](https:\/\/clickhouse.com\/industries\/gaming)\n  - [E-commerce and retail](https:\/\/clickhouse.com\/industries\/retail)\n  - [Automotive](https:\/\/clickhouse.com\/industries\/automotive)\n  - [Energy](https:\/\/clickhouse.com\/industries\/energy)\n  - [All industries](https:\/\/clickhouse.com\/industries)\n  \n  [All industries \\-\\>\\-\\>](https:\/\/clickhouse.com\/industries)\n- [Docs](https:\/\/clickhouse.com\/docs)\n- [Resources](https:\/\/clickhouse.com\/videos\/[slug])\n  \n  - [User stories](https:\/\/clickhouse.com\/user-stories)\n  - [Blog](https:\/\/clickhouse.com\/blog)\n  - [Events](https:\/\/clickhouse.com\/company\/events)\n  - [News](https:\/\/clickhouse.com\/company\/news)\n  - [Learning and certification](https:\/\/clickhouse.com\/learn)\n  - [Comparisons](https:\/\/clickhouse.com\/videos\/how-to-compute-running-aggregation-in-clickhouse)\n    - [Benchmark hub](https:\/\/clickhouse.com\/benchmarks)\n    - [BigQuery](https:\/\/clickhouse.com\/comparison\/bigquery)\n    - [PostgreSQL](https:\/\/clickhouse.com\/comparison\/postgresql)\n    - [Redshift](https:\/\/clickhouse.com\/comparison\/redshift)\n    - [Snowflake](https:\/\/clickhouse.com\/comparison\/snowflake)\n    - [Elastic Observability](https:\/\/clickhouse.com\/comparison\/elastic-for-observability)\n    - [Splunk](https:\/\/clickhouse.com\/comparison\/splunk-for-observability)\n    - [OpenSearch For observability](https:\/\/clickhouse.com\/comparison\/opensearch-for-observability)\n  - [Videos](https:\/\/clickhouse.com\/videos)\n  - [Demos](https:\/\/clickhouse.com\/demos)\n- [Pricing](https:\/\/clickhouse.com\/pricing)\n- [Contact us](https:\/\/clickhouse.com\/company\/contact?loc=nav)\n\nOpen search\n\nOpen region selector\n\n- [English](https:\/\/clickhouse.com\/?country=en)\n- [Japanese](https:\/\/clickhouse.com\/jp?country=jp)\n\n[46\\.9k](https:\/\/github.com\/ClickHouse\/ClickHouse?utm_source=clickhouse&utm_medium=website&utm_campaign=website-nav)\n\n[Sign in](https:\/\/console.clickhouse.cloud\/signIn?glxid=26aa454a-718f-4a9a-a193-1cce52e4a752&pagePath=%2Fvideos%2Fhow-to-compute-running-aggregation-in-clickhouse&origPath=%2Fvideos%2Fhow-to-compute-running-aggregation-in-clickhouse)\n\n[Get started](https:\/\/console.clickhouse.cloud\/signUp?loc=nav-get-started&glxid=26aa454a-718f-4a9a-a193-1cce52e4a752&pagePath=%2Fvideos%2Fhow-to-compute-running-aggregation-in-clickhouse&origPath=%2Fvideos%2Fhow-to-compute-running-aggregation-in-clickhouse)\n\n- [Videos](https:\/\/clickhouse.com\/videos)\n- \/\n- [How to](https:\/\/clickhouse.com\/videos?category=how-to)\n# How to Compute a Running Aggregation in ClickHouse\n\n[**Previous video**Scaling ClickHouse to petabytes of logs at OpenAI](https:\/\/clickhouse.com\/videos\/openai)\n\n[**Next video**ClickHouse Cloud Live Update - February 2024](https:\/\/clickhouse.com\/videos\/clickhouse-cloud-update-call-feb2024)\n\n## Rich Raposa Director, Global Learning, ClickHouse\nUsing aggregate functions in a materialized view in ClickHouse can lead to surprising results if you don't define them properly. The AggregatingMergeTree table engine requires special column types for representing and storing intermediate (running) totals of aggregations like avg, max, min, uniq, count, and all the other aggregate functions in ClickHouse.\n\n## Recent videos\n[View all Videos](https:\/\/clickhouse.com\/videos)\n\n[![YouTube Video: IyI0YQBCy8U](https:\/\/clickhouse.com\/_next\/image?url=%2Fimages%2Ffallback-video-thumbnail.png&w=3840&q=75) How to CDC ClickPipes: The Fastest Way to Replicate Your Database to ClickHouse Marta Paes, Senior Product Manager at ClickHouse](https:\/\/clickhouse.com\/videos\/202602-APJ-Webinar-CDC-ClickPipes)\n\n[![YouTube Video: Mgsm11T7tO8](https:\/\/clickhouse.com\/_next\/image?url=%2Fimages%2Ffallback-video-thumbnail.png&w=3840&q=75) How to Under-the-Hood: ClickHouse Incremental Materialized Views and Dictionaries Maruthi Lokanathan, Solution Architect at ClickHouse Derek Chia, Principal TAM Architect at ClickHouse](https:\/\/clickhouse.com\/videos\/202601-APJ-Webinar-Materialized-Views)\n\n[![YouTube Video: -piPcapMtc0](https:\/\/clickhouse.com\/_next\/image?url=%2Fimages%2Ffallback-video-thumbnail.png&w=3840&q=75) ClickHouse Cloud, How to LogHouse, Observability for ClickHouse Cloud Get an insider’s look at LogHouse, the ClickHouse-powered logging platform that drives observability for ClickHouse Cloud.](https:\/\/clickhouse.com\/videos\/loghouse-observability-for-clickhouse-cloud)\n\nFollow us\n\n[![X](https:\/\/clickhouse.com\/socials\/x.svg)X](https:\/\/x.com\/ClickhouseDB \"X\")[![Bluesky](https:\/\/clickhouse.com\/socials\/bluesky.svg)Bluesky](https:\/\/bsky.app\/profile\/clickhouse.com \"Bluesky\")[![Slack](https:\/\/clickhouse.com\/socials\/slack.svg)Slack](https:\/\/clickhouse.com\/slack \"Slack\")\n\n[![GitHub](https:\/\/clickhouse.com\/socials\/github.svg)GitHub](https:\/\/github.com\/ClickHouse\/ClickHouse \"GitHub\")[![Telegram](https:\/\/clickhouse.com\/socials\/telegram.svg)Telegram](https:\/\/telegram.me\/clickhouse_en \"Telegram\")[![Meetup](https:\/\/clickhouse.com\/socials\/meetup.svg)Meetup](https:\/\/www.meetup.com\/pro\/clickhouse \"Meetup\")\n\n[![Rss](https:\/\/clickhouse.com\/socials\/rss.svg)Rss](https:\/\/clickhouse.com\/rss.xml \"Rss\")\n\n- - Product\n  - [ClickHouse Cloud](https:\/\/clickhouse.com\/cloud)\n  - [Bring Your Own Cloud](https:\/\/clickhouse.com\/cloud\/bring-your-own-cloud)\n  - [Postgres managed by ClickHouse](https:\/\/clickhouse.com\/cloud\/postgres)\n  - [Managed ClickStack](https:\/\/clickhouse.com\/cloud\/clickstack)\n  - [ClickHouse](https:\/\/clickhouse.com\/clickhouse)\n  - [ClickStack](https:\/\/clickhouse.com\/clickstack)\n  - [Agentic Data Stack](https:\/\/clickhouse.com\/ai)\n  - [ClickHouse Government](https:\/\/clickhouse.com\/government)\n  - [ClickHouse Keeper](https:\/\/clickhouse.com\/clickhouse\/keeper)\n  - [ClickPipes](https:\/\/clickhouse.com\/cloud\/clickpipes)\n  - [Integrations](https:\/\/clickhouse.com\/integrations)\n  - [chDB](https:\/\/clickhouse.com\/chdb)\n  - [Pricing](https:\/\/clickhouse.com\/pricing)\n- - Resources\n  - [Documentation](https:\/\/clickhouse.com\/docs)\n  - [Trust center](https:\/\/trust.clickhouse.com\/)\n  - [Training](https:\/\/clickhouse.com\/learn)\n  - [Support](https:\/\/clickhouse.com\/support\/program)\n  - [Benchmarks](https:\/\/clickhouse.com\/benchmarks)\n  - [Use cases](https:\/\/clickhouse.com\/use-cases)\n  - [Videos](https:\/\/clickhouse.com\/videos)\n  - [Demos](https:\/\/clickhouse.com\/demos)\n  - [Presentations](https:\/\/presentations.clickhouse.com\/)\n  - [Real-time data warehouse](https:\/\/clickhouse.com\/real-time-data-warehouse)\n  - [ClickHouse for data lakes](https:\/\/clickhouse.com\/clickhouse-for-data-lakes)\n  - [Engineering resources](https:\/\/clickhouse.com\/resources\/engineering)\n- - Company\n  - [Blog](https:\/\/clickhouse.com\/blog)\n  - [Our story](https:\/\/clickhouse.com\/company\/our-story)\n  - [Careers](https:\/\/clickhouse.com\/company\/careers)\n  - [Contact us](https:\/\/clickhouse.com\/company\/contact?loc=footer)\n  - [Events](https:\/\/clickhouse.com\/company\/events)\n  - [News](https:\/\/clickhouse.com\/company\/news)\n  - [Media](https:\/\/clickhouse.com\/media)\n- - Join our community\n  - [ClickHouse Community](https:\/\/clickhouse.com\/community)\n  - [GitHub](https:\/\/github.com\/ClickHouse\/ClickHouse)\n  - [Slack](https:\/\/clickhouse.com\/slack)\n  - [LinkedIn](https:\/\/www.linkedin.com\/company\/clickhouseinc)\n  - [X](https:\/\/x.com\/ClickhouseDB)\n  - [Bluesky](https:\/\/bsky.app\/profile\/clickhouse.com)\n  - [Telegram](https:\/\/telegram.me\/clickhouse_en)\n  - [Meetup](https:\/\/www.meetup.com\/pro\/clickhouse)\n- - Comparisons\n  - [BigQuery](https:\/\/clickhouse.com\/comparison\/bigquery)\n  - [PostgreSQL](https:\/\/clickhouse.com\/comparison\/postgresql)\n  - [Redshift](https:\/\/clickhouse.com\/comparison\/redshift)\n  - [Snowflake](https:\/\/clickhouse.com\/comparison\/snowflake)\n  - [Elastic](https:\/\/clickhouse.com\/comparison\/elastic-for-observability)\n  - [Splunk](https:\/\/clickhouse.com\/comparison\/splunk-for-observability)\n  - [OpenSearch](https:\/\/clickhouse.com\/comparison\/opensearch-for-observability)\n  - Partners\n  - [AWS](https:\/\/clickhouse.com\/partners\/aws)\n  - [Azure](https:\/\/clickhouse.com\/partners\/azure)\n\n![ClickHouse logo](https:\/\/clickhouse.com\/_next\/static\/media\/logo-full.ac8102d5.svg)\n\nStay informed on feature releases, product roadmap, support, and cloud offerings\\!\n\nLoading form...\n\n[Star us on Github](https:\/\/github.com\/ClickHouse\/ClickHouse)\n\n© 2026 ClickHouse, Inc. HQ in the Bay Area, CA and Amsterdam, NL.\n\n[Trademark](https:\/\/clickhouse.com\/legal\/trademark-policy)[Privacy](https:\/\/clickhouse.com\/legal\/privacy-policy)[Security](https:\/\/trust.clickhouse.com\/)[Legal](https:\/\/clickhouse.com\/legal)[Cookie policy](https:\/\/clickhouse.com\/legal\/cookie-policy)\n\n![Opt-out logo](https:\/\/clickhouse.com\/images\/opt-out-logo.svg)Your privacy choices\n\n![](https:\/\/px.ads.linkedin.com\/collect\/?pid=4908698&fmt=gif)","attrs_readable_markdown":"## Rich Raposa Director, Global Learning, ClickHouse\nUsing aggregate functions in a materialized view in ClickHouse can lead to surprising results if you don't define them properly. The AggregatingMergeTree table engine requires special column types for representing and storing intermediate (running) totals of aggregations like avg, max, min, uniq, count, and all the other aggregate functions in ClickHouse.\n\nFollow us","meta_canonical":null}

3. Robots.txt Check

Query:

Response:

4. Spam/Ban Check

Query:

Response:

5. Seen Status Check

ℹ️ Skipped - page is already crawled

📄

INDEXABLE

✅

CRAWLED

1 day ago

🤖

ROBOTS ALLOWED

Page Info Filters

Filter	Status	Condition	Details
HTTP status	PASS	`download_http_code = 200`	HTTP 200
Age cutoff	PASS	`download_stamp > now() - 6 MONTH`	0.1 months ago
History drop	PASS	`isNull(history_drop_reason)`	No drop reason
Spam/ban	PASS	`fh_dont_index != 1 AND ml_spam_score = 0`	ml_spam_score=0
Canonical	PASS	`meta_canonical IS NULL OR = '' OR = src_unparsed`	Not set

Page Details

Property	Value
URL	https://clickhouse.com/videos/how-to-compute-running-aggregation-in-clickhouse
Last Crawled	2026-04-18 03:12:23 (1 day ago)
First Indexed	2023-10-02 14:45:18 (2 years ago)
HTTP Status Code	200
Meta Title	How to Compute a Running Aggregation in ClickHouse
Meta Description	null
Meta Canonical	null
Boilerpipe Text	Rich Raposa Director, Global Learning, ClickHouse Using aggregate functions in a materialized view in ClickHouse can lead to surprising results if you don't define them properly. The AggregatingMergeTree table engine requires special column types for representing and storing intermediate (running) totals of aggregations like avg, max, min, uniq, count, and all the other aggregate functions in ClickHouse. Follow us
Markdown	[![ClickHouse logo](https://clickhouse.com/_next/static/media/logo-full.ac8102d5.svg)](https://clickhouse.com/) Copy logo as SVG [Download full logo](https://clickhouse.com/brand-assets/clickhouse-logo.zip)[Download logomark](https://clickhouse.com/brand-assets/clickhouse-logomark.zip) Open search Open region selector - [English](https://clickhouse.com/?country=en) - [Japanese](https://clickhouse.com/jp?country=jp) Open menu - [Products](https://clickhouse.com/videos/[slug]) Products - [![ClickHouse Cloud](https://clickhouse.com/images/nav/icon-clickhouse-cloud.svg)ClickHouse Cloud The best way to use ClickHouse. Available on AWS, GCP, and Azure.](https://clickhouse.com/cloud) - [![ClickHouse BYOC](https://clickhouse.com/images/nav/icon-byoc.svg)Bring Your Own Cloud A fully managed ClickHouse service, deployed in your own AWS, GCP, or Azure account.](https://clickhouse.com/cloud/bring-your-own-cloud) - [![Postgres ClickHouse Cloud](https://clickhouse.com/images/nav/icon-postgres.svg)Postgres managed by ClickHouse Unified data stack for transactions and analytics.](https://clickhouse.com/cloud/postgres) - [![Managed ClickStack](https://clickhouse.com/images/nav/icon-managed-clickstack.svg)Managed ClickStack Managed observability with high-performance queries and long-term retention.](https://clickhouse.com/cloud/clickstack) - [![Langfuse Cloud](https://clickhouse.com/images/nav/icon-langfuse.svg)Langfuse Cloud LLM observability and evaluations for reliable AI applications and agents.](https://langfuse.com/?utm_source=clickhouse_topnav) Open source - [![ClickHouse](https://clickhouse.com/images/nav/icon-clickhouse.svg)ClickHouse Fast open-source OLAP database for real-time analytics.](https://clickhouse.com/clickhouse) - [![ClickStack](https://clickhouse.com/images/nav/icon-clickstack.svg)ClickStack Open-source observability stack for logs, metrics, traces, and session replays.](https://clickhouse.com/clickstack) - [![Agentic Data Stack](https://clickhouse.com/images/nav/icon-agentic-data-stack.svg)Agentic Data Stack Build AI-powered applications with ClickHouse.](https://clickhouse.com/ai) - [![chDB](https://clickhouse.com/images/nav/icon-chdb.svg)chDB In-process SQL Engine powered by ClickHouse, with a Pandas-compatible API](https://clickhouse.com/chdb) - [Solutions](https://clickhouse.com/videos/[slug]) Use cases - [Real-time analytics](https://clickhouse.com/use-cases/real-time-analytics) - [Observability](https://clickhouse.com/cloud/clickstack) - [Data warehousing](https://clickhouse.com/use-cases/data-warehousing) - [Machine learning and GenAI](https://clickhouse.com/use-cases/machine-learning-and-data-science) - [All use cases](https://clickhouse.com/use-cases) [All use cases \-\>\-\>](https://clickhouse.com/use-cases) Industries - [Cybersecurity](https://clickhouse.com/industries/cybersecurity) - [Gaming and entertainment](https://clickhouse.com/industries/gaming) - [E-commerce and retail](https://clickhouse.com/industries/retail) - [Automotive](https://clickhouse.com/industries/automotive) - [Energy](https://clickhouse.com/industries/energy) - [All industries](https://clickhouse.com/industries) [All industries \-\>\-\>](https://clickhouse.com/industries) - [Docs](https://clickhouse.com/docs) - [Resources](https://clickhouse.com/videos/[slug]) - [User stories](https://clickhouse.com/user-stories) - [Blog](https://clickhouse.com/blog) - [Events](https://clickhouse.com/company/events) - [News](https://clickhouse.com/company/news) - [Learning and certification](https://clickhouse.com/learn) - [Comparisons](https://clickhouse.com/videos/how-to-compute-running-aggregation-in-clickhouse) - [Benchmark hub](https://clickhouse.com/benchmarks) - [BigQuery](https://clickhouse.com/comparison/bigquery) - [PostgreSQL](https://clickhouse.com/comparison/postgresql) - [Redshift](https://clickhouse.com/comparison/redshift) - [Snowflake](https://clickhouse.com/comparison/snowflake) - [Elastic Observability](https://clickhouse.com/comparison/elastic-for-observability) - [Splunk](https://clickhouse.com/comparison/splunk-for-observability) - [OpenSearch For observability](https://clickhouse.com/comparison/opensearch-for-observability) - [Videos](https://clickhouse.com/videos) - [Demos](https://clickhouse.com/demos) - [Pricing](https://clickhouse.com/pricing) - [Contact us](https://clickhouse.com/company/contact?loc=nav) Open search Open region selector - [English](https://clickhouse.com/?country=en) - [Japanese](https://clickhouse.com/jp?country=jp) [46\.9k](https://github.com/ClickHouse/ClickHouse?utm_source=clickhouse&utm_medium=website&utm_campaign=website-nav) [Sign in](https://console.clickhouse.cloud/signIn?glxid=26aa454a-718f-4a9a-a193-1cce52e4a752&pagePath=%2Fvideos%2Fhow-to-compute-running-aggregation-in-clickhouse&origPath=%2Fvideos%2Fhow-to-compute-running-aggregation-in-clickhouse) [Get started](https://console.clickhouse.cloud/signUp?loc=nav-get-started&glxid=26aa454a-718f-4a9a-a193-1cce52e4a752&pagePath=%2Fvideos%2Fhow-to-compute-running-aggregation-in-clickhouse&origPath=%2Fvideos%2Fhow-to-compute-running-aggregation-in-clickhouse) - [Videos](https://clickhouse.com/videos) - / - [How to](https://clickhouse.com/videos?category=how-to) # How to Compute a Running Aggregation in ClickHouse [Previous videoScaling ClickHouse to petabytes of logs at OpenAI](https://clickhouse.com/videos/openai) [Next videoClickHouse Cloud Live Update - February 2024](https://clickhouse.com/videos/clickhouse-cloud-update-call-feb2024) ## Rich Raposa Director, Global Learning, ClickHouse Using aggregate functions in a materialized view in ClickHouse can lead to surprising results if you don't define them properly. The AggregatingMergeTree table engine requires special column types for representing and storing intermediate (running) totals of aggregations like avg, max, min, uniq, count, and all the other aggregate functions in ClickHouse. ## Recent videos [View all Videos](https://clickhouse.com/videos) [![YouTube Video: IyI0YQBCy8U](https://clickhouse.com/_next/image?url=%2Fimages%2Ffallback-video-thumbnail.png&w=3840&q=75) How to CDC ClickPipes: The Fastest Way to Replicate Your Database to ClickHouse Marta Paes, Senior Product Manager at ClickHouse](https://clickhouse.com/videos/202602-APJ-Webinar-CDC-ClickPipes) [![YouTube Video: Mgsm11T7tO8](https://clickhouse.com/_next/image?url=%2Fimages%2Ffallback-video-thumbnail.png&w=3840&q=75) How to Under-the-Hood: ClickHouse Incremental Materialized Views and Dictionaries Maruthi Lokanathan, Solution Architect at ClickHouse Derek Chia, Principal TAM Architect at ClickHouse](https://clickhouse.com/videos/202601-APJ-Webinar-Materialized-Views) [![YouTube Video: -piPcapMtc0](https://clickhouse.com/_next/image?url=%2Fimages%2Ffallback-video-thumbnail.png&w=3840&q=75) ClickHouse Cloud, How to LogHouse, Observability for ClickHouse Cloud Get an insider’s look at LogHouse, the ClickHouse-powered logging platform that drives observability for ClickHouse Cloud.](https://clickhouse.com/videos/loghouse-observability-for-clickhouse-cloud) Follow us [![X](https://clickhouse.com/socials/x.svg)X](https://x.com/ClickhouseDB "X")[![Bluesky](https://clickhouse.com/socials/bluesky.svg)Bluesky](https://bsky.app/profile/clickhouse.com "Bluesky")[![Slack](https://clickhouse.com/socials/slack.svg)Slack](https://clickhouse.com/slack "Slack") [![GitHub](https://clickhouse.com/socials/github.svg)GitHub](https://github.com/ClickHouse/ClickHouse "GitHub")[![Telegram](https://clickhouse.com/socials/telegram.svg)Telegram](https://telegram.me/clickhouse_en "Telegram")[![Meetup](https://clickhouse.com/socials/meetup.svg)Meetup](https://www.meetup.com/pro/clickhouse "Meetup") [![Rss](https://clickhouse.com/socials/rss.svg)Rss](https://clickhouse.com/rss.xml "Rss") - - Product - [ClickHouse Cloud](https://clickhouse.com/cloud) - [Bring Your Own Cloud](https://clickhouse.com/cloud/bring-your-own-cloud) - [Postgres managed by ClickHouse](https://clickhouse.com/cloud/postgres) - [Managed ClickStack](https://clickhouse.com/cloud/clickstack) - [ClickHouse](https://clickhouse.com/clickhouse) - [ClickStack](https://clickhouse.com/clickstack) - [Agentic Data Stack](https://clickhouse.com/ai) - [ClickHouse Government](https://clickhouse.com/government) - [ClickHouse Keeper](https://clickhouse.com/clickhouse/keeper) - [ClickPipes](https://clickhouse.com/cloud/clickpipes) - [Integrations](https://clickhouse.com/integrations) - [chDB](https://clickhouse.com/chdb) - [Pricing](https://clickhouse.com/pricing) - - Resources - [Documentation](https://clickhouse.com/docs) - [Trust center](https://trust.clickhouse.com/) - [Training](https://clickhouse.com/learn) - [Support](https://clickhouse.com/support/program) - [Benchmarks](https://clickhouse.com/benchmarks) - [Use cases](https://clickhouse.com/use-cases) - [Videos](https://clickhouse.com/videos) - [Demos](https://clickhouse.com/demos) - [Presentations](https://presentations.clickhouse.com/) - [Real-time data warehouse](https://clickhouse.com/real-time-data-warehouse) - [ClickHouse for data lakes](https://clickhouse.com/clickhouse-for-data-lakes) - [Engineering resources](https://clickhouse.com/resources/engineering) - - Company - [Blog](https://clickhouse.com/blog) - [Our story](https://clickhouse.com/company/our-story) - [Careers](https://clickhouse.com/company/careers) - [Contact us](https://clickhouse.com/company/contact?loc=footer) - [Events](https://clickhouse.com/company/events) - [News](https://clickhouse.com/company/news) - [Media](https://clickhouse.com/media) - - Join our community - [ClickHouse Community](https://clickhouse.com/community) - [GitHub](https://github.com/ClickHouse/ClickHouse) - [Slack](https://clickhouse.com/slack) - [LinkedIn](https://www.linkedin.com/company/clickhouseinc) - [X](https://x.com/ClickhouseDB) - [Bluesky](https://bsky.app/profile/clickhouse.com) - [Telegram](https://telegram.me/clickhouse_en) - [Meetup](https://www.meetup.com/pro/clickhouse) - - Comparisons - [BigQuery](https://clickhouse.com/comparison/bigquery) - [PostgreSQL](https://clickhouse.com/comparison/postgresql) - [Redshift](https://clickhouse.com/comparison/redshift) - [Snowflake](https://clickhouse.com/comparison/snowflake) - [Elastic](https://clickhouse.com/comparison/elastic-for-observability) - [Splunk](https://clickhouse.com/comparison/splunk-for-observability) - [OpenSearch](https://clickhouse.com/comparison/opensearch-for-observability) - Partners - [AWS](https://clickhouse.com/partners/aws) - [Azure](https://clickhouse.com/partners/azure) ![ClickHouse logo](https://clickhouse.com/_next/static/media/logo-full.ac8102d5.svg) Stay informed on feature releases, product roadmap, support, and cloud offerings\! Loading form... [Star us on Github](https://github.com/ClickHouse/ClickHouse) © 2026 ClickHouse, Inc. HQ in the Bay Area, CA and Amsterdam, NL. [Trademark](https://clickhouse.com/legal/trademark-policy)[Privacy](https://clickhouse.com/legal/privacy-policy)[Security](https://trust.clickhouse.com/)[Legal](https://clickhouse.com/legal)[Cookie policy](https://clickhouse.com/legal/cookie-policy) ![Opt-out logo](https://clickhouse.com/images/opt-out-logo.svg)Your privacy choices ![](https://px.ads.linkedin.com/collect/?pid=4908698&fmt=gif)
Readable Markdown	## Rich Raposa Director, Global Learning, ClickHouse Using aggregate functions in a materialized view in ClickHouse can lead to surprising results if you don't define them properly. The AggregatingMergeTree table engine requires special column types for representing and storing intermediate (running) totals of aggregations like avg, max, min, uniq, count, and all the other aggregate functions in ClickHouse. Follow us
Shard	89 (laksa)
Root Hash	12633450985039531489
Unparsed URL	com,clickhouse!/videos/how-to-compute-running-aggregation-in-clickhouse s443