ADMIN SHOW DATA SKEW

description

  1. This statement is used to view the data skew of a table or a partition.
  2. grammar:
  3. ADMIN SHOW DATA SKEW FROM [db_name.]tbl_name [PARTITION (p1)];
  4. Description:
  5. 1. Only one partition must be specified. For non-partitioned tables, the partition name is the same as the table name.
  6. 2. The result will show the data volume of each bucket under the specified partition, and the proportion of the data volume of each bucket in the total data volume.

example

  1. 1. View the data skew of the table
  2. ADMIN SHOW DATA SKEW FROM db1.test PARTITION(p1);

keyword

  1. ADMIN, SHOW, DATA, SKEW