[
https://issues.apache.org/jira/browse/HIVE-2771?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13203786#comment-13203786
]
Phabricator commented on HIVE-2771:
-----------------------------------
ashutoshc has commented on the revision "HIVE-2771 [jira] Add support for
filter pushdown for key ranges in hbase for keys of type string".
> Also, note the comment in HBaseStorageHandler.decomposePredicate. Have you
a tested a case such as WHERE key > 20 and key < 30?
For those queries filter will not be pushed exactly because of that comment.
I will update the patch with this test where filter is not pushed in HBase and
filtering is done by Hive.
INLINE COMMENTS
hbase-handler/src/test/results/hbase_ppd_key_range.q.out:47 Hive did remove
the redundant filter. I verified this by adding private logging. Further, even
for queries in hbase_pushdown.q if you look at hbase_pushdown.q.out its the
same behavior where for filter key = 90, its been pushed up in storage handler
still shows up in explain plan.
REVISION DETAIL
https://reviews.facebook.net/D1551
> Add support for filter pushdown for key ranges in hbase for keys of type
> string
> -------------------------------------------------------------------------------
>
> Key: HIVE-2771
> URL: https://issues.apache.org/jira/browse/HIVE-2771
> Project: Hive
> Issue Type: Sub-task
> Components: HBase Handler
> Affects Versions: 0.7.0, 0.7.1, 0.8.0, 0.8.1
> Reporter: Ashutosh Chauhan
> Assignee: Ashutosh Chauhan
> Attachments: HIVE-2771.D1551.1.patch
>
>
> This is a subtask of HIVE-1643
--
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
