List queryable tables

示例： http://192.168.88.132:7070/kylin/api/tables_and_columns?project=Test5 响应：列出该project下所有的表及其列信息 [ { "columns": [ { "table_CAT": "defaultCatalog", "table_SCHEM": "KYLIN_TEST", "table_NAME": "DEPT", "column_NAME": "DEPTNO", "data_TYPE": 4, "type_NAME": "INTEGER", "column_SIZE": -1, "buffer_LENGTH": -1, "decimal_DIGITS": 0, "num_PREC_RADIX": 10, "nullable": 1, "remarks": null, "column_DEF": null, "sql_DATA_TYPE": -1, "sql_DATETIME_SUB": -1, "char_OCTET_LENGTH": -1, "ordinal_POSITION": 1, "is_NULLABLE": "YES", "scope_CATLOG": null, "scope_SCHEMA": null, "scope_TABLE": null, "source_DATA_TYPE": -1, "is_AUTOINCREMENT": "" }, { "table_CAT": "defaultCatalog", "table_SCHEM": "KYLIN_TEST", "table_NAME": "DEPT", "column_NAME": "DNAME", "data_TYPE": 12, "type_NAME": "VARCHAR(256) CHARACTER SET \"UTF-16LE\" COLLATE \"UTF-16LE$en_US$primary\"", "column_SIZE": 256, "buffer_LENGTH": -1, "decimal_DIGITS": 0, "num_PREC_RADIX": 10, "nullable": 1, "remarks": null, "column_DEF": null, "sql_DATA_TYPE": -1, "sql_DATETIME_SUB": -1, "char_OCTET_LENGTH": 256, "ordinal_POSITION": 2, "is_NULLABLE": "YES", "scope_CATLOG": null, "scope_SCHEMA": null, "scope_TABLE": null, "source_DATA_TYPE": -1, "is_AUTOINCREMENT": "" } ], "ref_GENERATION": null, "type_SCHEM": null, "self_REFERENCING_COL_NAME": null, "table_TYPE": "TABLE", "type_CAT": null, "table_CAT": "defaultCatalog", "table_SCHEM": "KYLIN_TEST", "table_NAME": "DEPT", "type_NAME": null, "remarks": null }, { "columns": [ { "table_CAT": "defaultCatalog", "table_SCHEM": "KYLIN_TEST", "table_NAME": "EMP", "column_NAME": "JOB", "data_TYPE": 12, "type_NAME": "VARCHAR(256) CHARACTER SET \"UTF-16LE\" COLLATE \"UTF-16LE$en_US$primary\"", "column_SIZE": 256, "buffer_LENGTH": -1, "decimal_DIGITS": 0, "num_PREC_RADIX": 10, "nullable": 1, "remarks": null, "column_DEF": null, "sql_DATA_TYPE": -1, "sql_DATETIME_SUB": -1, "char_OCTET_LENGTH": 256, "ordinal_POSITION": 1, "is_NULLABLE": "YES", "scope_CATLOG": null, "scope_SCHEMA": null, "scope_TABLE": null, "source_DATA_TYPE": -1, "is_AUTOINCREMENT": "" }, { "table_CAT": "defaultCatalog", "table_SCHEM": "KYLIN_TEST", "table_NAME": "EMP", "column_NAME": "MGR", "data_TYPE": 4, "type_NAME": "INTEGER", "column_SIZE": -1, "buffer_LENGTH": -1, "decimal_DIGITS": 0, "num_PREC_RADIX": 10, "nullable": 1, "remarks": null, "column_DEF": null, "sql_DATA_TYPE": -1, "sql_DATETIME_SUB": -1, "char_OCTET_LENGTH": -1, "ordinal_POSITION": 2, "is_NULLABLE": "YES", "scope_CATLOG": null, "scope_SCHEMA": null, "scope_TABLE": null, "source_DATA_TYPE": -1, "is_AUTOINCREMENT": "" }, { "table_CAT": "defaultCatalog", "table_SCHEM": "KYLIN_TEST", "table_NAME": "EMP", "column_NAME": "DEPTNO", "data_TYPE": 4, "type_NAME": "INTEGER", "column_SIZE": -1, "buffer_LENGTH": -1, "decimal_DIGITS": 0, "num_PREC_RADIX": 10, "nullable": 1, "remarks": null, "column_DEF": null, "sql_DATA_TYPE": -1, "sql_DATETIME_SUB": -1, "char_OCTET_LENGTH": -1, "ordinal_POSITION": 3, "is_NULLABLE": "YES", "scope_CATLOG": null, "scope_SCHEMA": null, "scope_TABLE": null, "source_DATA_TYPE": -1, "is_AUTOINCREMENT": "" } ], "ref_GENERATION": null, "type_SCHEM": null, "self_REFERENCING_COL_NAME": null, "table_TYPE": "TABLE", "type_CAT": null, "table_CAT": "defaultCatalog", "table_SCHEM": "KYLIN_TEST", "table_NAME": "EMP", "type_NAME": null, "remarks": null } ]

List queryable tables

接口描述

请求头

参数名

类型

描述

必填

说明 / 示例

URL参数

参数名

类型

描述

必填