文档

ListTables - 获取元数据表列表

更新时间:

获取数据湖元数据表列表。

调试

您可以在OpenAPI Explorer中直接运行该接口,免去您计算签名的困扰。运行成功后,OpenAPI Explorer可以自动生成SDK代码示例。

授权信息

下表是API对应的授权信息,可以在RAM权限策略语句的Action元素中使用,用来给RAM用户或RAM角色授予调用此API的权限。具体说明如下:

  • 操作:是指具体的权限点。
  • 访问级别:是指每个操作的访问级别,取值为写入(Write)、读取(Read)或列出(List)。
  • 资源类型:是指操作中支持授权的资源类型。具体说明如下:
    • 对于必选的资源类型,用背景高亮的方式表示。
    • 对于不支持资源级授权的操作,用全部资源表示。
  • 条件关键字:是指云产品自身定义的条件关键字。
  • 关联操作:是指成功执行操作所需要的其他权限。操作者必须同时具备关联操作的权限,操作才能成功。
操作访问级别资源类型条件关键字关联操作
dlf:ListTablesList
  • 全部资源
    *

请求语法

GET /api/metastore/databases/tables/list

请求参数

名称类型必填描述示例值
CatalogIdstring

数据库分类命名空间,默认填写主账号 Uid

1344371
TableNamePatternstring

元数据表名称,正则表达式匹配

.*
NextPageTokenstring

翻页 token,从返回结果返回,无则传空字符串或''

''
PageSizeinteger

每页大小

10
DatabaseNamestring

元数据库名称

database_test
TableTypestring

元数据表的类型:例如 MANAGED_TABLE,EXTERNAL_TABLE,VIRTUAL_VIEW,INDEX_TABLE,MATERIALIZED_VIEW

MANAGED_TABLE

返回参数

名称类型描述示例值
object

返回结果体

Codestring

状态码描述

OK
Messagestring

提示相关错误信息

.
NextPageTokenstring

翻页 token

2cb472ec1bf84f8d92f9c4baa0d21c19aa
RequestIdstring

请求 ID

B7F4B621-E41E-4C84-B97F-42B5380A32BB
Successboolean

是否成功

true
Tablesarray

元数据表列表

Table

元数据表详细信息

Code 错误码说明
InternalError:其他类型错误,请参考 Message 提示

示例

正常返回示例

JSON格式

{
  "Code": "OK",
  "Message": ".",
  "NextPageToken": "2cb472ec1bf84f8d92f9c4baa0d21c19aa",
  "RequestId": "B7F4B621-E41E-4C84-B97F-42B5380A32BB",
  "Success": true,
  "Tables": [
    {
      "Cascade": false,
      "CreateTime": 1608707407,
      "CreatedBy": "zhangsan",
      "DatabaseName": "database_test",
      "LastAccessTime": 1608707407,
      "LastAnalyzedTime": 1608707407,
      "Owner": "zhangsan",
      "OwnerType": "USER",
      "Parameters": {
        "key": "key"
      },
      "PartitionKeys": [
        {
          "Comment": "comment_day",
          "Name": "day",
          "Parameters": {
            "key": "key"
          },
          "Type": "int"
        }
      ],
      "Privileges": {
        "GroupPrivileges": {
          "key": [
            {
              "CreateTime": 1606226844,
              "GrantOption": true,
              "Grantor": "Grantor",
              "GrantorType": "GrantorType",
              "Privilege": "Privilege"
            }
          ]
        },
        "RolePrivileges": {
          "key": [
            {
              "CreateTime": 1606226844,
              "GrantOption": true,
              "Grantor": "Grantor",
              "GrantorType": "GrantorType",
              "Privilege": "Privilege"
            }
          ]
        },
        "UserPrivileges": {
          "key": [
            {
              "CreateTime": 1606226844,
              "GrantOption": true,
              "Grantor": "Grantor",
              "GrantorType": "GrantorType",
              "Privilege": "Privilege"
            }
          ]
        }
      },
      "Retention": 30000,
      "RewriteEnabled": true,
      "Sd": {
        "BucketCols": [
          "2010"
        ],
        "Cols": [
          {
            "Comment": "comment_day",
            "Name": "day",
            "Parameters": {
              "key": "key"
            },
            "Type": "int"
          }
        ],
        "Compressed": false,
        "InputFormat": "org.apache.hadoop.hive.ql.io.avro.AvroContainerInputFormat",
        "Location": "file:///tmp/table",
        "NumBuckets": 10,
        "OutputFormat": "org.apache.hadoop.hive.ql.io.avro.AvroContainerOutputFormat",
        "Parameters": {
          "key": "key"
        },
        "SerDeInfo": {
          "Name": "name",
          "SerializationLib": "org.apache.hadoop.hive.serde2.OpenCSVSerde"
        },
        "SkewedInfo": {
          "SkewedColNames": [
            "col1"
          ],
          "SkewedColValueLocationMaps": {
            "key": "{“col1”:\"val1\"}"
          },
          "SkewedColValues": [
            [
              "\"123\""
            ]
          ]
        },
        "SortCols": [
          {
            "Col": "col1",
            "Order": 1
          }
        ],
        "StoredAsSubDirectories": false
      },
      "TableName": "table_name",
      "TableType": "MANAGED_TABLE",
      "Temporary": false,
      "UpdateTime": 1608707407,
      "ViewExpandedText": "''",
      "ViewOriginalText": "''",
      "TableId": "59c6c8fefeaa46d8b599c1f790c59a19",
      "TableVersion": {
        "Table": {
          "Cascade": false,
          "CreateTime": 1608707407,
          "CreatedBy": "zhangsan",
          "DatabaseName": "database_test",
          "LastAccessTime": 1608707407,
          "LastAnalyzedTime": 1608707407,
          "Owner": "zhangsan",
          "OwnerType": "USER",
          "PartitionKeys": [
            {
              "Comment": "comment_day",
              "Name": "day",
              "Type": "int"
            }
          ],
          "Privileges": {},
          "Retention": 30000,
          "RewriteEnabled": true,
          "Sd": {
            "BucketCols": [
              "2010"
            ],
            "Cols": [],
            "Compressed": false,
            "InputFormat": "org.apache.hadoop.hive.ql.io.avro.AvroContainerInputFormat",
            "Location": "file:///tmp/table",
            "NumBuckets": 10,
            "OutputFormat": "org.apache.hadoop.hive.ql.io.avro.AvroContainerOutputFormat",
            "Parameters": {
              "key": "key"
            },
            "SerDeInfo": {
              "Name": "name",
              "SerializationLib": "org.apache.hadoop.hive.serde2.OpenCSVSerde"
            },
            "SkewedInfo": {
              "SkewedColNames": [
                "col1"
              ],
              "SkewedColValueLocationMaps": {
                "key": "{“col1”:\"val1\"}"
              },
              "SkewedColValues": [
                [
                  "\"123\""
                ]
              ]
            },
            "SortCols": [
              {
                "Col": "col1",
                "Order": 1
              }
            ],
            "StoredAsSubDirectories": false
          },
          "TableName": "table_name",
          "TableType": "MANAGED_TABLE",
          "Temporary": false,
          "UpdateTime": 1608707407,
          "ViewExpandedText": "''",
          "ViewOriginalText": "''",
          "TableId": "59c6c8fefeaa46d8b599c1f790c59a19",
          "TableVersion": {
            "Table": {
              "Cascade": false,
              "CreateTime": 1608707407,
              "CreatedBy": "zhangsan",
              "DatabaseName": "database_test",
              "LastAccessTime": 1608707407,
              "LastAnalyzedTime": 1608707407,
              "Owner": "zhangsan",
              "OwnerType": "USER",
              "PartitionKeys": [],
              "Privileges": {},
              "Retention": 30000,
              "RewriteEnabled": true,
              "Sd": {
                "BucketCols": [
                  "2010"
                ],
                "Cols": [],
                "Compressed": false,
                "InputFormat": "org.apache.hadoop.hive.ql.io.avro.AvroContainerInputFormat",
                "Location": "file:///tmp/table",
                "NumBuckets": 10,
                "OutputFormat": "org.apache.hadoop.hive.ql.io.avro.AvroContainerOutputFormat",
                "Parameters": {
                  "key": "key"
                },
                "SerDeInfo": {
                  "Name": "name",
                  "SerializationLib": "org.apache.hadoop.hive.serde2.OpenCSVSerde"
                },
                "SkewedInfo": {
                  "SkewedColNames": [
                    "col1"
                  ],
                  "SkewedColValueLocationMaps": {
                    "key": "{“col1”:\"val1\"}"
                  },
                  "SkewedColValues": [
                    [
                      "\"123\""
                    ]
                  ]
                },
                "SortCols": [
                  {
                    "Col": "col1",
                    "Order": 1
                  }
                ],
                "StoredAsSubDirectories": false
              },
              "TableName": "table_name",
              "TableType": "MANAGED_TABLE",
              "Temporary": false,
              "UpdateTime": 1608707407,
              "ViewExpandedText": "''",
              "ViewOriginalText": "''",
              "TableId": "59c6c8fefeaa46d8b599c1f790c59a19",
              "TableVersion": {
                "VersionId": 5
              }
            },
            "VersionId": 5
          }
        },
        "VersionId": 5
      }
    }
  ]
}

JSON格式

{
  "Code": "OK",
  "Message": ".",
  "NextPageToken": "2cb472ec1bf84f8d92f9c4baa0d21c19aa",
  "RequestId": "B7F4B621-E41E-4C84-B97F-42B5380A32BB",
  "Success": true,
  "Tables": [
    {
      "Cascade": false,
      "CreateTime": 1608707407,
      "CreatedBy": "zhangsan",
      "DatabaseName": "database_test",
      "LastAccessTime": 1608707407,
      "LastAnalyzedTime": 1608707407,
      "Owner": "zhangsan",
      "OwnerType": "USER",
      "Parameters": {
        "key": "key"
      },
      "PartitionKeys": [
        {
          "Comment": "comment_day",
          "Name": "day",
          "Parameters": {
            "key": "key"
          },
          "Type": "int"
        }
      ],
      "Privileges": {
        "GroupPrivileges": {
          "key": [
            {
              "CreateTime": 1606226844,
              "GrantOption": true,
              "Grantor": "Grantor",
              "GrantorType": "GrantorType",
              "Privilege": "Privilege"
            }
          ]
        },
        "RolePrivileges": {
          "key": [
            {
              "CreateTime": 1606226844,
              "GrantOption": true,
              "Grantor": "Grantor",
              "GrantorType": "GrantorType",
              "Privilege": "Privilege"
            }
          ]
        },
        "UserPrivileges": {
          "key": [
            {
              "CreateTime": 1606226844,
              "GrantOption": true,
              "Grantor": "Grantor",
              "GrantorType": "GrantorType",
              "Privilege": "Privilege"
            }
          ]
        }
      },
      "Retention": 30000,
      "RewriteEnabled": true,
      "Sd": {
        "BucketCols": [
          "2010"
        ],
        "Cols": [
          {
            "Comment": "comment_day",
            "Name": "day",
            "Parameters": {
              "key": "key"
            },
            "Type": "int"
          }
        ],
        "Compressed": false,
        "InputFormat": "org.apache.hadoop.hive.ql.io.avro.AvroContainerInputFormat",
        "Location": "file:///tmp/table",
        "NumBuckets": 10,
        "OutputFormat": "org.apache.hadoop.hive.ql.io.avro.AvroContainerOutputFormat",
        "Parameters": {
          "key": "key"
        },
        "SerDeInfo": {
          "Name": "name",
          "SerializationLib": "org.apache.hadoop.hive.serde2.OpenCSVSerde"
        },
        "SkewedInfo": {
          "SkewedColNames": [
            "col1"
          ],
          "SkewedColValueLocationMaps": {
            "key": "{“col1”:\"val1\"}"
          },
          "SkewedColValues": [
            [
              "\"123\""
            ]
          ]
        },
        "SortCols": [
          {
            "Col": "col1",
            "Order": 1
          }
        ],
        "StoredAsSubDirectories": false
      },
      "TableName": "table_name",
      "TableType": "MANAGED_TABLE",
      "Temporary": false,
      "UpdateTime": 1608707407,
      "ViewExpandedText": "''",
      "ViewOriginalText": "''",
      "TableId": "59c6c8fefeaa46d8b599c1f790c59a19",
      "TableVersion": {
        "Table": {
          "Cascade": false,
          "CreateTime": 1608707407,
          "CreatedBy": "zhangsan",
          "DatabaseName": "database_test",
          "LastAccessTime": 1608707407,
          "LastAnalyzedTime": 1608707407,
          "Owner": "zhangsan",
          "OwnerType": "USER",
          "PartitionKeys": [
            {
              "Comment": "comment_day",
              "Name": "day",
              "Type": "int"
            }
          ],
          "Privileges": {},
          "Retention": 30000,
          "RewriteEnabled": true,
          "Sd": {
            "BucketCols": [
              "2010"
            ],
            "Cols": [],
            "Compressed": false,
            "InputFormat": "org.apache.hadoop.hive.ql.io.avro.AvroContainerInputFormat",
            "Location": "file:///tmp/table",
            "NumBuckets": 10,
            "OutputFormat": "org.apache.hadoop.hive.ql.io.avro.AvroContainerOutputFormat",
            "Parameters": {
              "key": "key"
            },
            "SerDeInfo": {
              "Name": "name",
              "SerializationLib": "org.apache.hadoop.hive.serde2.OpenCSVSerde"
            },
            "SkewedInfo": {
              "SkewedColNames": [
                "col1"
              ],
              "SkewedColValueLocationMaps": {
                "key": "{“col1”:\"val1\"}"
              },
              "SkewedColValues": [
                [
                  "\"123\""
                ]
              ]
            },
            "SortCols": [
              {
                "Col": "col1",
                "Order": 1
              }
            ],
            "StoredAsSubDirectories": false
          },
          "TableName": "table_name",
          "TableType": "MANAGED_TABLE",
          "Temporary": false,
          "UpdateTime": 1608707407,
          "ViewExpandedText": "''",
          "ViewOriginalText": "''",
          "TableId": "59c6c8fefeaa46d8b599c1f790c59a19",
          "TableVersion": {
            "Table": {
              "Cascade": false,
              "CreateTime": 1608707407,
              "CreatedBy": "zhangsan",
              "DatabaseName": "database_test",
              "LastAccessTime": 1608707407,
              "LastAnalyzedTime": 1608707407,
              "Owner": "zhangsan",
              "OwnerType": "USER",
              "PartitionKeys": [],
              "Privileges": {},
              "Retention": 30000,
              "RewriteEnabled": true,
              "Sd": {
                "BucketCols": [
                  "2010"
                ],
                "Cols": [],
                "Compressed": false,
                "InputFormat": "org.apache.hadoop.hive.ql.io.avro.AvroContainerInputFormat",
                "Location": "file:///tmp/table",
                "NumBuckets": 10,
                "OutputFormat": "org.apache.hadoop.hive.ql.io.avro.AvroContainerOutputFormat",
                "Parameters": {
                  "key": "key"
                },
                "SerDeInfo": {
                  "Name": "name",
                  "SerializationLib": "org.apache.hadoop.hive.serde2.OpenCSVSerde"
                },
                "SkewedInfo": {
                  "SkewedColNames": [
                    "col1"
                  ],
                  "SkewedColValueLocationMaps": {
                    "key": "{“col1”:\"val1\"}"
                  },
                  "SkewedColValues": [
                    [
                      "\"123\""
                    ]
                  ]
                },
                "SortCols": [
                  {
                    "Col": "col1",
                    "Order": 1
                  }
                ],
                "StoredAsSubDirectories": false
              },
              "TableName": "table_name",
              "TableType": "MANAGED_TABLE",
              "Temporary": false,
              "UpdateTime": 1608707407,
              "ViewExpandedText": "''",
              "ViewOriginalText": "''",
              "TableId": "59c6c8fefeaa46d8b599c1f790c59a19",
              "TableVersion": {
                "VersionId": 5
              }
            },
            "VersionId": 5
          }
        },
        "VersionId": 5
      }
    }
  ]
}

错误码

访问错误中心查看更多错误码。

  • 本页导读 (0)