1 2 3 4 5 6 7 8 9 10 11
Stream the result of the SELECT query into an existing stream and its underlying topic.
The schema and partitioning column(s) produced by the query must match the stream's schema and key, respectively. If the schema and partitioning column(s) are incompatible with the stream, then the statement will return an error.
from_stream parameters must both refer to a Stream.
Tables are not supported.
If the PARTITION BY clause is present, it is applied to the source after any JOIN or WHERE clauses, and before the SELECT clause, in much the same way as GROUP BY.
Records written into the stream are not timestamp-ordered with respect to other queries. Therefore, the topic partitions of the output stream may contain out-of-order records even if the source stream for the query is ordered by timestamp.
WITH clause to specify details about your table. The
supports the following properties.
Optional query ID to use for INSERT INTO queries. This query ID will be
SHOW QUERIES, and will also be used to terminate the query.
If empty, the default 'INSERTQUERY_' prefix plus a number will be used.
Queries IDs are case-insensitive. Queries IDs will be displayed in uppercase with