Verifying Migration

About this task

After copying data to the new tables, verify that the migration is complete and successful. In increasing order of complexity:

Procedure

  1. Verify that the destination table exists. From the HBase shell, use the list command, or use the hadoop fs -ls /user/john/foo command from a Linux prompt: 
    hbase(main):006:0> list '/user/john/foo'
TABLE
/user/john/foo/mytable01
1 row(s) in 0.0770 seconds
  2. Check the number of rows in the source table against the destination table with the count command: 
    hbase(main):005:0> count '/user/john/foo/mytable01'
30 row(s) in 0.1240 seconds
  3. Hash each table, then compare the hashes.