drill-issues mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Jacques Nadeau (JIRA)" <j...@apache.org>
Subject [jira] [Updated] (DRILL-2866) Incorrect error message reporting schema change when streaming aggregation and hash join are disabled
Date Wed, 01 Jul 2015 01:02:09 GMT

     [ https://issues.apache.org/jira/browse/DRILL-2866?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]

Jacques Nadeau updated DRILL-2866:
----------------------------------
    Fix Version/s: 1.1.0

> 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
>             Fix For: 1.1.0
>
>         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)

Mime
View raw message