Good catch!
Indeed I was using a SNAPSHOT version.
Since I have no choice to upgrade now, I will take the opportunity to get
the latest version of drill!
Thanks Arina,
On Mon, 15 Jul 2019 at 15:22, Arina Yelchiyeva
wrote:
> Hi,
>
> The issue you are describing was fixed in DRILL-6753 [1] which was
> included into 1.15.0 release.
> I suspect you are trying to upgrade to some 1.15.0-SNAPSHOT version rather
> than on 1.15.0 final version.
>
> [1] https://issues.apache.org/jira/browse/DRILL-6753
>
> Kind regards,
> Arina
>
> > On Jul 15, 2019, at 9:17 PM, François Méthot
> wrote:
> >
> > Hi,
> >
> > We are aiming to upgrade our Drill cluster to version 1.15. On my test
> > environment, we found that show files operation can take close to 1+ hour
> > to list content of a directory with only a handful of files.
> >
> > Based on Jstack, it seems a drillbit is busy collecting permission
> > information.
> > Also I see the process "ls -ld .../subpath/files.xyz"
> > showing up in my ps -ef output.
> >
> > I have read about the new information_schema, I suspect it is linked to
> > that feature, is there a flag to enable the show files behaviour from pre
> > 1.15 versions?
> >
> > The folder and files I am navigating are on an NFS mount.
> >
> > Any hints or help would be appreciated
> >
> > Thanks
> > Francois
> >
> > ex:
> >> show files from wrk.base.`2019/`;
> >
> > error... you should enable list_files_recursive
> >> alter system set `storage.list_files_recursive`=true
> >
> >> show files from wrk.base.`2019/`;
> > takes hours to get result
> >
> >
> > wrk.base is /data/
> > which contain:
> > /2019
> > /07
> > /14/~1000 files
> > /13/~1000 files
> > /12/~1000 files
> > ...
> > /2018
> > ...
> > /07
> > /14/~1000 files
> > ...
>
>