You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@flink.apache.org by "Kurt Young (JIRA)" <ji...@apache.org> on 2019/04/26 13:38:00 UTC

[jira] [Closed] (FLINK-12200) [Table API] Support UNNEST for MAP types

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

Kurt Young closed FLINK-12200.
------------------------------
       Resolution: Implemented
    Fix Version/s: 1.9.0

merged in 1.9.0: 2c390243739dcbf4a4abe93765b5b2064f6e26c7

> [Table API] Support UNNEST for MAP types 
> -----------------------------------------
>
>                 Key: FLINK-12200
>                 URL: https://issues.apache.org/jira/browse/FLINK-12200
>             Project: Flink
>          Issue Type: Improvement
>          Components: Table SQL / Planner
>    Affects Versions: 1.7.2, 1.7.3, 1.8.0, 1.8.1
>            Reporter: Artsem Semianenka
>            Assignee: Artsem Semianenka
>            Priority: Major
>              Labels: pull-request-available
>             Fix For: 1.9.0
>
>   Original Estimate: 24h
>          Time Spent: 20m
>  Remaining Estimate: 23h 40m
>
> In case if the input dataset has the following schema :
> Row(a: Integer, b: Long, c: Map<String, String>)
> I would like to have the ability to execute the SQL query like:
> {code:sql}
> SELECT a, k, v FROM src, UNNEST(c) as m (k,v)
> {code}
> Currently, the UNNEST operator is supported only for ARRAY and MULTISET  
> I would like to propose adding the support of UNNEST functionality for MAP types.



--
This message was sent by Atlassian JIRA
(v7.6.3#76005)