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