[jira] [Created] (BEAM-6810) [SQL] Plan optimizer eliminates aliasing in trivial projections

["Gleb Kanterov (JIRA)" <ji...@apache.org>]

Gleb Kanterov created BEAM-6810:
-----------------------------------

             Summary: [SQL] Plan optimizer eliminates aliasing in trivial projections
                 Key: BEAM-6810
                 URL: https://issues.apache.org/jira/browse/BEAM-6810
             Project: Beam
          Issue Type: Bug
          Components: dsl-sql
    Affects Versions: 2.11.0
            Reporter: Gleb Kanterov
            Assignee: Gleb Kanterov
             Fix For: 2.12.0


Trivial projection is a projection that uses all input columns and doesn't re-order them. Simplest example is:

{code}
SELECT * FROM PCOLLECTION
{code}

Given input PCollection with a schema `c_int64: BIGINT` following query should result in PCollection with a schema `abc: BIGINT`, however, due to a bug in query optimization, it results in `c_int64: BIGINT`

{code}
SELECT c_int64 as abc FROM PCOLLECTION
{code}



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