Skip to main content

SHOW REPLICA DISTRIBUTION

Description​

This statement is used to display the distribution status of a table or partition replica

grammar:

SHOW REPLICA DISTRIBUTION FROM [db_name.]tbl_name [PARTITION (p1, ...)];

illustrate:

  1. The Graph column in the result shows the replica distribution ratio in the form of a graph

Examples​

  1. View the replica distribution of the table

    SHOW REPLICA DISTRIBUTION FROM tbl1;
  2. View the replica distribution of the partitions of the table

    SHOW REPLICA DISTRIBUTION FROM db1.tbl1 PARTITION(p1, p2);

Keywords​

ADMIN, SHOW, REPLICA, DISTRIBUTION

Best Practice​