[DRILL-2866] Incorrect error message reporting schema change when streaming aggregation and hash join are disabled

• Type: Bug
• Status: Resolved
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 0.9.0
• Fix Version/s: 1.1.0
• Component/s: Execution - Relational Operators
• Assignee: Sean Hsuan-Yi Chu
• Reporter: Victoria Markman
• Created: 23/Apr/15 23:38
• Updated: 01/Jul/15 01:01
• Resolved: 28/May/15 22:50

Description

alter session set `planner.enable_streamagg` = false;
alter session set `planner.enable_hashjoin` = false;

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

copy/paste reproduction

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
;