[
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)
