flink-issues mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Rong Rong (JIRA)" <j...@apache.org>
Subject [jira] [Updated] (FLINK-8003) Support Calcite's ROW value constructor in Flink SQL
Date Wed, 08 Nov 2017 23:55:00 GMT

     [ https://issues.apache.org/jira/browse/FLINK-8003?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]

Rong Rong updated FLINK-8003:
-----------------------------
    Description: 
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}.

  was:
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:json}
{"myRow":{"f0": ${intField}, "f1":"test"}}
{code}.


> 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: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
(v6.4.14#64029)

Mime
View raw message