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