You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@drill.apache.org by "Krystal (JIRA)" <ji...@apache.org> on 2015/04/24 02:16:39 UTC
[jira] [Closed] (DRILL-2367) Need to remove
drill.exec.storage.file.partition.column.label as BOOT option (from
drill-module.conf)
[ https://issues.apache.org/jira/browse/DRILL-2367?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Krystal closed DRILL-2367.
--------------------------
Verified that bug is fixed.
drill git.commit.id=9ec257efb7992209e27c82e6f4ee8a5b12cc95e4
0: jdbc:drill:schema=dfs.drillTestDirP1> alter session set `drill.exec.storage.file.partition.column.label` = 'sessiondir';
+------------+------------+
| ok | summary |
+------------+------------+
| true | drill.exec.storage.file.partition.column.label updated. |
+------------+------------+
1 row selected (0.109 seconds)
0: jdbc:drill:schema=dfs.drillTestDirP1> alter system set `drill.exec.storage.file.partition.column.label` = 'systemdir';
+------------+------------+
| ok | summary |
+------------+------------+
| true | drill.exec.storage.file.partition.column.label updated. |
+------------+------------+
1 row selected (0.104 seconds)
0: jdbc:drill:schema=dfs.drillTestDirP1> 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 | STRING | SYSTEM | null | systemdir | null | null |
| drill.exec.storage.file.partition.column.label | STRING | SESSION | null | sessiondir | null | null |
+------------+------------+------------+------------+------------+------------+------------+
> Need to remove drill.exec.storage.file.partition.column.label as BOOT option (from drill-module.conf)
> -----------------------------------------------------------------------------------------------------
>
> Key: DRILL-2367
> URL: https://issues.apache.org/jira/browse/DRILL-2367
> Project: Apache Drill
> Issue Type: Bug
> Components: Metadata
> Reporter: Zhiyong Liu
> Assignee: Sudheesh Katkam
> Labels: no_verified_test
> Fix For: 0.9.0
>
> Attachments: DRILL-2367.1.patch.txt, DRILL-2367.2.patch.txt
>
>
> git.commit.id.abbrev=a84f7b9
> drill.exec.storage.file.partition.column.label, comes up as both an option for BOOT and SYSTEM:
> {code}
> 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 |
> +------------+------------+------------+------------+------------+------------+------------+
> {code}
> When trying to set system/session options, the values are set but they never take effect:
> {code}
> 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 |
> +------------+------------+------------+------------+------------+------------+------------+------------+------------+
> {code}
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)