[
https://issues.apache.org/jira/browse/DRILL-5850?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16501012#comment-16501012
]
Kunal Khatua commented on DRILL-5850:
-------------------------------------
[~jbringley] do you see the issue even when trying to the SQLLine shell?
> 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
> Priority: Major
>
> 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
(v7.6.3#76005)
