Skip to main content
Skip to main content
Edit this page

zeros Table Function

  • zeros(N) – Returns a table with the single 'zero' column (UInt8) that contains the integer 0 N times
  • zeros_mt(N) – The same as zeros, but uses multiple threads.

This function is used for test purposes as the fastest method to generate many rows. Similar to the system.zeros and system.zeros_mt system tables.

The following queries are equivalent:

Try ClickHouse Cloud for FREE

Separation of storage and compute, automatic scaling, built-in SQL console, and lots more. $300 in free credits when signing up.

Try it for Free