Skip to content

This page is available in Markdown format. Markdown is recommended for AI consumption. See https://clickhouse.com/docs/reference/system-tables/zeros/index.md for this page, orhttps://clickhouse.com/llms.txt for the full documentation index.

ClickHouse Docs

ClickHouse Cloud

ClickHouse Cloud

ClickHouse Managed Postgres

Open source

Agentic Data Stack

Kubernetes Operator

Language clients

Development & contributing

49.6k Sign in Get Started

/

Home
SQL Reference
- Syntax
- Loading…
- Overview
  EXISTS
  Distributed DDL
Data Types
Engines
- Overview
- Overview
  Loading…
  Overview
  Log table engine
  StripeLog table engine
  TinyLog table engine
  Loading…
  Loading…
- Loading…
Functions
- Functions Overview
- Loading…
- Overview
  Combinators
  GROUPING
  Parametric
  Loading…
- Loading…
- Loading…
- UDF
  WebAssembly UDFs
Formats
Interfaces
- Native Protocol
- Native Format
Settings
- Overview
- Loading…
- Session Settings
  Loading…
- MergeTree tables settings
  Loading…
- Format Settings
  Loading…
- Beta and experimental features
System Tables
Data Lakes
- Overview

English

System Tables

system.zeros

|View as Markdown|Edit this page|Report an issue|

Set up docs MCP

Choose your path

Description

Produces unlimited number of non-materialized zeros.

Columns

zero (UInt8) — dummy

Previoussystem.workloads Nextsystem.zeros_mt

On this page

Description
Columns

Navigation