[
https://issues.apache.org/jira/browse/FLINK-7003?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16245361#comment-16245361
]
Shuyi Chen commented on FLINK-7003:
-----------------------------------
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}
> VARCHAR K0,
> VARCHAR C1,
> 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
(v6.4.14#64029)
