[HIVE-7566] HIVE can't count hbase NULL column value properly

• Type: Bug
• Status: Resolved
• Priority: Major
• Resolution: Duplicate
• Affects Version/s: 0.13.0
• Component/s: HBase Handler

Environment

HIVE version 0.13.0
HBase version 0.98.0

• Assignee: Unassigned
• Reporter: Kent Kong
• Created: 31/Jul/14 02:16
• Updated: 06/Aug/15 16:44
• Resolved: 06/Aug/15 16:44

Description

HBase table structure is like this:
table name : 'testtable'
column family : 'data'
column 1 : 'name'
column 2 : 'color'

HIVE mapping table is structure is like this:
table name : 'hb_testtable'
column 1 : 'name'
column 2 : 'color'

in hbase, put two rows
James, blue
May

then do select in hive
select * from hb_testtable where color is null

the result is
May, NULL

then try count
select count from hb_testtable where color is null

the result is 0, which should be 1

Issue Links

• is duplicated by: HIVE-5277 HBase handler skips rows with null valued first cells when only row key is selected