null
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 droped right after the query execution. The function is used for the convenience of test writing and demonstrations.
Syntax
null('structure')
Parameter
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;
See also:
当前内容版权归 ClickHouse 或其关联方所有,如需对内容或内容相关联开源项目进行关注与资助,请访问 ClickHouse .