Joe Bringley created DRILL-5850:
-----------------------------------

             Summary: Problem Querying Directory with Drill
                 Key: DRILL-5850
                 URL: https://issues.apache.org/jira/browse/DRILL-5850
             Project: Apache Drill
          Issue Type: Bug
          Components: Functions - Drill
    Affects Versions: 1.11.0
         Environment: Linux, R (3.4)
            Reporter: Joe Bringley


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

```



--
This message was sent by Atlassian JIRA
(v6.4.14#64029)

Reply via email to