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

Problem Querying Directory with Drill

    XMLWordPrintableJSON

    Details

    • Type: Bug
    • Status: Open
    • Priority: Major
    • Resolution: Unresolved
    • Affects Version/s: 1.11.0
    • Fix Version/s: None
    • Component/s: Functions - Drill
    • Labels:
      None
    • Environment:

      Linux, R (3.4)

      Description

      I am connecting to Drill through R. When I try to query a directory with CSV files, everything runs fine. However, if the directory consists of JSON files, Drill returns "file not found". Below you'll see that even if one json file exists on the directory, Drill cannot recognize it unless it is explicitly stated. For example

      ```
      x <- dbGetQuery(conn, "select * from dfs.`/dir/with/json/test.json` LIMIT 5") # works
      y <- dbGetQuery(conn, "select * from dfs.`/dir/with/json/` LIMIT 5") # doesnt work

      Error in .jcall(rp, "I", "fetch", stride, block) :
      java.sql.SQLException: DATA_READ ERROR: Failure reading JSON file - File file:/dir/with/json/test.json does not exist
      ```

        Attachments

          Activity

            People

            • Assignee:
              Unassigned
              Reporter:
              jbringley Joe Bringley
            • Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

              Dates

              • Created:
                Updated: