Table Functions

Table function is a method of constructing a table.

You can use table functions in:

  • CREATE TABLE AS query.

    It's one of the methods of creating a table.

  • FROM clause of the SELECT query.

    The method of creating a temporary table, that is available only in current query. The table is deleted after the query finishes.


You can't use table functions if the allow_ddl setting is disabled.

Function Description
file Creates a File-engine table.
merge Creates a Merge-engine table.
numbers Creates a table with the single column filled with integer numbers.
remote Allows you to access remote servers without creating a Distributed-engine table.
url Creates a Url-engine table.
mysql Creates a MySQL-engine table.
jdbc Creates a JDBC-engine table.
odbc Creates a ODBC-engine table.
hdfs Creates a HDFS-engine table.