Show Table Data Action
Show Table Data Action
Request
GET /api/show_table_data
Description
Used to get the data size of all tables in all databases under all internal catalog, or the data size of the specified database or table. Unit byte.
Path parameters
NULL
Query parameters
db
Optional. If specified, get the data size of the tables under the specified database.
table
Optional. If specified, get the data size of the specified table.
single_replica
Optional. If specified, get the data size of the single replica of the table.
Request body
NULL
Response
The data size of all tables in the specified database.
{
"msg":"success",
"code":0,
"data":{
"tpch":{
"partsupp":9024548244,
"revenue0":0,
"customer":1906421482
}
},
"count":0
}The data size of the specified table of the specified db.
{
"msg":"success",
"code":0,
"data":{
"tpch":{
"partsupp":9024548244
}
},
"count":0
}The data size of the single replica of the specified table of the specified db.
{
"msg":"success",
"code":0,
"data":{
"tpch":{
"partsupp":3008182748
}
},
"count":0
}
Examples
The data size of all tables in the specified database.
GET /api/show_table_data?db=tpch
Response:
{
"msg":"success",
"code":0,
"data":{
"tpch":{
"partsupp":9024548244,
"revenue0":0,
"customer":1906421482
}
},
"count":0
}The data size of the specified table of the specified db.
GET /api/show_table_data?db=tpch&table=partsupp
Response:
{
"msg":"success",
"code":0,
"data":{
"tpch":{
"partsupp":9024548244
}
},
"count":0
}The data size of the single replica of the specified table of the specified db.
GET /api/show_table_data?db=tpch&table=partsupp&single_replica=true
Response:
{
"msg":"success",
"code":0,
"data":{
"tpch":{
"partsupp":3008182748
}
},
"count":0
}