SHOW-DATA-SKEW
Name
SHOW DATA SKEW
Description
This statement is used to view the data skew of a table or a partition.
Syntax:
SHOW DATA SKEW FROM [db_name.]tbl_name [PARTITION (p1)];
Note:
- You have to specify (only) one partition. For non-partitioned tables, the partition name is the same as the table name.
- The result will show the number of rows, data volume, and data proportion of each bucket under the specified partition
Example
-
View the data skew of the table
SHOW DATA SKEW FROM db1.test PARTITION(p1);
Keywords
SHOW, DATA, SKEW