You need to enable JavaScript to run this app.
ByteHouse Cloud Data Warehouse Version

ByteHouse Cloud Data Warehouse Version

Copy page
Download PDF
System tables
system.zeros
Copy page
Download PDF
system.zeros

The system table system.zeros is a virtual table that generates a series of integer values, each of which is always 0. It is suitable for generating test data with fixed default values or for placeholder filling during numerical calculations.
Example
Query data:

SELECT * FROM system.zeros LIMIT 10;

Query results:

┌──────┐ 
│ zero │ 
├──────┤ 
│ 0    │ 
│ 0    │ 
│ 0    │ 
│ 0    │ 
│ 0    │ 
│ 0    │ 
│ 0    │ 
│ 0    │ 
│ 0    │ 
│ 0    │ 
└──────┘
Last updated: 2026.03.31 16:19:34