Return-Path: X-Original-To: apmail-drill-issues-archive@minotaur.apache.org Delivered-To: apmail-drill-issues-archive@minotaur.apache.org Received: from mail.apache.org (hermes.apache.org [140.211.11.3]) by minotaur.apache.org (Postfix) with SMTP id 9F2D61098D for ; Mon, 8 Dec 2014 15:56:12 +0000 (UTC) Received: (qmail 83499 invoked by uid 500); 8 Dec 2014 15:56:12 -0000 Delivered-To: apmail-drill-issues-archive@drill.apache.org Received: (qmail 83458 invoked by uid 500); 8 Dec 2014 15:56:12 -0000 Mailing-List: contact issues-help@drill.apache.org; run by ezmlm Precedence: bulk List-Help: List-Unsubscribe: List-Post: List-Id: Reply-To: dev@drill.apache.org Delivered-To: mailing list issues@drill.apache.org Received: (qmail 83448 invoked by uid 99); 8 Dec 2014 15:56:12 -0000 Received: from arcas.apache.org (HELO arcas.apache.org) (140.211.11.28) by apache.org (qpsmtpd/0.29) with ESMTP; Mon, 08 Dec 2014 15:56:12 +0000 Date: Mon, 8 Dec 2014 15:56:12 +0000 (UTC) From: "Jacques Nadeau (JIRA)" To: issues@drill.apache.org Message-ID: In-Reply-To: References: Subject: [jira] [Resolved] (DRILL-1769) alter session appears not working anymore MIME-Version: 1.0 Content-Type: text/plain; charset=utf-8 Content-Transfer-Encoding: 7bit X-JIRA-FingerPrint: 30527f35849b9dde25b450d4833f0394 [ https://issues.apache.org/jira/browse/DRILL-1769?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Jacques Nadeau resolved DRILL-1769. ----------------------------------- Resolution: Fixed > 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 > Assignee: Jacques Nadeau > Attachments: DRILL-1769.patch > > > #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)