You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@drill.apache.org by "Chun Chang (JIRA)" <ji...@apache.org> on 2014/05/13 23:33:16 UTC
[jira] [Commented] (DRILL-717) set option adds an entry instead of
modifying the existing entry to the new value
[ https://issues.apache.org/jira/browse/DRILL-717?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13996919#comment-13996919 ]
Chun Chang commented on DRILL-717:
----------------------------------
These are session options, not system options:
0: jdbc:drill:schema=dfs> select name, kind, type, bool_val from sys.options where name like 'planner%';
+------------+------------+------------+------------+
| name | kind | type | bool_val |
+------------+------------+------------+------------+
| planner.enable_mergejoin | BOOLEAN | SYSTEM | true |
| planner.enable_broadcast_join | BOOLEAN | SYSTEM | false |
| planner.enable_hashagg | BOOLEAN | SYSTEM | true |
| planner.disable_exchanges | BOOLEAN | SYSTEM | false |
| planner.enable_multiphase_agg | BOOLEAN | SYSTEM | false |
| planner.enable_streamagg | BOOLEAN | SYSTEM | true |
| planner.enable_hashjoin | BOOLEAN | SYSTEM | true |
| planner.enable_mergejoin | BOOLEAN | SESSION | false |
+------------+------------+------------+------------+
8 rows selected (0.076 seconds)
> 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
> Assignee: 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)