Updated on 2024-09-29 GMT+08:00

Creating a Temporary Stream

Function

The temporary stream is used to simplify SQL logic. If complex SQL logic is followed, write SQL statements concatenated with temporary streams. The temporary stream is just a logical concept and does not generate any data.

Syntax

The syntax for creating a temporary stream is as follows:

1
CREATE TEMP STREAM stream_id (attr_name attr_type (',' attr_name attr_type)* )

Example

The following is an example of creating a temporary stream:

1
create temp stream a2(attr1 int, attr2 string);