All Products
Search
Document Center

:GetTableProfile

Last Updated:May 20, 2024

Debugging

OpenAPI Explorer automatically calculates the signature value. For your convenience, we recommend that you call this operation in OpenAPI Explorer.

Authorization information

There is currently no authorization information disclosed in the API.

Request syntax

GET /webapi/metastorehouse/catalog/database/tableprofile

Request parameters

ParameterTypeRequiredDescriptionExample
CatalogIdstringNo

CatalogId

DatabaseNamestringYes

DatabaseName

exp_table
TableNamestringYes

TableName

admin_user

Response parameters

ParameterTypeDescriptionExample
object

Response

Codestring

Code

OK
Messagestring

Message

None

Examples

Sample success responses

JSONformat

{
  "Code": "OK",
  "Message": "None",
  "RequestId": "C742A04F-F304-5440-9ED8-AD58C36D1915",
  "Success": true,
  "TableProfile": {
    "PartitionCnt": 3,
    "FileCnt": 5,
    "ObjectCnt": 5,
    "FileSize": 31,
    "ObjectSize": 31,
    "RecordCnt": 2,
    "IsPartitioned": true,
    "LastModifyTime": "2023-08-16 18:02:25",
    "LastAccessTime": "2023-08-22 12:14:42",
    "DatabaseName": "test_db",
    "TableName": "test_tbl",
    "CreateTime": "2023-08-14 10:44:13",
    "Location": "oss://mybucket.cn-hangzhou.oss-dls.aliyuncs.com/test_db/test_tbl/",
    "AccessNum": 0,
    "AccessNumWeekly": 0,
    "AccessNumMonthly": 0,
    "LastAccessNumTime": "",
    "LatestDate": "2023-08-30 19:16:10",
    "LatestAccessNumDate": "",
    "LastDdlTime": "2023-08-16 18:02:24",
    "ObjectAccessNum": 0,
    "ObjectAccessNumWeekly": 18,
    "ObjectAccessNumMonthly": 18,
    "DataSourceType": "OSS_HDFS"
  }
}

Error codes

For a list of error codes, visit the Service error codes.

Change history

Change timeSummary of changesOperation
2023-08-31API Description Updatesee changesets
Change itemChange content
API DescriptionAPI Description Update.