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 <[email protected]> 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 ...<path-im-querying>/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 > ...
