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

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

Chun Chang created DRILL-568:
--------------------------------

             Summary: 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


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.2#6252)