Mailing-List: contact issues-help@drill.apache.org; run by ezmlm
Precedence: bulk
Reply-To: dev@drill.apache.org
Date: Tue, 10 Nov 2015 19:54:11 +0000 (UTC)
From: "Khurram Faraaz (JIRA)" <jira@apache.org>
To: issues@drill.apache.org
Message-ID: <JIRA.12911959.1447185144000.31600.1447185251029@Atlassian.JIRA>
In-Reply-To: <JIRA.12911959.1447185144000@Atlassian.JIRA>
References: <JIRA.12911959.1447185144000@Atlassian.JIRA>
 <JIRA.12911959.1447185144000@arcas>
Subject: [jira] [Updated] (DRILL-4061) Incorrect results returned by window
 function query.
MIME-Version: 1.0
Content-Type: text/plain; charset=utf-8
Content-Transfer-Encoding: 7bit


     [ https://issues.apache.org/jira/browse/DRILL-4061?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Khurram Faraaz updated DRILL-4061:
----------------------------------
    Attachment: 0_0_0.parquet

> Incorrect results returned by window function query.
> ----------------------------------------------------
>
>                 Key: DRILL-4061
>                 URL: https://issues.apache.org/jira/browse/DRILL-4061
>             Project: Apache Drill
>          Issue Type: Bug
>          Components: Execution - Flow
>    Affects Versions: 1.3.0
>         Environment: 4 node cluster CentOS
>            Reporter: Khurram Faraaz
>         Attachments: 0_0_0.parquet
>
>
> Window function query that uses lag function returns incorrect results.
> sys.version => 3a73f098
> Drill 1.3
> Test parquet file is attached here.
> {code}
> 0: jdbc:drill:schema=dfs.tmp> CREATE TABLE testrepro AS SELECT CAST(columns[0] AS INT) col0, CAST(columns[1] AS INT) col1 FROM `testRepro.csv`;
> +-----------+----------------------------+
> | Fragment  | Number of records written  |
> +-----------+----------------------------+
> | 0_0       | 11                         |
> +-----------+----------------------------+
> 1 row selected (0.542 seconds)
> 0: jdbc:drill:schema=dfs.tmp> select col1, 1 / (col1 - lag(col1) OVER (ORDER BY col0)) from testrepro;
> +-------+---------+
> | col1  | EXPR$1  |
> +-------+---------+
> | 11    | null    |
> | 9     | 0       |
> | 0     | 0       |
> | 10    | 0       |
> | 19    | 0       |
> | 13    | 0       |
> | 17    | 0       |
> | -1    | 0       |
> | 1     | 0       |
> | 20    | 0       |
> | 100   | 0       |
> +-------+---------+
> 11 rows selected (0.451 seconds)
> {code}


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