Querying Indexes

Scenario

You can use the GSI tool to view the definition and status of indexes of a data table in batches.

Usage

Run the following command on the HBase client to view the definition and status of an index:

hbase org.apache.hadoop.hbase.hindex.global.mapreduce.GlobalTableIndexer -Dtablename.to.show='table'

The related parameters are described as follows:

tablename.to.show: indicates the name of the table where the index to be queried is.

Figure 1 shows the query result. The index column definition, covering column definition, TTL, pre-partition information, and index status are displayed.

Figure 1 Index query result