CREATE DYNAMIC TABLE¶

Grammar Description¶

CREATE DYNAMIC TABLE Adds a new dynamic table to the current database.

Grammar Structure¶

CREATE DYNAMIC TABLE [IF NOT EXISTS] table_name
AS SELECT ... from stream_name ;

Syntax Explanation¶

table_name: Dynamic table name. The dynamic table name must be different from any existing dynamic table name in the current database.
stream_name: The name of the SOURCE that has been created.

Example¶

create dynamic table dt_test as select * from stream_test;
Query OK, 0 rows affected (0.01 sec)

limit¶

When creating dynamic tables, the use of aggregate functions, mathematical functions, string functions, date functions, as well as limit, offset, from subquery, not in/in subquery, group by, order by, and having` statements are not supported.

When creating dynamic tables, joins, SOURCE tables and ordinary data tables are not supported for the two SOURCE tables.