ByteHouse Cloud Data Warehouse Version
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 │ └──────┘