表模型管理表详情

返回响应

🟢200响应参数

application/json

Body

code

integer

示例：200

必需

result

object

数据字典

必需

string

必需

表ID，示例：AX1U_gm6W_8UkQkr_Aj6

layername

string

必需

表所在层名称，示例：Test11.23

layerid

string

必需

表所在层ID，示例：zSlO0xm4b97MsY0CMRJ0

engineid

string

必需

表所在引擎ID，示例：AXaNgy5Y_BIjImhbmurV

dbname

string

必需

表所在db名称，示例：abc123

sourcedb

string

必需

表所在db，示例：abc123

sourceid

string

必需

表所在db ID，示例：AX1MKyG0W_8UkQkr-6Bb

schema

string

必需

表所在schema，示例：default

dbtype

string

必需

表所在数据库类型，示例：hive

fileformat

string

必需

表格式，示例：Orcfile

tbname

string

必需

表名称，示例：user

describe

string

表描述，示例：XX

必需

tbtype

string

必需

表类型，示例：未分类

tborview

integer

示例：0

必需

isrt

boolean

示例：false

必需

location

string

必需

示例：hdfs://dn55:8020/warehouse/tablespace/managed/hive/abc123.db/user

catalogid

string

必需

编目ID，示例：AX1MJENRW_8UkQkr-5-j

catalist

array [object {6}]

编目信息

必需

taglist

array [object]

标签信息

必需

fieldinfo

array [object {9}]

表字段信息

必需

projectid

string

必需

所在项目ID，示例：public_test

userid

string

必需

用户ID，示例：AXOjA6LYT5Uzv8YLZCgM

username

string

必需

用户名称，示例：dev

created

string

必需

创建时间，示例：2021-11-25 10:47:53

modified

string

必需

修改时间，示例：2021-11-25 11:00:18

updated

string

必需

更新时间，示例：2021-11-25 11:00:18

synctime

string

必需

同步时间，示例：2022-07-18 14:00:19

distributionmode

string

必需

表分布方式，示例：HASH

distributionbond

array [object]

必需

分布键，示例：["id"]

singlecollection

boolean

示例：false

必需

extracttype

string

示例：mysql

必需

storagespace

string

示例：0 BYTE

必需

versionnum

integer

示例：0

必需

isinput

boolean

示例：false

必需

partitionfield

array [object]

数据列表

必需

realtimetb

object

数据字典

必需

partitioninfo

object

数据字典

必需

sqltxttemp

string

示例：

必需

sqltxt

string

示例：

必需

sqltxttempnew

string

必需

示例：CREATE TABLE if not exists abc123.user_temp (id bigint, nickname string, tellphone string, registertime timestamp, sex bigint, registeraddress string) stored as orc

sqltxtnew

string

必需

示例：CREATE TABLE if not exists abc123.user (id bigint COMMENT '', nickname string COMMENT '昵称', tellphone string COMMENT '手机号', registertime timestamp COMMENT '注册时间', sex bigint COMMENT '性别', registeraddress string COMMENT '注册地址') stored as orc; alter table abc123.user set tblproperties('comment' = '')

checkresult_test

object

示例：null

必需

table_rank

integer

示例：0

必需

orientation

string

必需

存储方式，列存为cloumn，行存为空

compresstype

string

压缩格式

必需

compresslevel

integer

压缩等级

必需

示例

{
  "code": 0,
  "result": {
    "id": "string",
    "layername": "string",
    "layerid": "string",
    "engineid": "string",
    "dbname": "string",
    "sourcedb": "string",
    "sourceid": "string",
    "schema": "string",
    "dbtype": "string",
    "fileformat": "string",
    "tbname": "string",
    "describe": "string",
    "tbtype": "string",
    "tborview": 0,
    "isrt": true,
    "location": "string",
    "catalogid": "string",
    "catalist": [
      {
        "id": "string",
        "name": "string",
        "parentid": "string",
        "parentname": "string",
        "isfourth": true,
        "islower": true
      }
    ],
    "taglist": [
      {}
    ],
    "fieldinfo": [
      {
        "number": 0,
        "name": "string",
        "annotation": "string",
        "fieldtype": "string",
        "isprim": true,
        "isunique": true,
        "ispartition": true,
        "ranknum": 0,
        "rankname": "string"
      }
    ],
    "projectid": "string",
    "userid": "string",
    "username": "string",
    "created": "string",
    "modified": "string",
    "updated": "string",
    "synctime": "string",
    "distributionmode": "string",
    "distributionbond": [
      {}
    ],
    "singlecollection": true,
    "extracttype": "string",
    "storagespace": "string",
    "versionnum": 0,
    "isinput": true,
    "partitionfield": [
      {}
    ],
    "realtimetb": {
      "sourcedbtablename": "string",
      "sourcedbtableid": "string",
      "sourcedbtype": "string"
    },
    "partitioninfo": {
      "exist": true,
      "way": "string",
      "count": 0,
      "fields": [
        {}
      ],
      "detail": [
        {}
      ]
    },
    "sqltxttemp": "string",
    "sqltxt": "string",
    "sqltxttempnew": "string",
    "sqltxtnew": "string",
    "checkresult_test": {},
    "table_rank": 0,
    "orientation": "string",
    "compresstype": "string",
    "compresslevel": 0
  }
}

表模型管理表详情

请求参数

返回响应