Updated on 2024-11-29 GMT+08:00

Querying Index Information

Scenarios

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

How to Use

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 = 'Data table name'

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