[HIVE-21201] Aggregate Commands on HBase Table Omit Null Values

• Type: Bug
• Status: Open
• Priority: Major
• Resolution: Unresolved
• Affects Version/s: 1.1.0
• Assignee: Unassigned
• Reporter: Alan Jackoway
• Created: 01/Feb/19 13:59
• Updated: 04/Feb/19 13:37

Description

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:

-- 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

These commands work as expected on parquet-backed tables. They also do not work in Impala, where I will filed jira IMPALA-8152.

Issue Links

• is related to: IMPALA-8152 Aggregate Commands on HBase Table Omit Null Values
• relates to: IMPALA-283 select count(*) produces inconsistent results for hbase tables because of NULL projection