[
https://issues.apache.org/jira/browse/DRILL-1769?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14220441#comment-14220441
]
Steven Phillips commented on DRILL-1769:
----------------------------------------
It's not certain from what you posted that alter session isn''t working. It
could also be the case that the query is not returning the correct results. In
fact, I think this is more likely to be the case.
If you run explain plan for an aggregate query after disabling hash_agg, does
it still use hash agg?
> alter session appears not working anymore
> -----------------------------------------
>
> Key: DRILL-1769
> URL: https://issues.apache.org/jira/browse/DRILL-1769
> Project: Apache Drill
> Issue Type: Bug
> Components: Storage - Information Schema
> Affects Versions: 0.7.0
> Reporter: Chun Chang
>
> #Thu Nov 20 16:40:45 PST 2014
> git.commit.id.abbrev=fc58c69
> The alter session set returns ok and value updated, but no session entry
> added.
> 0: jdbc:drill:schema=dfs.drillTestDir> ALTER SESSION SET
> `planner.enable_hashagg` = false;
> +------------+------------+
> | ok | summary |
> +------------+------------+
> | true | planner.enable_hashagg updated. |
> +------------+------------+
> 0: jdbc:drill:schema=dfs.drillTestDir> select * from sys.options where name
> like 'planner%';
> +------------+------------+------------+------------+------------+------------+------------+
> | name | kind | type | num_val | string_val | bool_val
> | float_val |
> +------------+------------+------------+------------+------------+------------+------------+
> | planner.memory.max_query_memory_per_node | LONG | SYSTEM | 2048
> | null | null | null |
> | planner.affinity_factor | DOUBLE | SYSTEM | null | null
> | null | 1.2 |
> | planner.join.row_count_estimate_factor | DOUBLE | SYSTEM | null
> | null | null | 1.0 |
> | planner.disable_exchanges | BOOLEAN | SYSTEM | null | null
> | false | null |
> | planner.enable_mergejoin | BOOLEAN | SYSTEM | null | null
> | true | null |
> | planner.enable_broadcast_join | BOOLEAN | SYSTEM | null | null
> | true | null |
> | planner.enable_hashagg | BOOLEAN | SYSTEM | null | null
> | true | null |
> | planner.memory.average_field_width | LONG | SYSTEM | 8 |
> null | null | null |
> | planner.broadcast_threshold | LONG | SYSTEM | 1000000 | null
> | null | null |
> | planner.add_producer_consumer | BOOLEAN | SYSTEM | null | null
> | false | null |
> | planner.producer_consumer_queue_size | LONG | SYSTEM | 10
> | null | null | null |
> | planner.enable_hash_single_key | BOOLEAN | SYSTEM | null |
> null | true | null |
> | planner.memory.hash_agg_table_factor | DOUBLE | SYSTEM | null
> | null | null | 1.1 |
> | planner.width.max_per_node | LONG | SYSTEM | 17 | null
> | null | null |
> | planner.slice_target | LONG | SYSTEM | 100000 | null |
> null | null |
> | planner.enable_multiphase_agg | BOOLEAN | SYSTEM | null | null
> | true | null |
> | planner.memory.enable_memory_estimation | BOOLEAN | SYSTEM | null
> | null | false | null |
> | planner.memory.non_blocking_operators_memory | LONG | SYSTEM | 64
> | null | null | null |
> | planner.enable_streamagg | BOOLEAN | SYSTEM | null | null
> | true | null |
> | planner.memory.hash_join_table_factor | DOUBLE | SYSTEM | null
> | null | null | 1.1 |
> | planner.width.max_per_query | LONG | SYSTEM | 1000 | null
> | null | null |
> | planner.enable_hashjoin | BOOLEAN | SYSTEM | null | null
> | true | null |
> +------------+------------+------------+------------+------------+------------+------------+
> 22 rows selected (0.106 seconds)
> Alter system set works.
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
