[jira] [Created] (FLINK-9161) Support AS STRUCT syntax to create named STRUCT in SQL

classic Classic list List threaded Threaded
1 message Options
Reply | Threaded
Open this post in threaded view
|

[jira] [Created] (FLINK-9161) Support AS STRUCT syntax to create named STRUCT in SQL

Shang Yuanchun (Jira)
Shuyi Chen created FLINK-9161:
---------------------------------

             Summary: Support AS STRUCT syntax to create named STRUCT in SQL
                 Key: FLINK-9161
                 URL: https://issues.apache.org/jira/browse/FLINK-9161
             Project: Flink
          Issue Type: New Feature
          Components: Table API & SQL
            Reporter: Shuyi Chen
            Assignee: Shuyi Chen


As discussed in [calcite dev mailing list|https://mail-archives.apache.org/mod_mbox/calcite-dev/201804.mbox/%3cCAMZk55avGNmp1vXeJwA1B_a8bGyCQ9ahxmE=R=6FKLpf7JTWKQ@...%3e], we want add support for adding named structure construction in SQL, e.g.,

{code:java}
SELECT STRUCT(a as first_name, b as last_name, STRUCT(c as zip code, d as
street, e as state) as address) as record FROM example_table
{code}

This would require adding necessary change in Calcite first.



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