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/09 22:25:12 UTC

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

     [ https://issues.apache.org/jira/browse/DRILL-2717?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Sean Hsuan-Yi Chu updated DRILL-2717:
-------------------------------------
    Attachment: DRILL-2717.1.patch

> 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
>         Attachments: DRILL-2717.1.patch
>
>
> {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)