[DRILL-1769] alter session appears not working anymore

• Type: Bug
• Status: Resolved
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 0.7.0
• Fix Version/s: 0.7.0
• Component/s: Storage - Information Schema
• Assignee: Jacques Nadeau
• Reporter: Chun Chang
• Created: 21/Nov/14 02:51
• Updated: 09/Dec/14 17:47
• Resolved: 08/Dec/14 15:55

Description

#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.