[ 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