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

    • Type: Bug
    • Status: Closed
    • Priority: Critical
    • Resolution: Fixed
    • Affects Version/s: None
    • Fix Version/s: 1.0.0
    • Component/s: Storage - JSON
    • Labels:
      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

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

                Dates

                • Created:
                  Updated:
                  Resolved: