null - ClickHouse Documentation

Creates a temporary table of the specified structure with the Null table engine. According to the Null-engine properties, the table data is ignored and the table itself is immediately dropped right after the query execution. The function is used for the convenience of test writing and demonstrations.

Syntax

null('structure')

Argument

structure — A list of columns and column types. String.

Returned value

A temporary Null-engine table with the specified structure.

Example

Query with the null function:

INSERT INTO function null('x UInt64') SELECT * FROM numbers_mt(1000000000);

can replace three queries:

CREATE TABLE t (x UInt64) ENGINE = Null;
INSERT INTO t SELECT * FROM numbers_mt(1000000000);
DROP TABLE IF EXISTS t;

Null table engine

Last modified on June 23, 2026

numbersReturns a table with a single `number` column that contains a sequence of integers.

​Syntax

​Argument

​Returned value

​Example

​Related

Syntax

Argument

Returned value

Example

Related