Run the Phoenix repair tool
You can run the Phoenix repair tool to gather information about the components of the table. The tool provide capabilities to fix certain problems.
Run the HDFS fsck and HBase hbck tools before running the Phoenix repair tool. Checking the condition of HDFS and HBase is highly recommended because the Phoenix repair tool does not run on HDFS and HBase, both of which must be in working order for the repair tool to fix Phoenix problems.
Verify that no concurrent execution of the Phoenix repair tool launches or runs while you run the tool. Also, ensure that no other clients modify the system catalog data while the tool runs.
Run the psl.py utility with the
If the tool detects previously stored snapshots on the system, respond to the Restore
Respond whether the tool should delete or retain the previously recorded snapshots.
Indicate whether the tool should proceed with the integrity check or restore a table from the one of the snapshots.
After the tool completes the check, you can consider the SYSTEM.CATALOG table as validated. You can proceed with SQL operations in the Phoenix CLI.