Chun Chang created DRILL-717:
--------------------------------
Summary: set option adds an entry instead of modifying the
existing entry to the new value
Key: DRILL-717
URL: https://issues.apache.org/jira/browse/DRILL-717
Project: Apache Drill
Issue Type: Bug
Reporter: Chun Chang
0: jdbc:drill:schema=dfs> select name, bool_val from sys.options where name
like 'planner%';
+------------+------------+
| name | bool_val |
+------------+------------+
| planner.enable_mergejoin | true |
| planner.enable_broadcast_join | false |
| planner.enable_hashagg | true |
| planner.disable_exchanges | false |
| planner.enable_multiphase_agg | false |
| planner.enable_streamagg | true |
| planner.enable_hashjoin | true |
+------------+------------+
7 rows selected (0.15 seconds)
0: jdbc:drill:schema=dfs> alter session set `planner.enable_mergejoin` = false;
+------------+------------+
| ok | summary |
+------------+------------+
| true | planner.enable_mergejoin updated. |
+------------+------------+
1 row selected (0.038 seconds)
0: jdbc:drill:schema=dfs> select name, bool_val from sys.options where name
like 'planner%';
+------------+------------+
| name | bool_val |
+------------+------------+
| planner.enable_mergejoin | true |
| planner.enable_broadcast_join | false |
| planner.enable_hashagg | true |
| planner.disable_exchanges | false |
| planner.enable_multiphase_agg | false |
| planner.enable_streamagg | true |
| planner.enable_hashjoin | true |
| planner.enable_mergejoin | false |
+------------+------------+
8 rows selected (0.086 seconds)
--
This message was sent by Atlassian JIRA
(v6.2#6252)
