On this page

Description

Show all

Help Center/ Data Lake Insight/ Flink SQL Syntax Reference/ Flink OpenSource SQL 1.15 Syntax Reference/ Functions/ Built-In Functions/ Value Construction Functions

Value Construction Functions

Updated on 2024-08-19 GMT+08:00

View PDF

Description

**Table 1** Value construction functions
Value Construction Function	Description
-- implicit constructor with parenthesis (value1 [, value2]*)	Returns a row created from a list of values (value1, value2, ...). The implicit row constructor supports any expression as a field, but requires at least two fields. The explicit row constructor can handle any number of fields, but currently does not support all types of field expressions well.
ARRAY '[' value1 [, value2 ]* ']'	Returns an array created from a list of values (value1, value2, ...).
MAP '[' value1, value2 [, value3, value4 ]* ']'	Returns a map created from a list of key-value pairs ((value1, value2), (value3, value4), ...).

Parent topic: Built-In Functions

Previous topic: JSON Functions

Next topic: Value Retrieval Functions

Feedback

Was this page helpful?

Helpful Not helpful

Provide feedback

Thank you very much for your feedback. We will continue working to improve the documentation.

The system is busy. Please try again later.

Which of the following issues have you encountered?

Content is inconsistent with the product UI

Unclear descriptions

Lack of examples or code

Incorrect steps

Can't find what I need

Lack of best practices

Feedback (optional)

0/500

Select at least one type of issue, and enter your comments or suggestions.

Enter a maximum of 500 characters.

Submit Cancel

Feedback

Feedback

Feedback

0/500

Selected Content

Submit selected content with the feedback