Return-Path: X-Original-To: apmail-drill-dev-archive@www.apache.org Delivered-To: apmail-drill-dev-archive@www.apache.org Received: from mail.apache.org (hermes.apache.org [140.211.11.3]) by minotaur.apache.org (Postfix) with SMTP id 5D40A185D0 for ; Mon, 21 Dec 2015 15:17:25 +0000 (UTC) Received: (qmail 52719 invoked by uid 500); 21 Dec 2015 15:17:20 -0000 Delivered-To: apmail-drill-dev-archive@drill.apache.org Received: (qmail 52667 invoked by uid 500); 21 Dec 2015 15:17:19 -0000 Mailing-List: contact dev-help@drill.apache.org; run by ezmlm Precedence: bulk List-Help: List-Unsubscribe: List-Post: List-Id: Reply-To: dev@drill.apache.org Delivered-To: mailing list dev@drill.apache.org Received: (qmail 52655 invoked by uid 99); 21 Dec 2015 15:17:18 -0000 Received: from Unknown (HELO spamd4-us-west.apache.org) (209.188.14.142) by apache.org (qpsmtpd/0.29) with ESMTP; Mon, 21 Dec 2015 15:17:18 +0000 Received: from localhost (localhost [127.0.0.1]) by spamd4-us-west.apache.org (ASF Mail Server at spamd4-us-west.apache.org) with ESMTP id 59102C0185 for ; Mon, 21 Dec 2015 15:17:18 +0000 (UTC) X-Virus-Scanned: Debian amavisd-new at spamd4-us-west.apache.org X-Spam-Flag: NO X-Spam-Score: 2.98 X-Spam-Level: ** X-Spam-Status: No, score=2.98 tagged_above=-999 required=6.31 tests=[DKIM_SIGNED=0.1, DKIM_VALID=-0.1, HTML_MESSAGE=3, RCVD_IN_MSPIKE_H3=-0.01, RCVD_IN_MSPIKE_WL=-0.01] autolearn=disabled Authentication-Results: spamd4-us-west.apache.org (amavisd-new); dkim=pass (2048-bit key) header.d=dremio-com.20150623.gappssmtp.com Received: from mx1-us-east.apache.org ([10.40.0.8]) by localhost (spamd4-us-west.apache.org [10.40.0.11]) (amavisd-new, port 10024) with ESMTP id R6z--O1iVQ31 for ; Mon, 21 Dec 2015 15:17:17 +0000 (UTC) Received: from mail-wm0-f43.google.com (mail-wm0-f43.google.com [74.125.82.43]) by mx1-us-east.apache.org (ASF Mail Server at mx1-us-east.apache.org) with ESMTPS id 632E2439AA for ; Mon, 21 Dec 2015 15:17:17 +0000 (UTC) Received: by mail-wm0-f43.google.com with SMTP id l126so73533267wml.0 for ; Mon, 21 Dec 2015 07:17:17 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=dremio-com.20150623.gappssmtp.com; s=20150623; h=mime-version:in-reply-to:references:date:message-id:subject:from:to :content-type; bh=8ubqD7E3rsUZVg5Qr1SnHZC5yTjqTtfO0UecPbxk27M=; b=YDmRqXU4JSwH7tTFwHearAUA8vV/bdN0vc6pyy8voq0WhAVPoWULqAeyAlClYlBvvI /nDu0P6kmKSLcDa3L2HZE5sDc2wukMCRvWc0Phnwtn+hoWaFitf5nheZOculdl55ylJ/ DPOurXNBqo6HovGu8F1ElSpmkcIfjePSxvlOUmuAjeQe5ybp9cgAmdiZ8+A0LGHwwjbA FCXusgltW5p1m7H57JVyhlW8yNjYsNRoJN34leVb92VjkCbpJ48sLvBCLyVj8GIUm8RG o1xr2GTspojwCh5/ttPKGLBg9Ysygr47wVK0HM8TXE92JZjgoWfYorvrPnWfRiPYCrJD orfA== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20130820; h=x-gm-message-state:mime-version:in-reply-to:references:date :message-id:subject:from:to:content-type; bh=8ubqD7E3rsUZVg5Qr1SnHZC5yTjqTtfO0UecPbxk27M=; b=G0MIlzgtAud6nc5SJoY+LZybKvT9eIAsJ6pp//M72cEkOVG1NI9XXGxHm3H7h2unZE ZXBToBzLHJqBqg+5fBbxWg7VjOsdoZG/5WDKGpDxt1daaeB/Ug1NWDlIQj0lV1QcWrRd fMvW8dJnYo9ryfO/hDSDJ58GaYMQhPTXTJJFgTPGVw1C/1Ky4pOBuQFHJ4bRMG5TdJTX pcuPuASrd2P411WvQbjDbV9BAlB45L/Z7ajc/CWterPDRmd8jfpw0XVFBB/O/CigfJr6 5StvTUi3Oo0ar4TZyXVSEvU5cBC5NCGBqTYf/3lDG/O33bNeN30ol3iCHnhSbBqgncqm 6sKQ== X-Gm-Message-State: ALoCoQk2/5FVT5LinuxK/7wSCSXzQXXBTh1fYZd+PO0s6nTxoTdxKogLNCmE4oCSuDPdd+cMd6IrLZaZE4O/2V87pnp+QGuT0A== MIME-Version: 1.0 X-Received: by 10.28.50.193 with SMTP id y184mr22228262wmy.26.1450711036601; Mon, 21 Dec 2015 07:17:16 -0800 (PST) Received: by 10.27.50.194 with HTTP; Mon, 21 Dec 2015 07:17:16 -0800 (PST) Received: by 10.27.50.194 with HTTP; Mon, 21 Dec 2015 07:17:16 -0800 (PST) In-Reply-To: References: Date: Mon, 21 Dec 2015 07:17:16 -0800 Message-ID: Subject: Re: How to restrict query to pick up files by regex From: Jacques Nadeau To: dev Content-Type: multipart/alternative; boundary=001a1140d862027532052769fcda --001a1140d862027532052769fcda Content-Type: text/plain; charset=UTF-8 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" 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 > --001a1140d862027532052769fcda--