Apache drill: excluding files from query

Vote count: 0

I am doing a query of a hierarchical directory which contains json files and for example image files.

Drill appears to try to parse the image files although I have tried to exclude them.

I have set up the dfs plugin with:

    "defaultInputFormat": "json"

and have only specified the json format in the plugin:

    "formats": {

      "json": {

        "type": "json",

        "extensions": [

          "json"

        ]

      }

    }

I have also tried only selecting the files of type json:

select *from dfs./test/sample where suffix = 'json';

The error I am getting is:

org.apache.drill.common.exceptions.UserRemoteException: DATA_READ ERROR: Error parsing JSON - Unexpected character ((CTRL-CHAR, code 137)): expected a valid value (number, String, array, object, 'true', 'false' or 'null') File /xxx/test/sample/apachedrill.png Record 1 Column 2 Fragment 0:0 [Error Id: 120b1107-2669-4c76-a87c-848bd49bedc1 on xxx:31010]

asked 37 secs ago

dashambles

Let's block ads! (Why?)

Apache drill: excluding files from query