You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@drill.apache.org by "Sean Hsuan-Yi Chu (JIRA)" <ji...@apache.org> on 2015/04/08 01:42:12 UTC

[jira] [Created] (DRILL-2717) Union-All reports new schema change when there is actually no

Sean Hsuan-Yi Chu created DRILL-2717:
----------------------------------------

             Summary: Union-All reports new schema change when there is actually no
                 Key: DRILL-2717
                 URL: https://issues.apache.org/jira/browse/DRILL-2717
             Project: Apache Drill
          Issue Type: Bug
          Components: Query Planning & Optimization
            Reporter: Sean Hsuan-Yi Chu
            Assignee: Sean Hsuan-Yi Chu


{code}
select * from
            ((select columns[0] from dfs.`%s` t1
            where t1.columns[0] = 66)
            union all
            (select columns[0] c2 from dfs.`%s` t2
            where t2.columns[0] is not null
            GROUP BY columns[0]
            order by columns[0]))
        group by EXPR$0
        order by EXPR$0
{code}

The Union-All below the aggregator gives the wrong information so that aggregator wrongly reported "schema change"



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