drill-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Aman Sinha (JIRA)" <j...@apache.org>
Subject [jira] [Resolved] (DRILL-1561) Doing 2 phase aggregation after an ORDER BY fails
Date Wed, 17 Dec 2014 22:32:13 GMT

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

Aman Sinha resolved DRILL-1561.
-------------------------------
       Resolution: Fixed
    Fix Version/s: 0.7.0

I had fixed this as part of DRILL-1846.  Added new test case that does 2 phase-aggr after
an order-by.  
Commit # (0.7.0): c7b6cc575
Commit # (master): 6e21eac85

> Doing 2 phase aggregation after an ORDER BY fails 
> --------------------------------------------------
>
>                 Key: DRILL-1561
>                 URL: https://issues.apache.org/jira/browse/DRILL-1561
>             Project: Apache Drill
>          Issue Type: Bug
>          Components: Query Planning & Optimization
>    Affects Versions: 0.7.0
>            Reporter: Aman Sinha
>            Assignee: Aman Sinha
>             Fix For: 0.7.0
>
>
> Doing a COUNT(*) on top of a subquery that has ORDER-BY causes an error 'SingleMergeExchange
only supports a single receiver endpoint'.  See below.
>  
> // set slice_target to 1 to force introducing Exchanges
> 0: jdbc:drill:zk=local> alter session set `planner.slice_target` = 1;
> +------------+------------+
> |     ok     |  summary   |
> +------------+------------+
> | true       | planner.slice_target updated. |
> +------------+------------+
> 1 row selected (0.066 seconds)
> 0: jdbc:drill:zk=local> select count(*) from (select o_custkey from cp.`tpch/orders.parquet`
order by o_custkey);
> Query failed: Failure while setting up query. SingleMergeExchange only supports a single
receiver endpoint [624ab231-755b-4915-8efd-f19758e514a6]



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)

Mime
View raw message