SHOW DATA
Syntax:
Explain:
If the FROM clause is not specified, the amount of data and the number of copies subdivided into each table under the current db are displayed. The data volume is the total data volume of all replicas. The number of replicas is of all partitions of the table and all materialized views.
When counting the number of rows, the replica with the largest number of rows among multiple replicas shall prevail.
The row in the result set represents the summary row. The
Quota
row indicates the current quota of the database. The line indicates the remaining quota.If you want to check the size of each Partition, please refer to
help show partitions
.
Display the subdivision data volume, replica count and number of rows of the specified table below the specified DB.
SHOW DATA FROM example_db.test;
Can be combined and sorted according to the data volume, replica count,and number of rows,etc.
SHOW,DATA