SHOW DATA SKEW

description

This statement is used to view the data skew of a table or a partition.
grammar:
    SHOW DATA SKEW FROM [db_name.]tbl_name [PARTITION (p1)];
Description:
    1. Only one partition must be specified. For non-partitioned tables, the partition name is the same as the table name.
    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. View the data skew of the table
    SHOW DATA SKEW FROM db1.test PARTITION(p1);

keyword

SHOW, DATA, SKEW