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
}