[FLINK-8003] Support named ROW in Flink SQL

• Type: New Feature
• Status: Open
• Priority: Not a Priority
• Resolution: Unresolved
• Component/s: Table SQL / API
• Labels: auto-deprioritized-major auto-deprioritized-minor auto-unassigned
• Assignee: Unassigned
• Reporter: Shuyi Chen
• Created: 07/Nov/17 00:24
• Updated: 31/Dec/21 22:38

Description

We want to use the row value constructor and CAST to create a named row, or even nested named row, e.g.

CREATE TYPE myrowtype AS (f1 INTEGER, f2 VARCHAR(10))
SELECT CAST(ROW(intField, "test") AS myrowtype) AS myRow FROM myTable;

So if converted to JSON, the output will be

{"myRow":{"f0": ${intField}, "f1":"test"}}

.

Issue Links

• is blocked by: FLINK-8039 Add a type SQL DDL