Table Schema Action

Request

GET /api/<db>/<table>/_schema

Description

用于获取指定表的表结构信息。该接口目前用于 Spark/Flink Doris Connector 中， 获取 Doris 的表结构信息。

Path parameters

  • <db>

    指定数据库

  • <table>

    指定表

Query parameters

无

Request body

无

Response

  • http接口返回如下：
  1. {
  2.     "msg": "success",
  3.     "code": 0,
  4.     "data": {
  5.         "properties": [{
  6.             "type": "INT",
  7.             "name": "k1",
  8.             "comment": "",
  9.             "aggregation_type":""
  10.         }, {
  11.             "type": "INT",
  12.             "name": "k2",
  13.             "comment": "",
  14.             "aggregation_type":"MAX"
  15.         }],
  16.         "keysType":UNIQUE_KEYS,
  17.         "status": 200
  18.     },
  19.     "count": 0
  20. }
  • http v2接口返回如下：
  1. {
  2.     "msg": "success",
  3.     "code": 0,
  4.     "data": {
  5.         "properties": [{
  6.             "type": "INT",
  7.             "name": "k1",
  8.             "comment": ""
  9.         }, {
  10.             "type": "INT",
  11.             "name": "k2",
  12.             "comment": ""
  13.         }],
  14.         "keysType":UNIQUE_KEYS,
  15.         "status": 200
  16.     },
  17.     "count": 0
  18. }

注意：区别为http方式比http v2方式多返回aggregation_type字段，http v2开启是通过enable_http_server_v2进行设置，具体参数说明详见fe参数设置

Examples

  1. 通过http获取指定表的表结构信息。

    1. GET /api/db1/tbl1/_schema
    3. Response:
    4. {
    5.     "msg": "success",
    6.     "code": 0,
    7.     "data": {
    8.         "properties": [{
    9.             "type": "INT",
    10.             "name": "k1",
    11.             "comment": "",
    12.             "aggregation_type":""
    13.         }, {
    14.             "type": "INT",
    15.             "name": "k2",
    16.             "comment": "",
    17.             "aggregation_type":"MAX"
    18.         }],
    19.         "keysType":UNIQUE_KEYS,
    20.         "status": 200
    21.     },
    22.     "count": 0
    23. }

  2. 通过http v2获取指定表的表结构信息。

    1. GET /api/db1/tbl1/_schema
    3. Response:
    4. {
    5.     "msg": "success",
    6.     "code": 0,
    7.     "data": {
    8.         "properties": [{
    9.             "type": "INT",
    10.             "name": "k1",
    11.             "comment": ""
    12.         }, {
    13.             "type": "INT",
    14.             "name": "k2",
    15.             "comment": ""
    16.         }],
    17.         "keysType":UNIQUE_KEYS,
    18.         "status": 200
    19.     },
    20.     "count": 0
    21. }