[PHOENIX-933] Enhance Local index support

• Type: New Feature
• Status: Resolved
• Priority: Major
• Resolution: Fixed
• Assignee: rajeshbabu
• Reporter: rajeshbabu
• Created: 16/Apr/14 06:52
• Updated: 24/Jan/16 03:56
• Resolved: 24/Jan/16 03:56

Description

Hindex(https://github.com/Huawei-Hadoop/hindex) provides local indexing support to HBase. It stores region level index in a separate table, and co-locates the user and index table regions with a custom load balancer.

See http://goo.gl/phkhwC and http://goo.gl/EswlxC for more information.

This JIRA addresses the local indexing solution integration to phoenix.

Issue Links

• relates to: PHOENIX-1139 Failed to disable local index when index update fails
• relates to: PHOENIX-1149 Index mutations should be committed as batches while building local index
• relates to: PHOENIX-1150 scan on local index(index of view) for queries with no where condition should not read other indexes data stored in the shared index table
• relates to: PHOENIX-1238 Rollback index region split on any split failure
• relates to: PHOENIX-1248 CsvBulkLoadTool is failing with IAE when local index specified for --index-table parameter

Sub-Tasks

• Make changes to specify index is local: Closed
• create local index table with the same split keys of user table: Closed
• Custom load balancer to colocate user table regions and index table regions: Closed
• Handle puts on local index table: Closed
• Skip region start key at beginning of local index rows: Closed
• Handle scans on local index table in case any best fit covering local index available: Closed
• 'drop index' should delete index data from local index table: Closed
• Support joining back to data table row from local index when query condition involves leading columns in local index: Closed
• Dynamically add INDEX_TYPE column to SYSTEM.CATALOG if not already there: Closed
• Support index region split on it's corresponding data region split: Closed
• Support index regions merge on their corresponding data regions merge: Resolved
• Replace ReferencingColumn with ColumnReference: Closed
• Performance test local indexing against global indexing: Open
• Use same split logic for intra region splits over local indexes: Resolved
• Commonize logic for adding salt byte and adding region start key in ParallelIterators: Closed
• Document local indexes: Closed
• Support joining back to data table from local index table for join queries: Resolved
• Fix performance issues with unit tests.: Closed
• Prevent necessity of clearing region cache on every access for local indexing: Closed
• Change status of local index during splitting to prevent usage when slower than query through data table: Closed
• Delay setting local index active until usable: Resolved
• Support local immutable index: Closed