Khurram Faraaz created DRILL-3629:
-------------------------------------
Summary: 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: Chris Westin
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)
