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

[Shang Yuanchun (Jira)]

Artsem Semianenka created FLINK-12200:
-----------------------------------------

             Summary: [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.8.0, 1.7.2, 1.7.3, 1.8.1
            Reporter: Artsem Semianenka
            Assignee: Artsem Semianenka


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)