[
https://issues.apache.org/jira/browse/DRILL-2367?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Sudheesh Katkam updated DRILL-2367:
-----------------------------------
Attachment: DRILL-2367.2.patch.txt
> 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
> 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)
