drill-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Chun Chang (JIRA)" <j...@apache.org>
Subject [jira] [Commented] (DRILL-717) set option adds an entry instead of modifying the existing entry to the new value
Date Tue, 13 May 2014 21:33:16 GMT

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

Mime
View raw message