Data Types
The logical type of a value to declare input and output types of operations in a table ecosystem is described by data types. Flink support a set of pre-defined data types that can be also used in SQL Stream Builder (SSB).
The following list summarizes the pre-defined data types in Flink and SQL Stream Builder:
CHAR
VARCHAR
STRING
BOOLEAN
BINARY
VARBINARY
BYTES
DECIMAL
- Supports fixed precision and scale.TINYINT
SMALLINT
INTEGER
BIGINT
FLOAT
DOUBLE
DATE
TIME
- Only supports a precision of0
.TIMESTAMP
TIMPESTAMP_LTZ
INTERVAL
- Only supports interval ofMONTH
andSECOND(3)
.ARRAY
MULTISET
MAP
ROW
RAW
- Structured types - Only exposed in user-defined functions.