[HIVE-1643] support range scans and non-key columns in HBase filter pushdown

• Type: Improvement
• Status: Open
• Priority: Major
• Resolution: Unresolved
• Affects Version/s: 0.9.0
• Component/s: HBase Handler
• Labels: patch
• Assignee: Unassigned
• Reporter: John Sichi
• Created: 15/Sep/10 22:16
• Updated: 25/Feb/21 22:34

Description

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.

Issue Links

• incorporates: HIVE-2815 Filter pushdown in hbase for keys stored in binary format
• is related to: HIVE-7207 support partial rowkey scan in HBase filter pushdown
• relates to: HIVE-24833 Hive Uses Fetch Task For HBaseStorageHandler Scans
• relates to: HIVE-1226 support filter pushdown against non-native tables

Sub-Tasks

• Add support for filter pushdown for key ranges in hbase for keys of type string: Closed