[ https://issues.apache.org/jira/browse/FLINK-8003?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Shuyi Chen updated FLINK-8003: ------------------------------ Comment: was deleted (was: We want to use the row value constructor and CAST to create a named row, or even nested named row, e.g. {code:java} 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 {"myRow":{"f0": ${intField}, "f1":"test"}}.) > Support Calcite's ROW value constructor 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 > > We want to use the row value constructor and CAST to create a named row, or > even nested named row, e.g. > {code:java} > 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 {"myRow":{"f0": ${intField}, > "f1":"test"}}. -- This message was sent by Atlassian JIRA (v6.4.14#64029)