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