[ https://issues.apache.org/jira/browse/FLINK-8003?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Shuyi Chen updated FLINK-8003: ------------------------------ Summary: Support named ROW in Flink SQL (was: Support Calcite's ROW value constructor in Flink SQL) > Support named ROW in Flink SQL > ------------------------------ > > Key: FLINK-8003 > URL: https://issues.apache.org/jira/browse/FLINK-8003 > Project: Flink > Issue Type: New Feature > Components: Table API & SQL > Reporter: Shuyi Chen > Assignee: Shuyi Chen > Priority: Major > > We want to use the row value constructor and CAST to create a named row, or > even nested named row, e.g. > {code:sql} > CREATE TYPE myrowtype AS (f1 INTEGER, f2 VARCHAR(10)) > SELECT CAST(ROW(intField, "test") AS myrowtype) AS myRow FROM myTable; > {code} > So if converted to JSON, the output will be > {code:java} > {"myRow":{"f0": ${intField}, "f1":"test"}} > {code}. -- This message was sent by Atlassian JIRA (v7.6.3#76005)