Help Center/ Data Lake Insight/ SQL Syntax Reference (To Be Offline)/ Flink Opensource SQL 1.10 Syntax Reference/ Functions/ Built-In Functions/ Value Construction Functions
Updated on 2022-09-23 GMT+08:00
View PDF

Value Construction Functions

Description

Table 1 Value construction functions

Function

Description

ROW(value1, [, value2]*)

(value1, [, value2]*)

Returns a row created from a list of values (value1, value2,…).

ARRAY '[' value1 [, value2 ]* ']'

Returns an array created from a list of values (value1, value2, …).

MAP '[' key1, value1 [, key2, value2]* ']'

Returns a map created from a list of key-value pairs ((value1, value2), (value3, value4), …).

The key-value pair is (key1, value1),(key2, value2).
Parent topic: Built-In Functions