drill-issues mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Victoria Markman (JIRA)" <j...@apache.org>
Subject [jira] [Commented] (DRILL-2600) Print list of ALL system settings on each drill restart into drillbit.log
Date Fri, 27 Mar 2015 17:42:53 GMT

    [ https://issues.apache.org/jira/browse/DRILL-2600?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14384220#comment-14384220
] 

Victoria Markman commented on DRILL-2600:
-----------------------------------------

Khurram,

I'm asking to always dump all SYSTEM parameters that were set when drill started.
Session parameters is a different story, this should be recorded as well (drillbit.log with
the session id and Jacques had another idea to record the session specific settings for the
query: in query profile ? )

Can't what you are asking be achieved by running queries below ... We could build some simple
views on top of these queries maybe ?

{code}
0: jdbc:drill:schema=dfs> select * from sys.options where name like '%join%' and type =
'SESSION';
+------------+------------+------------+------------+------------+------------+------------+
|    name    |    kind    |    type    |  num_val   | string_val |  bool_val  | float_val
 |
+------------+------------+------------+------------+------------+------------+------------+
| planner.enable_hashjoin | BOOLEAN    | SESSION    | null       | null       | false    
 | null       |
+------------+------------+------------+------------+------------+------------+------------+

0: jdbc:drill:schema=dfs> select * from sys.options where name like '%join%' and type =
'SYSTEM';
+------------+------------+------------+------------+------------+------------+------------+
|    name    |    kind    |    type    |  num_val   | string_val |  bool_val  | float_val
 |
+------------+------------+------------+------------+------------+------------+------------+
| planner.join.row_count_estimate_factor | DOUBLE     | SYSTEM     | null       | null   
   | null       | 1.0        |
| planner.join.hash_join_swap_margin_factor | DOUBLE     | SYSTEM     | null       | null
      | null       | 10.0       |
| planner.enable_hashjoin_swap | BOOLEAN    | SYSTEM     | null       | null       | true
      | null       |
| planner.enable_mergejoin | BOOLEAN    | SYSTEM     | null       | null       | true    
  | null       |
| planner.enable_broadcast_join | BOOLEAN    | SYSTEM     | null       | null       | true
      | null       |
| planner.memory.hash_join_table_factor | DOUBLE     | SYSTEM     | null       | null    
  | null       | 1.1        |
| planner.enable_hashjoin | BOOLEAN    | SYSTEM     | null       | null       | false    
 | null       |
+------------+------------+------------+------------+------------+------------+------------+
7 rows selected (0.119 seconds)
{code}

> Print list of ALL system settings on each drill restart into drillbit.log
> -------------------------------------------------------------------------
>
>                 Key: DRILL-2600
>                 URL: https://issues.apache.org/jira/browse/DRILL-2600
>             Project: Apache Drill
>          Issue Type: Improvement
>          Components: Storage - Other
>            Reporter: Victoria Markman
>
> When we get logs from the customer site for debugging issues, it will be very important
to know what system parameters were changed when query was executing (or set of queries)



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)

Mime
View raw message