Help Center> Cloud Stream Service> SQL Syntax Reference> Syntax Constraints
View PDF

Syntax Constraints

  • Currently, Stream SQL only supports the following operations: SELECT, FROM, WHERE, UNION, aggregation, window, JOIN between stream and table data, and JOIN between streams.
  • Data cannot be inserted into the source stream.
  • The sink stream cannot be used to perform query operations.

Data Types Supported by Syntax

  • Basic data types: VARCHAR, STRING, BOOLEAN, TINYINT, SMALLINT, INTEGER/INT, BIGINT, REAL/FLOAT, DOUBLE, DECIMAL, DATE, TIME, and TIMESTAMP
  • Array: Square brackets ([]) are used to quote fields. For example: 
    insert into temp select CARDINALITY(ARRAY[1,2,3]) FROM OrderA;