@Xiaojie Ma Are you willing to upgrade to latest 2.3.x release? This JIRA is included in the HDP 2.3.6 ... View more

This NPE shows that .tableinfo file does not exist. As suggested by Predrag below, run the repair tool multople times might solve the problem. (of course, sometime it might not solve the problem. We have to manually fix the issue) Another thing is that please check whether any file/directory exist for this 'prod:testj' table (via hdfs commands). I suspected that the entire table directory disappear (as I mentioned earlier, someone might make a mistake by removing this directory). In this case, another solution is to drop this table and recreate the table and re-populate data. ... View more

no, this only checks inconsistency, you need to add '-repair' argument ... View more

What this means that the meta data of the region is in hbase system table (hbase:meta), but we could not find the data directories for the region in the filesystem (HDFS). One possibility is that somehow someone manually deleted the data directories. You could manually check whether the data is indeed does not exist. Or you can repair it using the hbase hbck -repair' tool (which will create the directories to make it consistent). You might need to run a couple of times to finally fix the issue. Note: one more thing, my suggestion is based on all your 75 inconsistencies are the same type you pasted. ... View more

Could you post the details of inconsistencies? ... View more

Because HBase is schemaless Data store and each row can have different columns, you will not be able to know all columns without going through all rows. You can use Apache Phoenix to create table with fix numbers of columns and insert data through Phoenix. (However, if you use the 'dynamic columns' feature in Phoenix, you also could not be 100% sure about all columns if you don't know the design upfront). ... View more

could you share out the version of the hbase you are using? ... View more

Please use 'hbase hbck' first. The region might be legally offline (eg. parent region of the splitted region). ... View more

You can use Master UI to find which region is offline. To troubleshoot root cause, please share the master log and the region that is offline. ... View more

In hbase-site.xml , you need to change the "hbase.rootdir" property to your new location. ... View more