flink-issues mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Shuyi Chen (JIRA)" <j...@apache.org>
Subject [jira] [Comment Edited] (FLINK-7003) "select * from" in Flink SQL should not flatten all fields in the table by default
Date Thu, 09 Nov 2017 08:29:00 GMT

    [ https://issues.apache.org/jira/browse/FLINK-7003?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16245361#comment-16245361

Shuyi Chen edited comment on FLINK-7003 at 11/9/17 8:28 AM:

added  [pull request|https://github.com/apache/flink/pull/4989]

was (Author: suez1224):
added  [link pull request|https://github.com/apache/flink/pull/4989]

> "select * from" in Flink SQL should not flatten all fields in the table by default
> ----------------------------------------------------------------------------------
>                 Key: FLINK-7003
>                 URL: https://issues.apache.org/jira/browse/FLINK-7003
>             Project: Flink
>          Issue Type: Sub-task
>          Components: Table API & SQL
>            Reporter: Shuyi Chen
>            Assignee: Shuyi Chen
> Currently, CompositeRelDataType is extended from RelRecordType(StructKind.PEEK_FIELDS,
...).  In Calcite, StructKind.PEEK_FIELDS would allow us to peek fields for nested types.
However, when we use "select * from", calcite will flatten all nested fields that is marked
as StructKind.PEEK_FIELDS in the table. 
> For example, if the table structure *T* is as follows:
> {code:java}
> RecordType:peek_no_flattening(INTEGER C0, INTEGER C1) F0,
> RecordType:peek_no_flattening(INTEGER C0, INTEGER C2) F1
> {code}
> The following query
> {code:java}
> Select * from T
> {code} should return (K0, C1, F0, F1) instead of (K0, C1, F0.C0, F0.C1, F1.C0, F1.C1),
which is the current behavior.
> After upgrading to Calcite 1.14, this issue should change the type of {{CompositeRelDataType}}
to {{StructKind. PEEK_FIELDS_NO_EXPAND}}.

This message was sent by Atlassian JIRA

View raw message