drill-issues mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Joe Bringley (JIRA)" <j...@apache.org>
Subject [jira] [Created] (DRILL-5850) Problem Querying Directory with Drill
Date Fri, 06 Oct 2017 21:57:01 GMT
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)

Mime
View raw message