Table Schema Action

Request

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

Description

Used to obtain the table structure information of the specified table. This interface is currently used in Spark-Doris-Connector. Spark obtains Doris table structure information.

Path parameters

• <db>

  Specify database

• <table>

  Specify table

Query parameters

None

Request body

None

Response

{
    "msg": "success",
    "code": 0,
    "data": {
        "properties": [{
            "type": "INT",
            "name": "k1",
            "comment": ""
        }, {
            "type": "INT",
            "name": "k2",
            "comment": ""
        }],
        "status": 200
    },
    "count": 0
}

Examples

1. Get the table structure information of the specified table.

   GET /api/db1/tbl1/_schema
   Response:
   {
       "msg": "success",
       "code": 0,
       "data": {
           "properties": [{
               "type": "INT",
               "name": "k1",
               "comment": ""
           }, {
               "type": "INT",
               "name": "k2",
               "comment": ""
           }],
           "status": 200
       },
       "count": 0
   }