Uploaded image for project: 'Apache Drill'
  1. Apache Drill
  2. DRILL-2367

Need to remove drill.exec.storage.file.partition.column.label as BOOT option (from drill-module.conf)

    XMLWordPrintableJSON

    Details

    • Type: Bug
    • Status: Closed
    • Priority: Major
    • Resolution: Fixed
    • Affects Version/s: None
    • Fix Version/s: 0.9.0
    • Component/s: Metadata

      Description

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

        Attachments

        1. DRILL-2367.1.patch.txt
          3 kB
          Sudheesh Katkam
        2. DRILL-2367.2.patch.txt
          6 kB
          Sudheesh Katkam

          Activity

            People

            • Assignee:
              sudheeshkatkam Sudheesh Katkam
              Reporter:
              zhiyongliu Zhiyong Liu
            • Votes:
              0 Vote for this issue
              Watchers:
              4 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: