Return-Path: X-Original-To: archive-asf-public-internal@cust-asf2.ponee.io Delivered-To: archive-asf-public-internal@cust-asf2.ponee.io Received: from cust-asf.ponee.io (cust-asf.ponee.io [163.172.22.183]) by cust-asf2.ponee.io (Postfix) with ESMTP id 7CBBC200B5E for ; Tue, 26 Jul 2016 23:56:22 +0200 (CEST) Received: by cust-asf.ponee.io (Postfix) id 7B680160AA2; Tue, 26 Jul 2016 21:56:22 +0000 (UTC) Delivered-To: archive-asf-public@cust-asf.ponee.io Received: from mail.apache.org (hermes.apache.org [140.211.11.3]) by cust-asf.ponee.io (Postfix) with SMTP id BA3FA160AA4 for ; Tue, 26 Jul 2016 23:56:21 +0200 (CEST) Received: (qmail 87337 invoked by uid 500); 26 Jul 2016 21:56:20 -0000 Mailing-List: contact issues-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 issues@drill.apache.org Received: (qmail 87122 invoked by uid 99); 26 Jul 2016 21:56:20 -0000 Received: from arcas.apache.org (HELO arcas) (140.211.11.28) by apache.org (qpsmtpd/0.29) with ESMTP; Tue, 26 Jul 2016 21:56:20 +0000 Received: from arcas.apache.org (localhost [127.0.0.1]) by arcas (Postfix) with ESMTP id 842A02C0059 for ; Tue, 26 Jul 2016 21:56:20 +0000 (UTC) Date: Tue, 26 Jul 2016 21:56:20 +0000 (UTC) From: "Yuliya Feldman (JIRA)" To: issues@drill.apache.org Message-ID: In-Reply-To: References: Subject: [jira] [Created] (DRILL-4809) Drill to provide ability to support parameterized conditions MIME-Version: 1.0 Content-Type: text/plain; charset=utf-8 Content-Transfer-Encoding: 7bit X-JIRA-FingerPrint: 30527f35849b9dde25b450d4833f0394 archived-at: Tue, 26 Jul 2016 21:56:22 -0000 Yuliya Feldman created DRILL-4809: ------------------------------------- Summary: Drill to provide ability to support parameterized conditions Key: DRILL-4809 URL: https://issues.apache.org/jira/browse/DRILL-4809 Project: Apache Drill Issue Type: Improvement Components: Execution - Flow, Query Planning & Optimization, SQL Parser Reporter: Yuliya Feldman Currently Drill does not provide ability to specify variables in the WHERE clause which means that user has to create a new query to handle any new condition. For example if someone wants to execute following query: select id, name from foo where dir0=$1 and dir1=$2 (s)he unable to do it and thus if dir0 and dir1 get created on the fly (by day, month or what not) new query needs to be created to handle data in new directories. -- This message was sent by Atlassian JIRA (v6.3.4#6332)