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)