Help wanted!
The following content of this documentation page has been machine-translated. But unlike other websites, it is not done on the fly. This translated text lives on GitHub repository alongside main ClickHouse codebase and waits for fellow native speakers to make it more human-readable. You can also use the original English version as a reference.
numero
numbers(N) – Returns a table with the single ‘number’ columna (UInt64) que contiene enteros de 0 a N-1.
numbers(N, M) - Devuelve una tabla con el único ‘number’ columna (UInt64) que contiene enteros de N a (N + M - 1).
Similar a la system.numbers tabla, puede ser utilizado para probar y generar valores sucesivos, numbers(N, M) más eficiente que system.numbers.
Las siguientes consultas son equivalentes:
SELECT * FROM numbers(10);
SELECT * FROM numbers(0, 10);
SELECT * FROM system.numbers LIMIT 10;
Ejemplos:
-- Generate a sequence of dates from 2010-01-01 to 2010-12-31
select toDate('2010-01-01') + number as d FROM numbers(365);