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

Reply via email to