Zhiyong Liu created DRILL-2367:
----------------------------------
Summary: drill.exec.storage.file.partition.column.label appears as an option
for both BOOT and SYSTEM
Key: DRILL-2367
URL: https://issues.apache.org/jira/browse/DRILL-2367
Project: Apache Drill
Issue Type: Bug
Components: Metadata
Reporter: Zhiyong Liu
Assignee: Steven Phillips
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 |
+------------+------------+------------+------------+------------+------------+------------+------------+------------+
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
|