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] [Created] (DRILL-1769) alter session appears not working anymore
Date Fri, 21 Nov 2014 02:51:34 GMT
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)

Mime
View raw message