[jira] [Closed] (DRILL-568) set NO_EXCHANGES=true did not have any effect

["Chun Chang (JIRA)" <ji...@apache.org>]

     [ 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)