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] [Updated] (DRILL-3629) LEAD function returns null
Date Wed, 12 Aug 2015 01:02:45 GMT

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

Khurram Faraaz updated DRILL-3629:
----------------------------------
    Labels: branch: https://github.com/adeneche/incubator-drill/tree/new-window-funcs private
 (was: window_funcion)

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

Mime
View raw message