This is an automated email from the ASF dual-hosted git repository. dzamo pushed a commit to branch gh-pages in repository https://gitbox.apache.org/repos/asf/drill.git
commit a48f2017737aa8be21e9c1914f87ad28f0029e0d Author: kingswanwho <[email protected]> AuthorDate: Wed Jun 23 10:26:26 2021 +0800 doc udpate update doc --- .../query-a-file-system/040-querying-directories.md | 19 +++++++++++++++++++ 1 file changed, 19 insertions(+) diff --git a/_docs/query-data/query-a-file-system/040-querying-directories.md b/_docs/query-data/query-a-file-system/040-querying-directories.md index 283830e..524b9ab 100644 --- a/_docs/query-data/query-a-file-system/040-querying-directories.md +++ b/_docs/query-data/query-a-file-system/040-querying-directories.md @@ -152,3 +152,22 @@ Starting in Drill 1.16, Drill uses a Value operator instead of a Scan operator t You can use [query directory functions]({{site.baseurl}}/docs/query-directory-functions/) to restrict a query to one of a number of subdirectories and to prevent Drill from scanning all data in directories. +## Querying Multiple Directories in One Query by Wildcard Matching + +You can query multiple directories and multiple files in one query with the help of Wildcard Matching conveniently. + +1. Query a set of directories: + + SELECT * FROM dfs.`multilevel/parquet/{1994,1995}`; + +2. Query all files in a directory: + + SELETCT * FROM dfs.`multilevel/parquet/1994/*`; + +3. Query multiple directories by single character wildcard matching: + + SELECT * FROM dfs.`multilevel/parquet/199?/*` + +4. Query multiple directories by single character range wildcard matching: + + SELECT * FROM dfs.`multilevel/parquet/199[4-5]/*`
