You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@drill.apache.org by "Zhiyong Liu (JIRA)" <ji...@apache.org> on 2015/03/04 00:05:05 UTC
[jira] [Created] (DRILL-2367)
drill.exec.storage.file.partition.column.label appears as an option for
both BOOT and SYSTEM
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)