hive-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Teddy Choi (JIRA)" <j...@apache.org>
Subject [jira] [Commented] (HIVE-5277) HBase handler skips rows with null valued first cells when only row key is selected
Date Sat, 12 Oct 2013 02:11:41 GMT

    [ https://issues.apache.org/jira/browse/HIVE-5277?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13793210#comment-13793210
] 

Teddy Choi commented on HIVE-5277:
----------------------------------

I reproduced those errors, and I'm fixing them.

> 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)

Mime
View raw message