[ https://issues.apache.org/jira/browse/HIVE-3617?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13875978#comment-13875978 ]
Ashutosh Chauhan commented on HIVE-3617: ---------------------------------------- Patch looks good. I may be confused but won't flip for >= should be <, instead of <=. Similarly, for <, flip should be >= and so on... > Predicates pushed down to hbase is not handled properly when constant part is > shown first > ----------------------------------------------------------------------------------------- > > Key: HIVE-3617 > URL: https://issues.apache.org/jira/browse/HIVE-3617 > Project: Hive > Issue Type: Bug > Components: HBase Handler > Reporter: Navis > Assignee: Navis > Priority: Minor > Attachments: HIVE-3617.3.patch.txt > > > Test result could not show the difference because predicates pushed down are > not removed currently(HIVE-2897). So I added log message(scan.toMap()) and > checked the output. > with query > select * from hbase_ppd_keyrange where key > 8 and key < 21; > timeRange=[0, 9223372036854775807], batch=-1, startRow=\x00\x00\x00\x08\x00, > stopRow=\x00\x00\x00\x15, ... > but with query > select * from hbase_ppd_keyrange where 8 < key and key < 21; > timeRange=[0, 9223372036854775807], batch=-1, startRow=, > stopRow=\x00\x00\x00\x15, ... -- This message was sent by Atlassian JIRA (v6.1.5#6160)