drill-issues mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Khurram Faraaz (JIRA)" <j...@apache.org>
Subject [jira] [Closed] (DRILL-4061) Incorrect results returned by window function query.
Date Wed, 11 Nov 2015 20:01:11 GMT

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

Khurram Faraaz closed DRILL-4061.
---------------------------------

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

Mime
View raw message