You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@drill.apache.org by "Victoria Markman (JIRA)" <ji...@apache.org> on 2015/06/12 23:51:00 UTC
[jira] [Created] (DRILL-3287) Changing session level parameter back
to the default value does not change it
Victoria Markman created DRILL-3287:
---------------------------------------
Summary: Changing session level parameter back to the default value does not change it
Key: DRILL-3287
URL: https://issues.apache.org/jira/browse/DRILL-3287
Project: Apache Drill
Issue Type: Bug
Reporter: Victoria Markman
Initial state:
{code}
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)
{code}
I changed session parameter:
{code}
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)
{code}
So far, so good: it appears on changed options list:
{code}
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)
{code}
I changed session parameter back to it's default value:
{code}
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)
{code}
{color:red} It still appears on changed list, even though it has default value:{color}
{code}
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)
{code}
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)