[FLINK-8003] Support named ROW in Flink SQL

• Type: New Feature
• Status: Open
• Priority: Major
• Resolution: Unresolved
• Component/s: Table SQL / API
• Assignee: Shuyi Chen
• Reporter: Shuyi Chen
• Created: 07/Nov/17 00:24
• Updated: 03/Feb/18 02:20

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

Sub-Tasks

• Fix Row value constructor: Resolved