Help Center/ Data Lake Insight/ SQL Syntax Reference (Ally Region)/ Flink OpenSource SQL 1.15 Syntax Reference/ Functions/ Built-In Functions/ Value Retrieval Functions
Updated on 2026-01-09 GMT+08:00
View PDF
Share

Value Retrieval Functions

Table 1 Value retrieval functions

SQL Function

Description

tableName.compositeType.field

Returns the value of a field from a Flink composite type (e.g. Tuple, POJO) by name.

tableName.compositeType.*

Returns the flattened representation of a Flink composite type (e.g. Tuple, POJO), converting each of its immediate subtypes into a separate field. In most cases, the fields in the flattened representation have similar names to the original fields, but with a $ separator (e.g. mypojo$mytuple$f0).
Parent Topic: Built-In Functions