[ https://issues.apache.org/jira/browse/IMPALA-8152?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Tim Armstrong resolved IMPALA-8152. ----------------------------------- Resolution: Duplicate > Aggregate Commands on HBase Table Omit Null Values > -------------------------------------------------- > > Key: IMPALA-8152 > URL: https://issues.apache.org/jira/browse/IMPALA-8152 > Project: IMPALA > Issue Type: Bug > Affects Versions: Impala 2.12.0 > Reporter: Alan Jackoway > Priority: Major > > We have an HBase-backed impala table, which has a string column (for the > purpose of this jira, {{sCol}}) > There are records where that column is null, which we can observe with > queries like {{select * from table where sCol is null limit 1}} > However, when we run these commands, we get bad results: > {code:sql} > -- Returns 0 > select count(*) from table where sCol is null; > -- Returns only rows for string values (we only have a few options in this > case), no row for null > select sCol, count(*) from table group by sCol > {code} > These commands work as expected on parquet-backed tables. They also do not > work in Hive, where I will file a jira shortly. > -- This message was sent by Atlassian JIRA (v7.6.3#76005)