You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@hive.apache.org by "Kent Kong (JIRA)" <ji...@apache.org> on 2014/07/31 04:16:39 UTC
[jira] [Created] (HIVE-7566) HIVE can't count hbase NULL column
value properly
Kent Kong created HIVE-7566:
-------------------------------
Summary: HIVE can't count hbase NULL column value properly
Key: HIVE-7566
URL: https://issues.apache.org/jira/browse/HIVE-7566
Project: Hive
Issue Type: Bug
Components: HBase Handler
Affects Versions: 0.13.0
Environment: HIVE version 0.13.0
HBase version 0.98.0
Reporter: Kent Kong
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
--
This message was sent by Atlassian JIRA
(v6.2#6252)