Mailing-List: contact issues-help@drill.apache.org; run by ezmlm
Precedence: bulk
Reply-To: dev@drill.apache.org
Date: Thu, 29 Jun 2017 12:04:00 +0000 (UTC)
From: "N Campbell (JIRA)" <jira@apache.org>
To: issues@drill.apache.org
Message-ID: <JIRA.13083443.1498737826000.134129.1498737840221@Atlassian.JIRA>
In-Reply-To: <JIRA.13083443.1498737826000@Atlassian.JIRA>
References: <JIRA.13083443.1498737826000@Atlassian.JIRA> <JIRA.13083443.1498737826441@jira-lw-us.apache.org>
Subject: [jira] [Created] (DRILL-5620) aggregate FILTER is being pushed to
 vendors that do not support it.
MIME-Version: 1.0
Content-Type: text/plain; charset=utf-8
Content-Transfer-Encoding: 7bit
archived-at: Thu, 29 Jun 2017 12:04:05 -0000

N Campbell created DRILL-5620:
---------------------------------

             Summary: aggregate FILTER is being pushed to vendors that do not support it. 
                 Key: DRILL-5620
                 URL: https://issues.apache.org/jira/browse/DRILL-5620
             Project: Apache Drill
          Issue Type: Bug
          Components: SQL Parser
    Affects Versions: 1.10.0
         Environment: Drill 1.10
            Reporter: N Campbell


Calcite's parser documentation indicates that it has provided for aggregate(<exp>) FILTER.

This construct is not supported by many vendors, hence it such a statement is expressed to Drill against a plugin mapped to JDBC it may fail due to the statement being push down. But the operation will parse/execute when performed locally on dfs etc

select count(  CINT ) filter ( where RNUM > -1) from x.y.z

DATA_READ ERROR: The JDBC storage plugin failed while trying setup the SQL query


https://calcite.apache.org/docs/reference.html


--
This message was sent by Atlassian JIRA
(v6.4.14#64029)