show files in

[Jean-Claude Cote <jc...@gmail.com>]

Hi,

I'm running the show files in dfs.root.`subdir1/subdir2` query.

And got the error "To SHOW FILES in specific directory, enable option
storage.list_files_recursively"

I've turn that on with alter session set
storage.list_files_recursively=true;

However when I now run the query it seems like drill is iterating the
entire file system from the root. It's not just listing the file from
/subdir1/subdir2. My drive has a lot of files in it. I was expecting drill
to list only the given folder.

I'm I correct in thinking it is listing from the root all the files. Any
reason why it is implemented that way?

Thank you
jc

Re: show files in

[Arina Yelchiyeva <ar...@gmail.com>]

Please try on the latest master. This issue has been fixed. No need to use the option as well.

Kind regards,
Arina

> On Nov 2, 2018, at 8:29 PM, Jean-Claude Cote <jc...@gmail.com> wrote:
> 
> Hi,
> 
> I'm running the show files in dfs.root.`subdir1/subdir2` query.
> 
> And got the error "To SHOW FILES in specific directory, enable option
> storage.list_files_recursively"
> 
> I've turn that on with alter session set
> storage.list_files_recursively=true;
> 
> However when I now run the query it seems like drill is iterating the
> entire file system from the root. It's not just listing the file from
> /subdir1/subdir2. My drive has a lot of files in it. I was expecting drill
> to list only the given folder.
> 
> I'm I correct in thinking it is listing from the root all the files. Any
> reason why it is implemented that way?
> 
> Thank you
> jc