Using a Secondary Index

Scenario

HIndex enables HBase indexing based on specific column values, making the retrieval of data highly efficient and fast.

Constraints

  • Column families are separated by semicolons (;).

  • Columns and data types must be contained in square brackets ([]).

  • The column data type is specified by using -> after the column name.

  • If the column data type is not specified, the default data type (string) is used.

  • The number sign (#) is used to separate two index details.

  • The following is an optional parameter:

    -Dscan.caching: number of cached rows when the data table is scanned.

    The default value is set to 1000.

  • Indexes are created for a single region to repair damaged indexes.

    This function is not used to generate new indexes.

Procedure

  1. Install the HBase client. For details, see Using an HBase Client.

  2. Go to the client installation directory, for example, /opt/client.

    cd /opt/client

  3. Run the following command to configure environment variables:

    source bigdata_env

  4. If the cluster is in security mode, run the following command to authenticate the user. In normal mode, user authentication is not required.

    kinit Component service user

  5. Run the following command to access HIndex:

    hbase org.apache.hadoop.hbase.hindex.mapreduce.TableIndexer

    Table 1 Common HIndex commands

    Description

    Command

    Add Index

    TableIndexer-Dtablename.to.index=table1-Dindexspecs.to.add='IDX1=>cf1:[q1->datatype],[q2],[q3];cf2:[q1->datatype],[q2->datatype]#IDX2=>cf1:[q5]'

    Create Index

    TableIndexer -Dtablename.to.index=table1 -Dindexnames.to.build='IDX1#IDX2'

    Delete Index

    TableIndexer -Dtablename.to.index=table1 -Dindexnames.to.drop='IDX1#IDX2'

    Disable Index

    TableIndexer -Dtablename.to.index=table1 -Dindexnames.to.disable='IDX1#IDX2'

    Add and Create Index

    TableIndexer -Dtablename.to.index=table1 -Dindexspecs.to.add='IDX1=>cf1:[q1->datatype],[q2],[q3];cf2:[q1->datatype],[q2->datatype]#IDX2=>cf1:[q5] -Dindexnames.to.build='IDX1'

    Create Index for a Single Region

    TableIndexer -Dtablename.to.index=table1 -Dregion.to.index=regionEncodedName -Dindexnames.to.build='IDX1#IDX2'

    Note

    • IDX1: indicates the index name.

    • cf1: indicates the column family name.

    • q1: indicates the column name.

    • datatype: indicates the data type, including String, Integer, Double, Float, Long, Short, Byte and Char.