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

Json files can only be read when they have a .json extension

    XMLWordPrintableJSON

Details

    • Bug
    • Status: Closed
    • Critical
    • Resolution: Fixed
    • None
    • 1.0.0
    • Storage - JSON
    • None

    Description

      It seems that Drill can only discover json data if the file extension is .json.

      We have tried to add the file extension.log as type json in the Storage Plugin (and validated the json) , but without success.

      Would be great if somebody can share a example config or has an idea.

      Storage Plugin Configuration.
      {
      "type": "file",
      "enabled": true,
      "connection": "maprfs:///",
      "workspaces": {
      "root":

      { "location": "/", "writable": false, "storageformat": null }

      ,
      "tmp":

      { "location": "/tmp", "writable": true, "storageformat": "csv" }

      },
      "formats": {
      "log":

      { "type": "json", "extensions": [ "log" ] }

      ,
      "psv":

      { "type": "text", "extensions": [ "tbl" ], "delimiter": "|" }

      ,
      "csv":

      { "type": "text", "extensions": [ "csv" ], "delimiter": "," }

      ,
      "tsv":

      { "type": "text", "extensions": [ "tsv" ], "delimiter": "\t" }

      ,
      "parquet":

      { "type": "parquet" }

      ,
      "json":

      { "type": "json" } }

      }

      Attachments

        1. DRILL-1545.3.patch.txt
          5 kB
          Paul Pearcy
        2. DRILL-1545.2.patch.txt
          3 kB
          Abdel Hakim Deneche

        Issue Links

          Activity

            People

              jaltekruse Jason Altekruse
              jaltekruse Jason Altekruse
              Votes:
              0 Vote for this issue
              Watchers:
              7 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved: