[DRILL-2367] Need to remove drill.exec.storage.file.partition.column.label as BOOT option (from drill-module.conf)

• Type: Bug
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Fix Version/s: 0.9.0
• Component/s: Metadata
• Labels: no_verified_test
• Assignee: Sudheesh Katkam
• Reporter: Zhiyong Liu
• Created: 03/Mar/15 23:04
• Updated: 24/Apr/15 00:16
• Resolved: 26/Mar/15 16:01

Description

git.commit.id.abbrev=a84f7b9

drill.exec.storage.file.partition.column.label, comes up as both an option for BOOT and SYSTEM:

0: jdbc:drill:> select * from sys.options where name = 'drill.exec.storage.file.partition.column.label';
+------------+------------+------------+------------+------------+------------+------------+
|    name    |    kind    |    type    |  num_val   | string_val |  bool_val  | float_val  |
+------------+------------+------------+------------+------------+------------+------------+
| drill.exec.storage.file.partition.column.label | null       | BOOT       | null       | "dir"      | null       | null       |
| drill.exec.storage.file.partition.column.label | STRING     | SYSTEM     | null       | dir        | null       | null       |
+------------+------------+------------+------------+------------+------------+------------+

When trying to set system/session options, the values are set but they never take effect:

0: jdbc:drill:> alter session set `drill.exec.storage.file.partition.column.label` = 'sessiondir';
+------------+------------+                                                                       
|     ok     |  summary   |                                                                       
+------------+------------+                                                                       
| true       | drill.exec.storage.file.partition.column.label updated. |                          
+------------+------------+ 
0: jdbc:drill:> alter system set `drill.exec.storage.file.partition.column.label` = 'systemdir';
+------------+------------+
|     ok     |  summary   |
+------------+------------+
| true       | drill.exec.storage.file.partition.column.label updated. |
+------------+------------+
0: jdbc:drill:> select * from sys.options where name = 'drill.exec.storage.file.partition.column.label' order by name;
+------------+------------+------------+------------+------------+------------+------------+
|    name    |    kind    |    type    |  num_val   | string_val |  bool_val  | float_val  |
+------------+------------+------------+------------+------------+------------+------------+
| drill.exec.storage.file.partition.column.label | null       | BOOT       | null       | "dir"      | null       | null       |
| drill.exec.storage.file.partition.column.label | STRING     | SYSTEM     | null       | systemdir  | null       | null       |
| drill.exec.storage.file.partition.column.label | STRING     | SESSION    | null       | sessiondir | null       | null       |
+------------+------------+------------+------------+------------+------------+------------+
0: jdbc:drill:> select * from dfs.`/drill/testdata/json_storage` limit 1;
+------------+------------+------------+------------+------------+------------+------------+------------+------------+
|    dir0    |    dir1    |    dir2    |   first    |    last    |    age     |    sex     |   salary   | registered |
+------------+------------+------------+------------+------------+------------+------------+------------+------------+
| testDirEmployee | null       | null       | Jimmy      | James      | 29         | M          | 6300.1     | false      |
+------------+------------+------------+------------+------------+------------+------------+------------+------------+