You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@flink.apache.org by "Shuyi Chen (JIRA)" <ji...@apache.org> on 2018/02/03 02:21:00 UTC
[jira] [Updated] (FLINK-8003) Support named ROW in Flink SQL
[ 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)