OmniHBaseGSI
OmniHBaseGSI is the HBase secondary index feature.
OmniHBaseGSI employs an independent index table to store index data, accelerating SingleColumnValueFilter conditional query. When a given query condition hits an index, the full-table query of the data table is converted to an exact-range query of the index table to increase the query speed.
OmniHBaseGSI performs the following functions:
- Index management: creates, queries, and deletes an index, and modifies its status.
- Index repair: triggers index repair to ensure that the final query result is correct if the index data hit by a query operation is invalid.
- Index tool: provides a global secondary index tool to create, query, delete, and modify indexes, fill in the index table data, check consistency, repair indexes, and query version information.
Feature scenario analysis
- You can use the API or tool to create an index table for user data (steps 1 and 2).
- An index table in the Active state can be automatically maintained. When you perform a Put or Delete operation on the data in the user data table, the index table data is automatically updated. You can also use the consistency tool to check whether the data table is synchronized with the index table (steps 3, 4, and 5).
- Show the index table based on the user data table (step 6), or perform an Alter operation to convert the index table status (step 7).
- Use the index table to optimize the query of the data table. When the given query condition hits an index, the full-table query of the data table is converted to the exact-range query of the index table (step 8).
- A created index table can be deleted (step 9).
- OmniHBaseGSI supports operations on covering indexes (step 10).
Parent topic: Key Features