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/05/22 01:07:17 UTC
[jira] [Commented] (DRILL-2866) Incorrect error message reporting
schema change when streaming aggregation and hash join are disabled
[ https://issues.apache.org/jira/browse/DRILL-2866?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14555226#comment-14555226 ]
Sean Hsuan-Yi Chu commented on DRILL-2866:
------------------------------------------
[~vicky] It is not reproducible. Do you have a view on top of the data source ?
> Incorrect error message reporting schema change when streaming aggregation and hash join are disabled
> -----------------------------------------------------------------------------------------------------
>
> Key: DRILL-2866
> URL: https://issues.apache.org/jira/browse/DRILL-2866
> Project: Apache Drill
> Issue Type: Bug
> Components: Execution - Relational Operators
> Affects Versions: 0.9.0
> Reporter: Victoria Markman
> Assignee: Sean Hsuan-Yi Chu
> Attachments: t1.parquet, t2.parquet
>
>
> alter session set `planner.enable_streamagg` = false;
> alter session set `planner.enable_hashjoin` = false;
> {code}
> 0: jdbc:drill:schema=dfs> select t1.a1,
> . . . . . . . . . . . . > t1.b1,
> . . . . . . . . . . . . > count(distinct t1.c1) as distinct_c1,
> . . . . . . . . . . . . > count(distinct t2.c2) as distinct_c2,
> . . . . . . . . . . . . > sum(t1.a1) as sum_a1,
> . . . . . . . . . . . . > count(t1.c1) as count_a1,
> . . . . . . . . . . . . > count(*) as count_star
> . . . . . . . . . . . . > from
> . . . . . . . . . . . . > t1,
> . . . . . . . . . . . . > t2
> . . . . . . . . . . . . > where
> . . . . . . . . . . . . > t1.a1 = t2.a2 and t1.b1 = t2.b2
> . . . . . . . . . . . . > group by
> . . . . . . . . . . . . > t1.a1,
> . . . . . . . . . . . . > t1.b1,
> . . . . . . . . . . . . > t2.a2,
> . . . . . . . . . . . . > t2.b2
> . . . . . . . . . . . . > order by
> . . . . . . . . . . . . > t1.a1,
> . . . . . . . . . . . . > t1.b1,
> . . . . . . . . . . . . > t2.a2,
> . . . . . . . . . . . . > t2.b2
> . . . . . . . . . . . . > ;
> +------------+------------+-------------+-------------+------------+------------+------------+
> | a1 | b1 | distinct_c1 | distinct_c2 | sum_a1 | count_a1 | count_star |
> +------------+------------+-------------+-------------+------------+------------+------------+
> Query failed: SYSTEM ERROR: Hash aggregate does not support schema changes
> Fragment 0:0
> [10ee2422-d13c-4405-a4b6-a62358f72995 on atsqa4-134.qa.lab:31010]
> (org.apache.drill.exec.exception.SchemaChangeException) Hash aggregate does not support schema changes
> {code}
> copy/paste reproduction
> {code}
> select t1.a1,
> t1.b1,
> count(distinct t1.c1) as distinct_c1,
> count(distinct t2.c2) as distinct_c2,
> sum(t1.a1) as sum_a1,
> count(t1.c1) as count_a1,
> count(*) as count_star
> from
> t1,
> t2
> where
> t1.a1 = t2.a2 and t1.b1 = t2.b2
> group by
> t1.a1,
> t1.b1,
> t2.a2,
> t2.b2
> order by
> t1.a1,
> t1.b1,
> t2.a2,
> t2.b2
> ;
> {code}
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)