数据湖探索 DLI-描述表信息（废弃）:响应示例

时间：2024-09-27 11:19:13

数据湖探索 DLI

响应示例

MANAGED类型表

{
  "is_success": true,
  "message": "",
  "column_count": 3,
  "columns": [
    {
      "column_name": "id",
      "description": "",
      "type": "int",
      "is_partition_column": false
    },
    {
      "column_name": "name",
      "description": "",
      "type": "string",
      "is_partition_column": false
    },
    {
      "column_name": "level",
      "description": "",
      "type": "string",
      "is_partition_column": true
    }
  ],
    "table_type":"MANAGED"
}

EXTERNAL类型表

{
    "is_success": true,
    "message": "",
    "column_count": 2,
    "columns": [
        {
            "type": "string",
            "description": "",
            "column_name": "col2",
            "is_partition_column": false
        },
        {
            "type": "string",
            "description": "",
            "column_name": "col1",
            "is_partition_column": true
        }
    ],
    "table_type": "EXTERNAL",
    "data_type": "parquet",
    "data_location": "obs://obs-wangtao/savepoint/savepoint-d95437-039668840fff/_metadata",
    "storage_properties": [
        {
            "key": "timestampformat",
            "value": "yyyy-MM-dd HH:mm:ss"
        },
        {
            "key": "quote",
            "value": "\""
        },
        {
            "key": "dateformat",
            "value": "yyyy-MM-dd"
        },
        {
            "key": "escape",
            "value": "\\"
        },
        {
            "key": "header",
            "value": "false"
        },
        {
            "key": "delimiter",
            "value": ","
        }
    ],
    "table_comment": "",
     "create_table_sql": "CREATE TABLE `default`.`wan_test` (`col2` STRING, `col1` STRING)\nUSING parquet\nOPTIONS (\n  `timestampformat` 'yyyy-MM-dd HH:mm:ss',\n  `quote` '\"',\n  `dateformat` 'yyyy-MM-dd',\n  `escape` '\\\\',\n  `header` 'false',\n  `delimiter` ','\n)\nPARTITIONED BY (col1)\nCOMMENT ''\nLOCATION 'obs://obs-wangtao/savepoint/savepoint-d95437-039668840fff/_metadata'\nTBLPROPERTIES (\n  'hive.serialization.extend.nesting.levels' = 'true'\n)\n"
   }

VIEW类型表

{
  "is_success": true,
  "message": "",
  "column_count": 3,
  "columns": [
    {
      "column_name": "id",
      "description": "",
      "type": "int",
      "is_partition_column": false
    },
    {
      "column_name": "name",
      "description": "",
      "type": "string",
      "is_partition_column": false
    },
    {
      "column_name": "level",
      "description": "",
      "type": "string",
      "is_partition_column": true
    }
  ],
  "table_type":"VIEW",
  "create_table_sql": "CREATE VIEW `default`.`view1`(id, name) AS\nselect * from a_gff.testtable\n"
}

上一篇：数据湖探索 DLI-创建表（废弃）:请求消息

下一篇：数据湖探索 DLI-描述表信息（废弃）:URI