Details
-
Bug
-
Status: Closed
-
Critical
-
Resolution: Fixed
-
0.11.0, 0.12.0, 0.11.1, 0.13.0
-
None
Description
HBaseStorageHandler skips rows with null valued first cells when only row key is selected.
SELECT key, col1, col2 FROM hbase_table; key1 cell1 cell2 key2 NULL cell3 SELECT COUNT(key) FROM hbase_table; 1
HiveHBaseTableInputFormat.getRecordReader makes first cell selected to avoid skipping rows. But when the first cell is null, HBase skips that row.
http://hbase.apache.org/book/perf.reading.html 12.9.6. Optimal Loading of Row Keys describes how to deal with this problem.
I tried to find an existing issue, but I couldn't. If you find a same issue, please make this issue duplicated.
Attachments
Attachments
Issue Links
- duplicates
-
HIVE-7566 HIVE can't count hbase NULL column value properly
- Resolved
- relates to
-
HIVE-11849 NPE in HiveHBaseTableShapshotInputFormat in query with just count(*)
- Closed