drill-issues mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Chun Chang (JIRA)" <j...@apache.org>
Subject [jira] [Closed] (DRILL-568) set NO_EXCHANGES=true did not have any effect
Date Fri, 10 Mar 2017 01:19:38 GMT

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

Chun Chang closed DRILL-568.
----------------------------

> set NO_EXCHANGES=true did not have any effect
> ---------------------------------------------
>
>                 Key: DRILL-568
>                 URL: https://issues.apache.org/jira/browse/DRILL-568
>             Project: Apache Drill
>          Issue Type: Bug
>            Reporter: Chun Chang
>             Fix For: 0.4.0
>
>
> 0: jdbc:drill:schema=dfs> alter session set NO_EXCHANGES=true;
> +------------+------------+
> |     ok     |  summary   |
> +------------+------------+
> | true       | disabled exchanges. |
> +------------+------------+
> 1 row selected (0.016 seconds)
> The explain plan for still shows we hash to random exchange:
> 0: jdbc:drill:schema=dfs> explain plan for select cast(customer.country as varchar(20))
as c0 from customer as customer where UPPER(cast(customer.country as varchar(20))) = UPPER('USA')
group by cast(customer.country as varchar(20));
> +------------+------------+
> |    text    |    json    |
> +------------+------------+
> ....
>  }, {
>     "pop" : "hash-to-random-exchange",
>     "@id" : 5,
>     "child" : 4,
>     "expr" : "hash(`c0`) "
>   }, {



--
This message was sent by Atlassian JIRA
(v6.3.15#6346)

Mime
View raw message