v.1.1.54337New Feature

Support for Table Functions in DESCRIBE and INSERT Queries

Official CH changelog text
Support for table functions for DESCRIBE and INSERT queries. Added support for subqueries in DESCRIBE. Examples: DESC TABLE remote('host', default.hits); DESC TABLE (SELECT 1); INSERT INTO TABLE FUNCTION remote('host', default.hits). Support for INSERT INTO TABLE in addition to INSERT INTO.
Support for using table functions within DESCRIBE and INSERT queries in ClickHouse, along with added support for subqueries in DESCRIBE statements.

Why it matters

This feature was created to enable more flexible introspection and data manipulation by allowing users to describe the structure of table functions and subqueries, and to insert data directly into the results of table functions. It solves limitations where DESCRIBE and INSERT commands previously only worked with regular tables, enhancing user ability to work with remote and dynamically generated datasets.

How to use it

Use table functions inside DESCRIBE statements, for example:

DESCRIBE TABLE remote('host', default.hits)
DESCRIBE TABLE (SELECT 1)


You can also insert data into table functions by using:

INSERT INTO TABLE FUNCTION remote('host', default.hits) VALUES (...)


Support has been added for INSERT INTO TABLE syntax in addition to INSERT INTO.
PreviousNext