[jira] [Updated] (DRILL-4061) Incorrect results returned by window function query.

["Khurram Faraaz (JIRA)" <ji...@apache.org>]

     [ 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)