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)
