[HIVE-3617] Predicates pushed down to hbase is not handled properly when constant part is shown first

• Type: Bug
• Status: Resolved
• Priority: Minor
• Resolution: Fixed
• Fix Version/s: 0.13.0
• Component/s: HBase Handler
• Assignee: Navis
• Reporter: Navis
• Created: 25/Oct/12 08:45
• Updated: 22/Jan/14 04:23
• Resolved: 22/Jan/14 04:23

Description

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, ...

Issue Links

• blocks: HIVE-3584 Merging compare predicates
• links to: review board