Drill query on empty directory fails

[Nikunj Thakkar <ni...@gmail.com>]

I'm dynamically generating sql queries based on time range provided. My
query module doesn't know if data exist on particular path or not. In case
drill encounters empty directory it fails the scan showing parse error. Is
it expected behavior? Shouldn't it result into no records found?

Also Can I specify file type to consider for scan when I'm querying top
level directory?

Re: Drill query on empty directory fails

[Abhishek Girish <ab...@gmail.com>]

Hey Nikunj,

This is a known issue and there are JIRAs filed for variants of it (empty
file, empty directory, bad records, ...).

To query specific file types, you could try using regex, but i don't think
it works across nested directories.

-Abhishek

On Mon, Oct 12, 2015 at 7:44 AM, Nikunj Thakkar <nikunjthakkar1992@gmail.com
> wrote:

> I'm dynamically generating sql queries based on time range provided. My
> query module doesn't know if data exist on particular path or not. In case
> drill encounters empty directory it fails the scan showing parse error. Is
> it expected behavior? Shouldn't it result into no records found?
>
> Also Can I specify file type to consider for scan when I'm querying top
> level directory?
>