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.numbers
Copy page
Download PDF
system.numbers

The system table system.numbers is a virtual table that generates a series of consecutive integers starting from 0, suitable for generating test data or filling data.
Example
Query data:

SELECT * FROM system.numbers LIMIT 10;

Query results:

┌─number─┐ 
│      0 │ 
│      1 │ 
│      2 │ 
│      3 │ 
│      4 │ 
│      5 │ 
│      6 │ 
│      7 │ 
│      8 │ 
│      9 │ 
└────────┘
Last updated: 2026.03.31 16:19:34