Cloudera Docs

Migrate existing tables to use strongly consistent indexing

You can use the index upgrade tool to rebuild your indexes. After you run this tool, your existing tables will use the strongly consistent global index.

If you have Apache Phoenix tables that you migrated to Cloudera Runtime 7.1.6 or higher, you must convert the tables to use the strongly consistent index using the index upgrade tool.

  1. SSH to your HBASE_HOME directory.
  2. Run the following command: 
    $[***HBASE_HOME***]/bin/hbase org.apache.phoenix.mapreduce.index.IndexUpgradeTool -o [***UPGRADE / ROLLBACK***] -tb [***TABLE NAME***]
-lf [***/tmp/index-upgrade-tool.log***]
    Parameters:
    • -o Type whether you want to upgrade or rollback
    • -tb Type the table name that you want to upgrade or rollback
    • -lf Type the path where you want to store the index upgrade tool log file