Details
-
Bug
-
Status: Closed
-
Major
-
Resolution: Fixed
-
None
-
None
-
None
Description
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`) " }, {