[
https://issues.apache.org/jira/browse/DRILL-5850?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Joe Bringley updated DRILL-5850:
--------------------------------
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
`
was:
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
```
> 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)
