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
