[
https://issues.apache.org/jira/browse/DRILL-3629?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Khurram Faraaz resolved DRILL-3629.
-----------------------------------
Resolution: Invalid
> LEAD function returns null
> --------------------------
>
> Key: DRILL-3629
> URL: https://issues.apache.org/jira/browse/DRILL-3629
> Project: Apache Drill
> Issue Type: Bug
> Components: Execution - Flow
> Affects Versions: 1.2.0
> Environment: 4 node cluster CentOS
> Reporter: Khurram Faraaz
> Assignee: Deneche A. Hakim
> Labels: branch:,
> https://github.com/adeneche/incubator-drill/tree/new-window-funcs, private
> Attachments: 0_0_0.parquet
>
>
> LEAD function returns null when values in input column are unique and do not
> include any nulls. This issue is seen on a private branch
> commit id : 085bfed7
> CTAS used to create the parquet file from CSV input (attached here)
> {code}
> CREATE TABLE FEWRWSPQQ_101 AS (SELECT cast(columns[0] as INT) col0,
> cast(columns[1] as BIGINT) col1, cast(columns[2] as FLOAT) col2,
> cast(columns[3] as DOUBLE) col3, cast(columns[4] as TIME) col4,
> cast(columns[5] as TIMESTAMP) col5, cast(columns[6] as DATE) col6,
> cast(columns[7] as BOOLEAN) col7, cast(columns[8] as char(2)) col8,
> cast(columns[9] as varchar(52)) col9 from `all_types_few.csv`);
> +-----------+----------------------------+
> | Fragment | Number of records written |
> +-----------+----------------------------+
> | 0_0 | 22 |
> +-----------+----------------------------+
> 1 row selected (0.643 seconds)
> {code}
> Data in the column used as input to LEAD function.
> {code}
> 0: jdbc:drill:schema=dfs.tmp> select col0 from FEWRWSPQQ_101;
> +-------------+
> | col0 |
> +-------------+
> | 1 |
> | 2 |
> | 3 |
> | 4 |
> | 5 |
> | 6 |
> | 7 |
> | 8 |
> | 9 |
> | 10 |
> | 2147483647 |
> | 65535 |
> | 1073741823 |
> | -1 |
> | -65535 |
> | 10000000 |
> | 13 |
> | 19 |
> | 29 |
> | 23 |
> | 0 |
> | 109 |
> +-------------+
> 22 rows selected (0.163 seconds)
> {code}
> {code}
> 0: jdbc:drill:schema=dfs.tmp> select col0 , lead(col0) over(partition by col8
> order by col0) from FEWRWSPQQ_101;
> +-------------+---------+
> | col0 | EXPR$1 |
> +-------------+---------+
> | 4 | null |
> | 1 | null |
> | 6 | null |
> | 10 | null |
> | 13 | null |
> | 7 | null |
> | 2147483647 | null |
> | 0 | null |
> | 1073741823 | null |
> | 65535 | null |
> | 29 | null |
> | 109 | null |
> | -65535 | null |
> | 3 | null |
> | 10000000 | null |
> | 9 | null |
> | 23 | null |
> | 8 | null |
> | 5 | null |
> | -1 | null |
> | 2 | null |
> | 19 | null |
> +-------------+---------+
> 22 rows selected (0.305 seconds)
> {code}
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
