[ https://issues.apache.org/jira/browse/HIVE-5277?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13792230#comment-13792230 ]
Teddy Choi commented on HIVE-5277: ---------------------------------- Review request at https://reviews.apache.org/r/14587/ > 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 > > > 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.1#6144)