You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@drill.apache.org by "Victoria Markman (JIRA)" <ji...@apache.org> on 2015/04/24 01:39:39 UTC
[jira] [Updated] (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:all-tabpanel ]
Victoria Markman updated DRILL-2866:
------------------------------------
Attachment: t1.parquet
> 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 - Data Types
> Affects Versions: 0.9.0
> Reporter: Victoria Markman
> Assignee: Sean Hsuan-Yi Chu
> Attachments: t1.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)