You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@drill.apache.org by "Chun Chang (JIRA)" <ji...@apache.org> on 2014/11/21 03:51:34 UTC
[jira] [Created] (DRILL-1769) alter session appears not working
anymore
Chun Chang created DRILL-1769:
---------------------------------
Summary: 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)