Search code examples
jsonapache-drill

Please retry: error (invalid JSON mapping) for Json

{
    "type": "file",
    "enabled": true,
    "connection": "classpath:///",
    "config": null,
    "workspaces": {
        "jsonfiles": {
            "location": "C:\Users\mypc\Desktop\JSON",
            "writable": true,
            "defaultInputFormat": null
        }
    },
    "formats": {
        "json": {
            "type": "json",
            "extensions": [
                "json"
            ]
        }
    }
}

I get the error below when updating the configuration of storage plugin:

Please retry: error (invalid JSON mapping)

How can i solve this?

Solution

  • Here, in your json data location path is causing error. JSON causes parsing error with backslash.

    Use \\ instead of \ as below.

    "location": "C:\\Users\\mypc\\Desktop\\JSON"