Saw similar problems with JSON files when the file count goes over 100 or so. There was a bug open for that. Don't know if it's been resolved.
On Mon, Nov 10, 2014 at 5:54 PM, Suresh Ollala (JIRA) <j...@apache.org> wrote: > Suresh Ollala created DRILL-1681: > ------------------------------------ > > Summary: select with limit on directory with csv files takes > quite long to terminate > Key: DRILL-1681 > URL: https://issues.apache.org/jira/browse/DRILL-1681 > Project: Apache Drill > Issue Type: Bug > Components: Execution - Flow > Reporter: Suresh Ollala > Assignee: Hanifi Gunes > Fix For: 0.7.0 > > > query like select * from `/drill/data` limit 100 takes quite long to > terminate, about 20+ seconds. > > /drill/data includes overall 1100 csv files, all in single directory. > > select * from `/drill/data/d2.csv` limit 100; terminates in 0.2 seconds. > > > > -- > This message was sent by Atlassian JIRA > (v6.3.4#6332) >