[
https://issues.apache.org/jira/browse/DRILL-2866?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14555267#comment-14555267
]
Victoria Markman commented on DRILL-2866:
-----------------------------------------
Sean,
There was a similar bug that was filed by Abhishek. You at a time thought that
this one was different.
Resolve it as fixed and I will verify it. And no, there was no view.
Vicky.
> 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)
