[jira] [Updated] (DRILL-2584) Hbase : When we select an individual column from hbase, drill is ignoring the rows with null values

["Chris Westin (JIRA)" <ji...@apache.org>]

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

Chris Westin updated DRILL-2584:
--------------------------------
    Fix Version/s: 0.9.0

> Hbase : When we select an individual column from hbase, drill is ignoring the rows with null values
> ---------------------------------------------------------------------------------------------------
>
>                 Key: DRILL-2584
>                 URL: https://issues.apache.org/jira/browse/DRILL-2584
>             Project: Apache Drill
>          Issue Type: Bug
>          Components: Storage - HBase
>    Affects Versions: 0.8.0
>            Reporter: Rahul Challapalli
>            Assignee: Aditya Kishore
>             Fix For: 0.9.0
>
>         Attachments: dataload.hql, fewtypes_null_hbase.tbl
>
>
> git.commit.id.abbrev=4d398ed
> {code}
> select cast(cast(a.types.int_col as varchar(100)) as int) int_col from fewtypes_null a; 
> +------------+
> |  int_col   |
> +------------+
> | 1          |
> | 10         |
> | 12         |
> | 13         |
> | 14         |
> | 15         |
> | 16         |
> | 18         |
> | 20         |
> | 3          |
> | 4          |
> | 5          |
> | 6          |
> | 7          |
> | 8          |
> | 9          |
> +------------+
> {code}
> Drill did not return the 4 rows where this column was null. This is inconsistent with rest of drill.
> I attached the csv text file and the dataload script that I used. Let me know if you have any questions



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)