Uploaded image for project: 'Apache Drill'
  1. Apache Drill
  2. DRILL-3287

Changing session level parameter back to the default value does not change it's status back to DEFAULT

    Details

    • Type: Bug
    • Status: Closed
    • Priority: Major
    • Resolution: Fixed
    • Affects Version/s: None
    • Fix Version/s: 1.2.0
    • Component/s: Execution - Flow
    • Labels:
      None

      Description

      Initial state:

      0: jdbc:drill:schema=dfs> select * from sys.options where status like '%CHANGED%';
      +-----------------------------------+----------+---------+----------+----------+-------------+-----------+------------+
      |               name                |   kind   |  type   |  status  | num_val  | string_val  | bool_val  | float_val  |
      +-----------------------------------+----------+---------+----------+----------+-------------+-----------+------------+
      | planner.enable_decimal_data_type  | BOOLEAN  | SYSTEM  | CHANGED  | null     | null        | true      | null       |
      +-----------------------------------+----------+---------+----------+----------+-------------+-----------+------------+
      1 row selected (0.247 seconds)
      

      I changed session parameter:

      0: jdbc:drill:schema=dfs> alter session set `planner.enable_hashjoin` = false;
      +-------+-----------------------------------+
      |  ok   |              summary              |
      +-------+-----------------------------------+
      | true  | planner.enable_hashjoin updated.  |
      +-------+-----------------------------------+
      1 row selected (0.1 seconds)
      

      So far, so good: it appears on changed options list:

      0: jdbc:drill:schema=dfs> select * from sys.options where status like '%CHANGED%';
      +-----------------------------------+----------+----------+----------+----------+-------------+-----------+------------+
      |               name                |   kind   |   type   |  status  | num_val  | string_val  | bool_val  | float_val  |
      +-----------------------------------+----------+----------+----------+----------+-------------+-----------+------------+
      | planner.enable_decimal_data_type  | BOOLEAN  | SYSTEM   | CHANGED  | null     | null        | true      | null       |
      | planner.enable_hashjoin           | BOOLEAN  | SESSION  | CHANGED  | null     | null        | false     | null       |
      +-----------------------------------+----------+----------+----------+----------+-------------+-----------+------------+
      2 rows selected (0.133 seconds)
      

      I changed session parameter back to it's default value:

      0: jdbc:drill:schema=dfs> alter session set `planner.enable_hashjoin` = true;
      +-------+-----------------------------------+
      |  ok   |              summary              |
      +-------+-----------------------------------+
      | true  | planner.enable_hashjoin updated.  |
      +-------+-----------------------------------+
      1 row selected (0.096 seconds)
      

      It still appears on changed list, even though it has default value:

      0: jdbc:drill:schema=dfs> select * from sys.options where status like '%CHANGED%';
      +-----------------------------------+----------+----------+----------+----------+-------------+-----------+------------+
      |               name                |   kind   |   type   |  status  | num_val  | string_val  | bool_val  | float_val  |
      +-----------------------------------+----------+----------+----------+----------+-------------+-----------+------------+
      | planner.enable_decimal_data_type  | BOOLEAN  | SYSTEM   | CHANGED  | null     | null        | true      | null       |
      | planner.enable_hashjoin           | BOOLEAN  | SESSION  | CHANGED  | null     | null        | true      | null       |
      +-----------------------------------+----------+----------+----------+----------+-------------+-----------+------------+
      2 rows selected (0.124 seconds)
      

        Attachments

          Issue Links

            Activity

              People

              • Assignee:
                sudheeshkatkam Sudheesh Katkam
                Reporter:
                vicky Victoria Markman
              • Votes:
                0 Vote for this issue
                Watchers:
                1 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved: