Help Center/
Data Lake Insight/
SQL Syntax Reference (To Be Offline)/
Flink OpenSource SQL 1.12 Syntax Reference/
Functions/
Built-In Functions/
Collection Functions
Updated on 2023-03-17 GMT+08:00
Collection Functions
Description
|
Collection Functions |
Description |
|---|---|
|
CARDINALITY(array) |
Returns the number of elements in array. |
|
array '[' integer ']' |
Returns the element at position INT in array. The index starts from 1. |
|
ELEMENT(array) |
Returns the sole element of array (whose cardinality should be one) Returns NULL if array is empty. Throws an exception if array has more than one element. |
|
CARDINALITY(map) |
Returns the number of entries in map. |
|
map '[' key ']' |
Returns the value specified by key value in map. |
Parent topic: Built-In Functions
Feedback
Was this page helpful?
Provide feedbackThank you very much for your feedback. We will continue working to improve the documentation.
The system is busy. Please try again later.
