[DRILL-1545] Json files can only be read when they have a .json extension

• Type: Bug
• Status: Closed
• Priority: Critical
• Resolution: Fixed
• Fix Version/s: 1.0.0
• Component/s: Storage - JSON
• Assignee: Jason Altekruse
• Reporter: Jason Altekruse
• Created: 16/Oct/14 17:40
• Updated: 07/May/15 22:47
• Resolved: 07/May/15 18:04

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" } }

}

Issue Links

• is duplicated by: DRILL-1794 Can not make files with extension "log" to be recognized as json format?
• is duplicated by: DRILL-1546 Support specifying extensions for JSON/Parquet data format