You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@hive.apache.org by "Swarnim Kulkarni (JIRA)" <ji...@apache.org> on 2015/08/03 21:52:05 UTC
[jira] [Commented] (HIVE-5277) HBase handler skips rows with null
valued first cells when only row key is selected
[ https://issues.apache.org/jira/browse/HIVE-5277?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14652368#comment-14652368 ]
Swarnim Kulkarni commented on HIVE-5277:
----------------------------------------
Bumping the priority on this to critical as it can cause hive to show completely wrong counts with null columns.
> HBase handler skips rows with null valued first cells when only row key is selected
> -----------------------------------------------------------------------------------
>
> Key: HIVE-5277
> URL: https://issues.apache.org/jira/browse/HIVE-5277
> Project: Hive
> Issue Type: Bug
> Components: HBase Handler
> Affects Versions: 0.11.0, 0.11.1, 0.12.0, 0.13.0
> Reporter: Teddy Choi
> Assignee: Teddy Choi
> Attachments: HIVE-5277.1.patch.txt, HIVE-5277.2.patch.txt
>
>
> HBaseStorageHandler skips rows with null valued first cells when only row key is selected.
> {noformat}
> SELECT key, col1, col2 FROM hbase_table;
> key1 cell1 cell2
> key2 NULL cell3
> SELECT COUNT(key) FROM hbase_table;
> 1
> {noformat}
> 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.
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)