If the Analytics schema has to be recreated, you may encounter this error when attempting to run the sql.sh --action migrate and and sql.sh --action migrate_aggregates commands.
Generally, this would be caused by the Hadoop data node having been formatted, resulting in all HBase data being deleted, and the need for the schema to be recreated. A side effect of this, is that ZooKeeper also needs to be "cleaned" to remove stale references to tables.
To resolve this:
- Stop all HMaster and RegionServer instances using hbase-daemon.sh --stop master, and hbase-daemon.sh --stop regionserver commands on their respective servers.
Note - Do not stop ZooKeeper.
- Run the following command from the bin directory of the HMaster server: ./hbase clean --cleanZk
- Once this command has completed successfully, restart the HBase services (e.g. start-hbase.sh), and re-run the sql.sh commands.