Alan Jackoway created IMPALA-8152: ------------------------------------- Summary: 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
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)