Return-Path: 
 <dev-return-20422-apmail-drill-dev-archive=drill.apache.org@drill.apache.org>
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 4B6A91851D
	for <apmail-drill-dev-archive@www.apache.org>;
 Wed, 24 Feb 2016 13:10:17 +0000 (UTC)
Received: (qmail 81254 invoked by uid 500); 24 Feb 2016 13:09:18 -0000
Delivered-To: apmail-drill-dev-archive@drill.apache.org
Received: (qmail 81198 invoked by uid 500); 24 Feb 2016 13:09:18 -0000
Mailing-List: contact dev-help@drill.apache.org; run by ezmlm
Precedence: bulk
List-Help: <mailto:dev-help@drill.apache.org>
List-Unsubscribe: <mailto:dev-unsubscribe@drill.apache.org>
List-Post: <mailto:dev@drill.apache.org>
List-Id: <dev.drill.apache.org>
Reply-To: dev@drill.apache.org
Delivered-To: mailing list dev@drill.apache.org
Received: (qmail 81172 invoked by uid 99); 24 Feb 2016 13:09:18 -0000
Received: from arcas.apache.org (HELO arcas) (140.211.11.28)
    by apache.org (qpsmtpd/0.29) with ESMTP; Wed, 24 Feb 2016 13:09:18 +0000
Received: from arcas.apache.org (localhost [127.0.0.1])
	by arcas (Postfix) with ESMTP id 2C8DE2C1F57
	for <dev@drill.apache.org>; Wed, 24 Feb 2016 13:09:18 +0000 (UTC)
Date: Wed, 24 Feb 2016 13:09:18 +0000 (UTC)
From: "Khurram Faraaz (JIRA)" <jira@apache.org>
To: dev@drill.apache.org
Message-ID: <JIRA.12942956.1456319323000.132957.1456319358179@Atlassian.JIRA>
In-Reply-To: <JIRA.12942956.1456319323000@Atlassian.JIRA>
References: <JIRA.12942956.1456319323000@Atlassian.JIRA>
 <JIRA.12942956.1456319323801@arcas>
Subject: [jira] [Created] (DRILL-4429) Need a better error message when
 window frame exclusion is used in frame-clause
MIME-Version: 1.0
Content-Type: text/plain; charset=utf-8
Content-Transfer-Encoding: 7bit
X-JIRA-FingerPrint: 30527f35849b9dde25b450d4833f0394

Khurram Faraaz created DRILL-4429:
-------------------------------------

             Summary: Need a better error message when window frame exclusion is used in frame-clause
                 Key: DRILL-4429
                 URL: https://issues.apache.org/jira/browse/DRILL-4429
             Project: Apache Drill
          Issue Type: Bug
          Components: SQL Parser
    Affects Versions: 1.6.0
            Reporter: Khurram Faraaz
            Priority: Minor


We need to report a proper error message to user when window frame exclusion is used in the window frame-clause. Currently we do not support it and the current error message is not helpful.

Drill 1.6.0
commit ID: 6d5f4983

{noformat}
0: jdbc:drill:schema=dfs.tmp> select count(*) OVER(PARTITION BY CAST(columns[0] as integer) ORDER BY cast(columns[0] as integer) RANGE BETWEEN UNBOUNDED PRECEDING AND UNBOUNDED following EXCLUDE CURRENT ROW) from dfs.tmp.`t_alltype.csv`;
Error: PARSE ERROR: Encountered "EXCLUDE" at line 1, column 158.
Was expecting one of:
    ")" ...
    "ALLOW" ...
    "DISALLOW" ...


while parsing SQL query:
select count(*) OVER(PARTITION BY CAST(columns[0] as integer) ORDER BY cast(columns[0] as integer) RANGE BETWEEN UNBOUNDED PRECEDING AND UNBOUNDED following EXCLUDE CURRENT ROW) from dfs.tmp.`t_alltype.csv`
                                                                                                                                                             ^

[Error Id: ddfcd7fc-1a84-4e1f-8e51-34601e9155a6 on centos-04.qa.lab:31010] (state=,code=0)
{noformat}

>From the SQL specification, we need to add these.

{noformat}
<window frame exclusion> ::=
    EXCLUDE CURRENT ROW
  | EXCLUDE GROUP
  | EXCLUDE TIES
  | EXCLUDE NO OTHERS
{noformat}



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)