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:14:39 UTC

[jira] [Updated] (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 updated DRILL-2367:
---------------------------
    Labels: no_verified_test  (was: )

> 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)