You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@calcite.apache.org by "Maryann Xue (JIRA)" <ji...@apache.org> on 2016/09/21 18:44:20 UTC

[jira] [Created] (CALCITE-1379) When expanding STAR, expand sub-fields in RecordType columns of StructKind.PEEK_FIELDS and StructKind.PEEK_FIELDS_DEFAULT

Maryann Xue created CALCITE-1379:
------------------------------------

             Summary: When expanding STAR, expand sub-fields in RecordType columns of StructKind.PEEK_FIELDS and StructKind.PEEK_FIELDS_DEFAULT
                 Key: CALCITE-1379
                 URL: https://issues.apache.org/jira/browse/CALCITE-1379
             Project: Calcite
          Issue Type: Improvement
    Affects Versions: 1.9.0
            Reporter: Maryann Xue
            Assignee: Maryann Xue
            Priority: Minor


This is part of CALCITE-1208 and is a Phoenix-specific requirement.
For example, if table T's type is defined as
{code}
VARCHAR K0,
VARCHAR C1,
RecordType(INTEGER C0, INTEGER C1) F0,
RecordType(INTEGER C0, INTEGER C2) F1
{code}
, where both F0 and F1 is of StructKind.PEEK_FIELDS or StructKind.PEEK_FIELDS_DEFAULT,
"select * from T" should expand the sub-fields of F0 and F1 and has a return type of
{code}
VARCHAR K0,
VARCHAR C1,
INTEGER F0.C0,
INTEGER F0.C1,
INTEGER F1.C0,
INTEGER F1.C2
{code}




--
This message was sent by Atlassian JIRA
(v6.3.4#6332)