Help Center> Data Lake Insight> SQL Syntax Reference> SQL Syntax for Stream Jobs> Creating a Temporary Stream
View PDF

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

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

Example

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