You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues-all@impala.apache.org by "Tim Armstrong (JIRA)" <ji...@apache.org> on 2018/10/30 18:27:01 UTC

[jira] [Resolved] (IMPALA-6276) incorrect projection of null column in hbase

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

Tim Armstrong resolved IMPALA-6276.
-----------------------------------
    Resolution: Duplicate

> incorrect projection of null column in hbase
> --------------------------------------------
>
>                 Key: IMPALA-6276
>                 URL: https://issues.apache.org/jira/browse/IMPALA-6276
>             Project: IMPALA
>          Issue Type: Bug
>            Reporter: Vuk Ercegovac
>            Priority: Major
>              Labels: correctness
>
> -- All rows
> select * from functional_hbase.nulltable;
> a,,b,c,d,e,f,g
> a,,NULL,NULL,NULL,ab,
> -- All rows that satisfy a predicate
> select * from functional_hbase.nulltable where a = 'a';
> a,,b,c,d,e,f,g
> a,,NULL,NULL,NULL,ab,
> -- A null column of the results that satisfy the predicate.
> select d from functional_hbase.nulltable where a = 'a';
> No Results
> Regardless of whether the predicate is pushed down to hbase, we still get no results.
> (force no push by using a complex predicate, e.g., "like")
> The row that satisfies the predicate has been materialized (see the "*" example) so
> projecting d, regardless of its null or not, should yield one record and not an empty result set.
> Against a non-hbase table:
> select d from functional.nulltable where a = 'a';
> a,,b,c,d,e,f,g
> a,,NULL,NULL,NULL,ab,



--
This message was sent by Atlassian JIRA
(v7.6.3#76005)

---------------------------------------------------------------------
To unsubscribe, e-mail: issues-all-unsubscribe@impala.apache.org
For additional commands, e-mail: issues-all-help@impala.apache.org