Return-Path: X-Original-To: apmail-drill-issues-archive@minotaur.apache.org Delivered-To: apmail-drill-issues-archive@minotaur.apache.org Received: from mail.apache.org (hermes.apache.org [140.211.11.3]) by minotaur.apache.org (Postfix) with SMTP id 4F3E2177A6 for ; Wed, 27 May 2015 17:23:25 +0000 (UTC) Received: (qmail 83719 invoked by uid 500); 27 May 2015 17:23:25 -0000 Delivered-To: apmail-drill-issues-archive@drill.apache.org Received: (qmail 83691 invoked by uid 500); 27 May 2015 17:23:25 -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 83682 invoked by uid 99); 27 May 2015 17:23:25 -0000 Received: from arcas.apache.org (HELO arcas.apache.org) (140.211.11.28) by apache.org (qpsmtpd/0.29) with ESMTP; Wed, 27 May 2015 17:23:25 +0000 Date: Wed, 27 May 2015 17:23:25 +0000 (UTC) From: "Victoria Markman (JIRA)" To: issues@drill.apache.org Message-ID: In-Reply-To: References: Subject: [jira] [Created] (DRILL-3195) Throw unsupported exception for Window functions that are not currently supported MIME-Version: 1.0 Content-Type: text/plain; charset=utf-8 Content-Transfer-Encoding: 7bit X-JIRA-FingerPrint: 30527f35849b9dde25b450d4833f0394 Victoria Markman created DRILL-3195: --------------------------------------- Summary: Throw unsupported exception for Window functions that are not currently supported Key: DRILL-3195 URL: https://issues.apache.org/jira/browse/DRILL-3195 Project: Apache Drill Issue Type: Bug Components: Query Planning & Optimization Affects Versions: 1.0.0 Reporter: Victoria Markman Assignee: Jinfeng Ni List of window functions that are currently supported by Calcite, that we don't plan to support in 1.1 release: ntile(), lag(), lead(), first_value(), last_value() Examples of behavior if not disabled: IOBE with NTILE: {code} 0: jdbc:drill:schema=dfs> select ntile(3) over (partition by a1 order by a1) from t1; Error: SYSTEM ERROR: java.lang.IndexOutOfBoundsException: index (1) must be less than size (1) [Error Id: 99f1a074-0e68-400e-9c68-d3c623f85a9f on atsqa4-133.qa.lab:31010] (state=,code=0) {code} Schema change exception: {code} 0: jdbc:drill:schema=dfs> select last_value(a1) over (partition by a1) from t1; Error: SYSTEM ERROR: org.apache.drill.exec.exception.SchemaChangeException: Failure while materializing expression. Error in expression at index -1. Error: Missing function implementation: [last_value(INT-OPTIONAL)]. Full expression: --UNKNOWN EXPRESSION--. Fragment 0:0 [Error Id: b5fac51d-0977-4641-9ead-0c98892d123a on atsqa4-133.qa.lab:31010] (state=,code=0) {code} -- This message was sent by Atlassian JIRA (v6.3.4#6332)