Updated on 2024-03-13 GMT+08:00

Verification

  1. In the test database of GaussDB(DWS), run the following SQL statement to query the number of rows in the table apex2_dynamic_add_remain_test. If the number of rows is the same as that in the source table, the data is consistent.

    1
    SELECT COUNT(*) FROM  db_user01.apex2_dynamic_add_remain_test;
    

  2. Run the following statement to check the data skewness:

    If the data skewness is within 10%, the data distribution is normal. The data migration is complete.
    1
    SELECT TABLE_SKEWNESS('db_user01.apex2_dynamic_add_remain_test');