You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@hive.apache.org by "Sandy Pratt (Commented) (JIRA)" <ji...@apache.org> on 2011/10/12 21:33:12 UTC
[jira] [Commented] (HIVE-1643) support range scans and non-key
columns in HBase filter pushdown
[ https://issues.apache.org/jira/browse/HIVE-1643?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13126073#comment-13126073 ]
Sandy Pratt commented on HIVE-1643:
-----------------------------------
After testing a bit, it looks like calling convertFilter in getRecordReader is causing incorrect results in group by / count queries. I believe this is because the scan range is getting reset for each map, and then three identical result sets are getting merged.
> support range scans and non-key columns in HBase filter pushdown
> ----------------------------------------------------------------
>
> Key: HIVE-1643
> URL: https://issues.apache.org/jira/browse/HIVE-1643
> Project: Hive
> Issue Type: Improvement
> Components: HBase Handler
> Affects Versions: 0.7.0
> Reporter: John Sichi
> Assignee: Vaibhav Aggarwal
> Attachments: hbase_handler.patch
>
>
> HIVE-1226 added support for WHERE rowkey=3. We would like to support WHERE rowkey BETWEEN 10 and 20, as well as predicates on non-rowkeys (plus conjunctions etc). Non-rowkey conditions can't be used to filter out entire ranges, but they can be used to push the per-row filter processing as far down as possible.
--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators: https://issues.apache.org/jira/secure/ContactAdministrators!default.jspa
For more information on JIRA, see: http://www.atlassian.com/software/jira