You are viewing a plain text version of this content. The canonical link for it is here.

Posted to dev@drill.apache.org by Chin Wei Low <lo...@gmail.com> on 2015/12/21 03:54:51 UTC

How to restrict query to pick up files by regex

Hi,

I want to query one or more files from a directory and its sub-directory
with filter on file name by something like regex or glob. Appreciate
pointer for me to start. Thanks.

Regards,
Chin Wei

Re: How to restrict query to pick up files by regex

Posted by Chin Wei Low <lo...@gmail.com>.

Thanks. That work for me.

Regards,
Chin Wei

On Mon, Dec 21, 2015 at 11:17 PM, Jacques Nadeau <ja...@dremio.com> wrote:

> You can use an HDFS glob pattern as a table name.
>
> E.g. Select * from dfs.`/abc/cd*`
> On Dec 20, 2015 6:55 PM, "Chin Wei Low" <lo...@gmail.com> wrote:
>
> > Hi,
> >
> > I want to query one or more files from a directory and its sub-directory
> > with filter on file name by something like regex or glob. Appreciate
> > pointer for me to start. Thanks.
> >
> > Regards,
> > Chin Wei
> >
>

Re: How to restrict query to pick up files by regex

Posted by Jacques Nadeau <ja...@dremio.com>.

You can use an HDFS glob pattern as a table name.

E.g. Select * from dfs.`/abc/cd*`
On Dec 20, 2015 6:55 PM, "Chin Wei Low" <lo...@gmail.com> wrote:

> Hi,
>
> I want to query one or more files from a directory and its sub-directory
> with filter on file name by something like regex or glob. Appreciate
> pointer for me to start. Thanks.
>
> Regards,
> Chin Wei
>