drill-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Khurram Faraaz (JIRA)" <j...@apache.org>
Subject [jira] [Created] (DRILL-3629) LEAD function returns null
Date Wed, 12 Aug 2015 01:00:49 GMT
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)

Mime
View raw message