'1.0',
'info' => [
'style' => 'RPC',
'product' => 'openanalytics-open',
'version' => '2020-09-28',
],
'directories' => [
[
'id' => 66508,
'title' => '元数据',
'type' => 'directory',
'children' => [
[
'id' => 66512,
'title' => '数据库管理',
'type' => 'directory',
'children' => [
'CreateDatabase',
'GetAllDatabases',
],
],
[
'id' => 66518,
'title' => '分区管理',
'type' => 'directory',
'children' => [
'AddPartitions',
],
],
[
'id' => 66523,
'title' => '表管理',
'type' => 'directory',
'children' => [
'GetTable',
'GetAllTables',
'DropTable',
],
],
],
],
],
'components' => [
'schemas' => [
'DatabaseModel' => [
'title' => '数据库结构',
'description' => ' 数据库数据结构',
'type' => 'object',
'properties' => [
'DBId' => [
'title' => '数据库 ID',
'type' => 'string',
],
'TenantId' => [
'title' => '数据库所属的阿里云UID ',
'type' => 'string',
],
'Name' => [
'title' => '数据库名称',
'type' => 'string',
],
'LocationURI ' => [
'title' => '数据库地址',
'type' => 'string',
],
'Description' => [
'title' => '数据库描述 ',
'type' => 'string',
],
'Parameters' => [
'title' => '数据库参数 ',
'type' => 'object',
'additionalProperties' => [
'type' => 'string',
],
],
'OwnerName' => [
'title' => '数据库所属 DLA userName ',
'type' => 'string',
],
'OwnerType' => [
'title' => '数据库所属用户类型',
'type' => 'string',
],
'CatalogType' => [
'title' => '数据库类型',
'type' => 'string',
],
],
],
'FieldSchemaModel' => [
'title' => '列 数据结构',
'description' => '列 数据结构',
'type' => 'object',
'properties' => [
'Name' => [
'title' => '列名',
'type' => 'string',
],
'Type' => [
'title' => '列的数据类型',
'type' => 'string',
],
'Comment' => [
'title' => '列的描述信息',
'type' => 'string',
],
'SchemaName' => [
'title' => '对应的数据库名',
'type' => 'string',
],
'TableName' => [
'title' => '对应的表名',
'type' => 'string',
],
'MappedName' => [
'title' => '映射名称',
'type' => 'string',
],
'DataType' => [
'title' => '数据的类型',
'type' => 'string',
],
'IsPrimaryKey' => [
'title' => '是否为主键',
'type' => 'boolean',
],
'CreateTime' => [
'title' => '创建时间',
'type' => 'integer',
'format' => 'int64',
],
'UpdateTime' => [
'title' => '更新时间',
'type' => 'integer',
'format' => 'int64',
],
' PkPosition' => [
'title' => '主键位置',
'type' => 'integer',
'format' => 'int32',
],
'IsPartitionKey' => [
'title' => '是否为分区字段',
'type' => 'boolean',
],
],
],
],
],
'apis' => [
'CreateDatabase' => [
'summary' => '创建数据库。',
'methods' => [
'post',
],
'schemes' => [
'http',
'https',
],
'security' => [
[
'AK' => [],
],
],
'operationType' => 'write',
'deprecated' => false,
'systemTags' => [
'operationType' => 'create',
'riskType' => 'none',
'chargeType' => 'free',
],
'parameters' => [
[
'name' => 'Name',
'in' => 'query',
'schema' => [
'title' => '创建数据库的名字',
'description' => '数据库的名称。',
'type' => 'string',
'required' => true,
'example' => 'db001',
],
],
[
'name' => 'Description',
'in' => 'query',
'schema' => [
'title' => '数据库描述',
'description' => '数据库的描述。',
'type' => 'string',
'required' => true,
'example' => 'this is db description',
],
],
[
'name' => 'LocationUri',
'in' => 'query',
'schema' => [
'title' => '数据库的 location',
'description' => '数据库的OSS地址。',
'type' => 'string',
'required' => true,
'example' => 'oss://data/xxx',
],
],
[
'name' => 'Parameters',
'in' => 'query',
'style' => 'json',
'schema' => [
'title' => '数据库属性',
'description' => '数据库的属性。',
'type' => 'object',
'required' => false,
'additionalProperties' => [
'type' => 'string',
'description' => '数据库的属性。',
'example' => 'key001=value001',
],
],
],
],
'responses' => [
200 => [
'schema' => [
'title' => '返回值主题',
'description' => '返回对象。',
'type' => 'object',
'properties' => [
'Code' => [
'title' => '如果后端处理出现错误,则表示错误的类型',
'description' => '标记错误的Code。',
'type' => 'string',
'example' => 'ALREADY_EXISTS',
],
'Data' => [
'title' => '成功创建库的库ID',
'description' => '表示创建成功时数据库的id。',
'type' => 'integer',
'format' => 'int64',
'example' => '6666',
],
'Message' => [
'title' => '如果后端处理出现错误,则表示错误的信息',
'description' => '如果有异常,返回异常的信息。',
'type' => 'string',
'example' => 'Database db001 already exists',
],
'RequestId' => [
'title' => '请求的 ID',
'description' => '本次请求的RequestId。',
'type' => 'string',
'example' => '9BEAC206-0795-4DE3-B1FD-964BEF432B23',
],
'Success' => [
'title' => '标识本次请求是否成功',
'description' => '标记本次请求是否成功。',
'type' => 'boolean',
'example' => 'false',
],
],
],
],
],
'responseDemo' => '[{"type":"json","example":"{\\n \\"Code\\": \\"ALREADY_EXISTS\\",\\n \\"Data\\": 6666,\\n \\"Message\\": \\"Database db001 already exists\\",\\n \\"RequestId\\": \\"9BEAC206-0795-4DE3-B1FD-964BEF432B23\\",\\n \\"Success\\": false\\n}","errorExample":""},{"type":"xml","example":"Database db001 already exists\\n9BEAC206-0795-4DE3-B1FD-964BEF432B23\\n6666\\nALREADY_EXISTS\\nfalse","errorExample":""}]',
'title' => '创建一个新的数据库实例',
],
'GetAllDatabases' => [
'summary' => '调用GetAllDatabases获取当前用户所有有权限的数据库。',
'methods' => [
'post',
],
'schemes' => [
'http',
'https',
],
'security' => [
[
'AK' => [],
],
],
'operationType' => 'read',
'deprecated' => false,
'systemTags' => [
'operationType' => 'get',
'riskType' => 'none',
'chargeType' => 'free',
],
'parameters' => [],
'responses' => [
200 => [
'schema' => [
'title' => '返回对象',
'description' => '返回对象。',
'type' => 'object',
'properties' => [
'Code' => [
'title' => '如果后端处理出现错误,则表示错误的类型',
'description' => '如果有错误,则返回错误的类型。此API不会有异常。',
'type' => 'string',
'example' => 'ok',
],
'Data' => [
'title' => '返回的数据库列表',
'description' => '有权限的数据库名称列表。',
'type' => 'array',
'items' => [
'description' => '有权限的数据库名称列表。',
'type' => 'string',
'example' => 'db001',
],
],
'Message' => [
'title' => '如果后端处理出现错误,则表示错误的信息',
'description' => '如果有异常,则返回异常详细信息。',
'type' => 'string',
'example' => 'ok',
],
'RequestId' => [
'title' => '请求的 ID',
'description' => '本次请求的RequestId。',
'type' => 'string',
'example' => '9BEAC206-0795-4DE3-B1FD-964BEF432B23',
],
'Success' => [
'title' => '标识本次请求是否成功',
'description' => '本次请求是否成功。',
'type' => 'boolean',
'example' => 'true',
],
],
],
],
],
'errorCodes' => [],
'responseDemo' => '[{"type":"json","example":"{\\n \\"Code\\": \\"ok\\",\\n \\"Data\\": [\\n \\"db001\\"\\n ],\\n \\"Message\\": \\"ok\\",\\n \\"RequestId\\": \\"9BEAC206-0795-4DE3-B1FD-964BEF432B23\\",\\n \\"Success\\": true\\n}","errorExample":""},{"type":"xml","example":"\\n ok\\n db001\\n ok\\n 9BEAC206-0795-4DE3-B1FD-964BEF432B23\\n true\\n","errorExample":""}]',
'title' => '获取当前用户所有有权限的数据库名称',
],
'AddPartitions' => [
'summary' => '向 DLA 元数据系统里面添加分区信息。',
'methods' => [
'post',
],
'schemes' => [
'http',
'https',
],
'security' => [
[
'AK' => [],
],
],
'operationType' => 'write',
'deprecated' => false,
'systemTags' => [
'operationType' => 'create',
'riskType' => 'none',
'chargeType' => 'free',
],
'parameters' => [
[
'name' => 'Partition',
'in' => 'query',
'style' => 'json',
'schema' => [
'title' => '添加的分区',
'description' => '只发布国内站'."\n"
.'只发布虚商站'."\n",
'type' => 'array',
'items' => [
'description' => '分区数组的内容。',
'type' => 'object',
'properties' => [
'DbName' => [
'title' => '数据库名称',
'description' => '数据库名称。',
'type' => 'string',
'required' => true,
'example' => 'db001',
],
'Parameters' => [
'title' => '分区属性',
'description' => '分区参数。',
'type' => 'object',
'required' => false,
'additionalProperties' => [
'type' => 'string',
'description' => '分区参数。',
'example' => 'key001=value002',
],
],
'StorageDescriptor' => [
'title' => '分区的 StorageDescriptor ',
'description' => '分区的SD信息。',
'type' => 'object',
'properties' => [
'Col' => [
'title' => '表的列信息',
'description' => '表的列信息。',
'type' => 'array',
'items' => [
'description' => '表的列信息。',
'type' => 'object',
'properties' => [
'Comment' => [
'title' => '列注释',
'description' => '列注释。',
'type' => 'string',
'required' => false,
'example' => 'this is comment',
],
'Name' => [
'title' => '列名',
'description' => '列名。',
'type' => 'string',
'required' => false,
'example' => 'col1',
],
'Type' => [
'title' => '列类型',
'description' => '列类型。',
'type' => 'string',
'required' => false,
'example' => 'string',
],
],
'required' => false,
],
'required' => true,
],
'InputFormat' => [
'title' => '表的 inputFormat',
'description' => '表的InputFormat。',
'type' => 'string',
'required' => true,
'example' => 'org.apache.hadoop.hive.ql.io.parquet.MapredParquetInputFormat',
],
'Location' => [
'title' => '表路径',
'description' => '表的路径。',
'type' => 'string',
'required' => false,
'example' => 'oss://data/xxxx',
],
'OutputFormat' => [
'title' => '表的 outputFormat',
'description' => '表的OutputFormat。',
'type' => 'string',
'required' => true,
'example' => 'org.apache.hadoop.hive.ql.io.parquet.MapredParquetOutputFormat',
],
'Parameters' => [
'title' => 'StorageDescriptor 的属性',
'description' => 'SD的属性。',
'type' => 'object',
'required' => false,
'additionalProperties' => [
'type' => 'string',
'example' => 'key001=value002',
'description' => 'SD的属性。',
],
],
'SerDeInfo' => [
'title' => '表的 serDeInfo',
'description' => '表的SerDe信息。',
'type' => 'object',
'properties' => [
'Name' => [
'title' => 'SerDe 的名字',
'description' => 'SerDe的名称。',
'type' => 'string',
'required' => false,
'example' => 'serDeName',
],
'Parameters' => [
'title' => 'SerDe 的',
'description' => 'SerDe的属性。',
'type' => 'object',
'required' => false,
'additionalProperties' => [
'type' => 'string',
'example' => 'key001=value002',
'description' => 'SerDe的属性。',
],
],
'SerializationLib' => [
'title' => 'SerDe 的 serializationLib 信息',
'description' => '处理serDe的类库。',
'type' => 'string',
'required' => true,
'example' => 'org.apache.hadoop.hive.ql.io.parquet.serde.ParquetHiveSerDe',
],
],
'required' => true,
],
],
'required' => true,
],
'TableName' => [
'title' => '表名',
'description' => '表的名称。',
'type' => 'string',
'required' => true,
'example' => 'tbl001',
],
'Values' => [
'title' => '需要添加的分区',
'description' => '分区的值。',
'type' => 'array',
'items' => [
'description' => '分区的值。',
'type' => 'string',
'required' => true,
'example' => 'p001',
],
'required' => true,
],
],
'required' => false,
],
'required' => true,
],
],
],
'responses' => [
200 => [
'schema' => [
'title' => '返回对象',
'description' => '返回对象。',
'type' => 'object',
'properties' => [
'Code' => [
'title' => '如果后端处理出现错误,则表示错误的类型',
'description' => '标记成功错误的CODE。',
'type' => 'string',
'example' => 'INVALID_OPERATION',
],
'Data' => [
'title' => '成功添加的分区个数',
'description' => '成功添加的分区数。',
'type' => 'integer',
'format' => 'int64',
'example' => '2',
],
'Message' => [
'title' => '如果后端处理出现错误,则表示错误的信息',
'description' => '如果有错误,则返回错误的信息。',
'type' => 'string',
'example' => 'Too many partitions, exceed max partition number',
],
'RequestId' => [
'title' => '请求的 ID',
'description' => '请求RequestId。',
'type' => 'string',
'example' => '9BEAC206-0795-4DE3-B1FD-964BEF432B23',
],
'Success' => [
'title' => '标识本次请求是否成功',
'description' => '修改数据库是否成功。',
'type' => 'boolean',
'example' => 'true',
],
],
],
],
],
'errorCodes' => [
430 => [
[
'errorCode' => 'ServerError.Inner',
'errorMessage' => 'An internal error occurred.',
],
],
],
'responseDemo' => '[{"type":"json","example":"{\\n \\"Code\\": \\"INVALID_OPERATION\\",\\n \\"Data\\": 2,\\n \\"Message\\": \\"Too many partitions, exceed max partition number\\",\\n \\"RequestId\\": \\"9BEAC206-0795-4DE3-B1FD-964BEF432B23\\",\\n \\"Success\\": true\\n}","errorExample":""},{"type":"xml","example":"Too many partitions, exceed max partition number\\n9BEAC206-0795-4DE3-B1FD-964BEF432B23\\n2\\nINVALID_OPERATION\\ntrue","errorExample":""}]',
'title' => '向元数据系统添加分区信息',
],
'GetTable' => [
'summary' => '调用GetTable获取给定表的详细信息。',
'methods' => [
'post',
],
'schemes' => [
'http',
'https',
],
'security' => [
[
'AK' => [],
],
],
'operationType' => 'readAndWrite',
'deprecated' => false,
'systemTags' => [
'operationType' => 'get',
'riskType' => 'none',
'chargeType' => 'free',
],
'parameters' => [
[
'name' => 'DbName',
'in' => 'query',
'schema' => [
'title' => '数据库名称',
'description' => '数据库名称。',
'type' => 'string',
'required' => true,
'example' => 'db001',
],
],
[
'name' => 'TableName',
'in' => 'query',
'schema' => [
'title' => '表名称',
'description' => '表名称。',
'type' => 'string',
'required' => true,
'example' => 'tbl001',
],
],
],
'responses' => [
200 => [
'schema' => [
'title' => '返回对象',
'description' => '返回对象。',
'type' => 'object',
'properties' => [
'Code' => [
'title' => '如果后端处理出现错误,则表示错误的类型',
'description' => '如果失败,则返回失败的代码。'."\n"
."\n",
'type' => 'string',
'example' => 'NO_SUCH_OBJECT',
],
'Message' => [
'title' => '如果后端处理出现错误,则表示错误的信息',
'description' => '如果请求失败,则返回失败的详细信息。'."\n"
."\n",
'type' => 'string',
'example' => 'No such table: db001.tbl001',
],
'RequestId' => [
'title' => '请求的 ID',
'description' => '本次请求的RequestId。'."\n"
."\n",
'type' => 'string',
'example' => '9BEAC206-0795-4DE3-B1FD-964BEF432B23',
],
'Success' => [
'title' => '标识本次请求是否成功',
'description' => '本次请求是否成功。'."\n",
'type' => 'boolean',
'example' => 'false',
],
'Table' => [
'title' => '获取的表信息',
'description' => '获取的表信息。',
'type' => 'object',
'properties' => [
'CreateTime' => [
'title' => '表的创建时间',
'description' => '表的创建时间。',
'type' => 'integer',
'format' => 'int64',
'example' => '20190813',
],
'DbName' => [
'title' => '数据库名称',
'description' => '数据库名称。',
'type' => 'string',
'example' => 'db001',
],
'LastAccessTime' => [
'title' => '最后一次访问时间',
'description' => '表的最后访问时间。',
'type' => 'integer',
'format' => 'int64',
'example' => '20190814',
],
'Owner' => [
'title' => '表的所属用户',
'description' => '创建表的DLA username。',
'type' => 'string',
'example' => 'user001',
],
'Parameters' => [
'title' => '表属性',
'description' => '表的属性。',
'type' => 'object',
'additionalProperties' => [
'type' => 'string',
'description' => '表的属性。',
'example' => 'key001=value001',
],
],
'PartitionKeys' => [
'title' => '分区信息',
'description' => '表的分区信息。',
'type' => 'array',
'items' => [
'description' => '表的分区信息。',
'type' => 'object',
'properties' => [
'Comment' => [
'title' => '分区注释',
'description' => '分区注释。',
'type' => 'string',
'example' => 'this is partition comment',
],
'Name' => [
'title' => '分区名称',
'description' => '分区字段名称。',
'type' => 'string',
'example' => 'part001',
],
'Type' => [
'title' => '分区类型',
'description' => '分区列类型。',
'type' => 'string',
'example' => 'int',
],
],
],
],
'StorageDescriptor' => [
'title' => '表的 sd 信息',
'description' => '表的SD信息。',
'type' => 'object',
'properties' => [
'Cols' => [
'title' => '表的列信息',
'description' => '表的列信息。',
'type' => 'array',
'items' => [
'description' => '表的列信息。',
'type' => 'object',
'properties' => [
'Comment' => [
'title' => '列注释',
'description' => '列注释。',
'type' => 'string',
'example' => 'this is column comment',
],
'Name' => [
'title' => '列名称',
'description' => '列名称。',
'type' => 'string',
'example' => 'col1',
],
'Type' => [
'title' => '列类型',
'description' => '列类型。',
'type' => 'string',
'example' => 'string',
],
],
],
],
'InputFormat' => [
'title' => '表的 inputFormat',
'description' => '表的InputFormat。'."\n"
."\n",
'type' => 'string',
'example' => 'org.apache.hadoop.hive.ql.io.parquet.MapredParquetInputFormat',
],
'Location' => [
'title' => '表路径',
'description' => '表的路径。',
'type' => 'string',
'example' => 'oss://data/xxxx',
],
'OutputFormat' => [
'title' => '表的 outputFormat',
'description' => '表的OutputFormat。'."\n"
."\n",
'type' => 'string',
'example' => 'org.apache.hadoop.hive.ql.io.parquet.MapredParquetOutputFormat',
],
'Parameters' => [
'title' => 'SD 的属性',
'description' => 'SD属性。',
'type' => 'object',
],
'SerDeInfo' => [
'title' => '表的 SerDe 信息',
'description' => 'SerDe信息。',
'type' => 'object',
'properties' => [
'Name' => [
'title' => 'SerDe 的名称',
'description' => 'SerDe名字。',
'type' => 'string',
'example' => 'SerDeName',
],
'Parameters' => [
'title' => 'SerDe 的属性',
'description' => 'SerDe属性。',
'type' => 'object',
'additionalProperties' => [
'type' => 'string',
'description' => 'SerDe属性。',
'example' => 'key001=value001',
],
],
'SerializationLib' => [
'title' => 'SerDe 的 serializationLib',
'description' => '处理serDe的类库。'."\n"
."\n",
'type' => 'string',
'example' => 'org.apache.hadoop.hive.ql.io.parquet.serde.ParquetHiveSerDe',
],
],
],
],
],
'TableName' => [
'title' => '表的名称',
'description' => '表名称。',
'type' => 'string',
'example' => 'tbl001',
],
'TableType' => [
'title' => '表的类型',
'description' => '表类型,支持VIEW、MANAGED_TABLE、EXTERNAL_TABLE、VIRTUAL_VIEW。',
'type' => 'string',
'example' => 'VIEW',
],
'ViewExpandedText' => [
'title' => '如果表是视图,则存储扩展视图SQL',
'description' => '如果表是视图,则代表视图的扩展SQL。',
'type' => 'string',
'example' => 'select count(*) from tbl002',
],
'ViewOriginalText' => [
'title' => '如果表是视图,则存储原生视图SQL',
'description' => '如果表是视图,则代表视图的原始SQL。',
'type' => 'string',
'example' => 'select count(*) from tbl002',
],
],
],
],
],
],
],
'errorCodes' => [],
'responseDemo' => '[{"errorExample":"","example":"{\\n \\"Code\\": \\"NO_SUCH_OBJECT\\",\\n \\"Message\\": \\"No such table: db001.tbl001\\",\\n \\"RequestId\\": \\"9BEAC206-0795-4DE3-B1FD-964BEF432B23\\",\\n \\"Success\\": false,\\n \\"Table\\": {\\n \\"CreateTime\\": 20190813,\\n \\"DbName\\": \\"db001\\",\\n \\"LastAccessTime\\": 20190814,\\n \\"Owner\\": \\"user001\\",\\n \\"Parameters\\": {\\n \\"key\\": \\"key001=value001\\"\\n },\\n \\"PartitionKeys\\": [\\n {\\n \\"Comment\\": \\"this is partition comment\\",\\n \\"Name\\": \\"part001\\",\\n \\"Type\\": \\"int\\"\\n }\\n ],\\n \\"StorageDescriptor\\": {\\n \\"Cols\\": [\\n {\\n \\"Comment\\": \\"this is column comment\\",\\n \\"Name\\": \\"col1\\",\\n \\"Type\\": \\"string\\"\\n }\\n ],\\n \\"InputFormat\\": \\"org.apache.hadoop.hive.ql.io.parquet.MapredParquetInputFormat\\",\\n \\"Location\\": \\"oss://data/xxxx\\",\\n \\"OutputFormat\\": \\"org.apache.hadoop.hive.ql.io.parquet.MapredParquetOutputFormat\\",\\n \\"Parameters\\": {\\n \\"test\\": \\"test\\",\\n \\"test2\\": 1\\n },\\n \\"SerDeInfo\\": {\\n \\"Name\\": \\"SerDeName\\",\\n \\"Parameters\\": {\\n \\"key\\": \\"key001=value001\\"\\n },\\n \\"SerializationLib\\": \\"org.apache.hadoop.hive.ql.io.parquet.serde.ParquetHiveSerDe\\"\\n }\\n },\\n \\"TableName\\": \\"tbl001\\",\\n \\"TableType\\": \\"VIEW\\",\\n \\"ViewExpandedText\\": \\"select count(*) from tbl002\\",\\n \\"ViewOriginalText\\": \\"select count(*) from tbl002\\"\\n }\\n}","type":"json"}]',
'title' => '获取给定表的详细信息',
],
'GetAllTables' => [
'summary' => '调用GetAllTables获取数据库下面的所有有权限的表。',
'methods' => [
'post',
],
'schemes' => [
'http',
'https',
],
'security' => [
[
'AK' => [],
],
],
'operationType' => 'readAndWrite',
'deprecated' => false,
'systemTags' => [
'operationType' => 'get',
'riskType' => 'none',
'chargeType' => 'free',
],
'parameters' => [
[
'name' => 'DbName',
'in' => 'query',
'schema' => [
'title' => '数据库名称',
'description' => '需要获取数据库的名称。',
'type' => 'string',
'required' => true,
'example' => 'db001',
],
],
],
'responses' => [
200 => [
'schema' => [
'title' => '返回对象',
'description' => '返回对象。',
'type' => 'object',
'properties' => [
'Code' => [
'title' => '如果后端处理出现错误,则表示错误的类型',
'description' => '如果请求有异常,则返回异常编码。',
'type' => 'string',
'example' => 'NO_SUCH_OBJECT',
],
'Data' => [
'title' => '请求数据库低下的所有表',
'description' => '如果请求成功,则返回db001下面的所有有权限的表。',
'type' => 'array',
'items' => [
'description' => '如果请求成功,则返回db001下面的所有有权限的表。',
'type' => 'string',
'example' => 'tbl001',
],
],
'Message' => [
'title' => '如果后端处理出现错误,则表示错误的信息',
'description' => '如果出现异常,则返回错误的信息。',
'type' => 'string',
'example' => 'The database db001 does not exist',
],
'RequestId' => [
'title' => '请求的 ID',
'description' => '本次请求的RequestId。',
'type' => 'string',
'example' => '9BEAC206-0795-4DE3-B1FD-964BEF432B23',
],
'Success' => [
'title' => '标识本次请求是否成功',
'description' => '本次请求是否成功。',
'type' => 'boolean',
'example' => 'false',
],
],
],
],
],
'errorCodes' => [],
'responseDemo' => '[{"type":"json","example":"{\\n \\"Code\\": \\"NO_SUCH_OBJECT\\",\\n \\"Data\\": [\\n \\"tbl001\\"\\n ],\\n \\"Message\\": \\"The database db001 does not exist\\",\\n \\"RequestId\\": \\"9BEAC206-0795-4DE3-B1FD-964BEF432B23\\",\\n \\"Success\\": false\\n}","errorExample":""},{"type":"xml","example":"The database db001 does not exist\\n9BEAC206-0795-4DE3-B1FD-964BEF432B23\\n[ tbl001,tbl002 ]\\nNO_SUCH_OBJECT\\nfalse","errorExample":""}]',
'title' => '获取某个库下面的所有有权限的表',
],
'DropTable' => [
'summary' => '将给定表删除。',
'methods' => [
'post',
],
'schemes' => [
'http',
'https',
],
'security' => [
[
'AK' => [],
],
],
'operationType' => 'write',
'deprecated' => false,
'systemTags' => [
'operationType' => 'delete',
'riskType' => 'none',
'chargeType' => 'free',
],
'parameters' => [
[
'name' => 'DbName',
'in' => 'query',
'schema' => [
'title' => '数据库名称',
'description' => '需要删除表所在的数据库',
'type' => 'string',
'required' => true,
'example' => 'db001',
],
],
[
'name' => 'TableName',
'in' => 'query',
'schema' => [
'title' => '表名称',
'description' => '需要删除的表',
'type' => 'string',
'required' => true,
'example' => 'tbl001',
],
],
],
'responses' => [
200 => [
'schema' => [
'title' => '返回对象',
'description' => '返回对象',
'type' => 'object',
'properties' => [
'Code' => [
'title' => '如果后端处理出现错误,则表示错误的类型',
'description' => '标记成功错误的 CODE',
'type' => 'string',
'example' => 'NO_SUCH_OBJECT',
],
'Data' => [
'title' => '标记表是否删除成功',
'description' => '标记是否删除成功',
'type' => 'boolean',
'example' => 'false',
],
'Message' => [
'title' => '如果后端处理出现错误,则表示错误的信息',
'description' => '如果删除表失败,返回失败的原因。',
'type' => 'string',
'example' => 'No such table: db001.tbl001',
],
'RequestId' => [
'title' => '请求的 ID',
'description' => '请求的 RequestId',
'type' => 'string',
'example' => '9BEAC206-0795-4DE3-B1FD-964BEF432B23',
],
'Success' => [
'title' => '标识本次请求是否成功',
'description' => '标记本次请求是否成功',
'type' => 'boolean',
'example' => 'false',
],
],
],
],
],
'errorCodes' => [
430 => [
[
'errorCode' => 'ServerError.Inner',
'errorMessage' => 'An internal error occurred.',
],
],
],
'responseDemo' => '[{"type":"json","example":"{\\n \\"Code\\": \\"NO_SUCH_OBJECT\\",\\n \\"Data\\": false,\\n \\"Message\\": \\"No such table: db001.tbl001\\",\\n \\"RequestId\\": \\"9BEAC206-0795-4DE3-B1FD-964BEF432B23\\",\\n \\"Success\\": false\\n}","errorExample":""},{"type":"xml","example":"No such table: db001.tbl001\\n9BEAC206-0795-4DE3-B1FD-964BEF432B23\\nfalse\\nNO_SUCH_OBJECT\\nfalse","errorExample":""}]',
'title' => '将给定表删除',
],
],
'endpoints' => [
[
'regionId' => 'cn-beijing',
'endpoint' => 'openanalytics.cn-beijing.aliyuncs.com',
],
[
'regionId' => 'cn-zhangjiakou',
'endpoint' => 'openanalytics.cn-zhangjiakou.aliyuncs.com',
],
[
'regionId' => 'cn-hangzhou',
'endpoint' => 'openanalytics.cn-hangzhou.aliyuncs.com',
],
[
'regionId' => 'cn-shanghai',
'endpoint' => 'openanalytics.cn-shanghai.aliyuncs.com',
],
[
'regionId' => 'cn-shenzhen',
'endpoint' => 'openanalytics.cn-shenzhen.aliyuncs.com',
],
[
'regionId' => 'cn-hongkong',
'endpoint' => 'openanalytics.cn-hongkong.aliyuncs.com',
],
[
'regionId' => 'ap-southeast-1',
'endpoint' => 'openanalytics.ap-southeast-1.aliyuncs.com',
],
[
'regionId' => 'ap-southeast-2',
'endpoint' => 'datalakeanalytics.ap-southeast-2.aliyuncs.com',
],
[
'regionId' => 'ap-southeast-3',
'endpoint' => 'openanalytics.ap-southeast-3.aliyuncs.com',
],
[
'regionId' => 'ap-northeast-1',
'endpoint' => 'datalakeanalytics.ap-northeast-1.aliyuncs.com',
],
[
'regionId' => 'eu-west-1',
'endpoint' => 'openanalytics.eu-west-1.aliyuncs.com',
],
[
'regionId' => 'us-west-1',
'endpoint' => 'openanalytics.us-west-1.aliyuncs.com',
],
[
'regionId' => 'us-east-1',
'endpoint' => 'datalakeanalytics.us-east-1.aliyuncs.com',
],
[
'regionId' => 'eu-central-1',
'endpoint' => 'datalakeanalytics.eu-central-1.aliyuncs.com',
],
[
'regionId' => 'ap-south-1',
'endpoint' => 'openanalytics.ap-south-1.aliyuncs.com',
],
[
'regionId' => 'ap-northeast-2-pop',
'endpoint' => 'openanalytics.ap-northeast-1.aliyuncs.com',
],
[
'regionId' => 'ap-southeast-5',
'endpoint' => 'openanalytics.ap-southeast-5.aliyuncs.com',
],
[
'regionId' => 'cn-beijing-finance-1',
'endpoint' => 'openanalytics.aliyuncs.com',
],
[
'regionId' => 'cn-beijing-finance-pop',
'endpoint' => 'openanalytics.aliyuncs.com',
],
[
'regionId' => 'cn-beijing-gov-1',
'endpoint' => 'openanalytics.aliyuncs.com',
],
[
'regionId' => 'cn-beijing-nu16-b01',
'endpoint' => 'openanalytics.aliyuncs.com',
],
[
'regionId' => 'cn-chengdu',
'endpoint' => 'openanalytics.aliyuncs.com',
],
[
'regionId' => 'cn-edge-1',
'endpoint' => 'openanalytics.aliyuncs.com',
],
[
'regionId' => 'cn-fujian',
'endpoint' => 'openanalytics.aliyuncs.com',
],
[
'regionId' => 'cn-haidian-cm12-c01',
'endpoint' => 'openanalytics.aliyuncs.com',
],
[
'regionId' => 'cn-hangzhou-bj-b01',
'endpoint' => 'openanalytics.aliyuncs.com',
],
[
'regionId' => 'cn-hangzhou-finance',
'endpoint' => 'openanalytics.aliyuncs.com',
],
[
'regionId' => 'cn-hangzhou-internal-prod-1',
'endpoint' => 'openanalytics.aliyuncs.com',
],
[
'regionId' => 'cn-hangzhou-internal-test-1',
'endpoint' => 'openanalytics.aliyuncs.com',
],
[
'regionId' => 'cn-hangzhou-internal-test-2',
'endpoint' => 'openanalytics.aliyuncs.com',
],
[
'regionId' => 'cn-hangzhou-internal-test-3',
'endpoint' => 'openanalytics.aliyuncs.com',
],
[
'regionId' => 'cn-hangzhou-test-306',
'endpoint' => 'openanalytics.aliyuncs.com',
],
[
'regionId' => 'cn-hongkong-finance-pop',
'endpoint' => 'openanalytics.aliyuncs.com',
],
[
'regionId' => 'cn-huhehaote',
'endpoint' => 'openanalytics.cn-huhehaote.aliyuncs.com',
],
[
'regionId' => 'cn-north-2-gov-1',
'endpoint' => 'openanalytics.aliyuncs.com',
],
[
'regionId' => 'cn-qingdao',
'endpoint' => 'openanalytics.cn-qingdao.aliyuncs.com',
],
[
'regionId' => 'cn-qingdao-nebula',
'endpoint' => 'openanalytics.aliyuncs.com',
],
[
'regionId' => 'cn-shanghai-et15-b01',
'endpoint' => 'openanalytics.aliyuncs.com',
],
[
'regionId' => 'cn-shanghai-et2-b01',
'endpoint' => 'openanalytics.aliyuncs.com',
],
[
'regionId' => 'cn-shanghai-finance-1',
'endpoint' => 'openanalytics.aliyuncs.com',
],
[
'regionId' => 'cn-shanghai-inner',
'endpoint' => 'openanalytics.aliyuncs.com',
],
[
'regionId' => 'cn-shanghai-internal-test-1',
'endpoint' => 'openanalytics.aliyuncs.com',
],
[
'regionId' => 'cn-shenzhen-finance-1',
'endpoint' => 'openanalytics.aliyuncs.com',
],
[
'regionId' => 'cn-shenzhen-inner',
'endpoint' => 'openanalytics.aliyuncs.com',
],
[
'regionId' => 'cn-shenzhen-st4-d01',
'endpoint' => 'openanalytics.aliyuncs.com',
],
[
'regionId' => 'cn-shenzhen-su18-b01',
'endpoint' => 'openanalytics.aliyuncs.com',
],
[
'regionId' => 'cn-wuhan',
'endpoint' => 'openanalytics.aliyuncs.com',
],
[
'regionId' => 'cn-yushanfang',
'endpoint' => 'openanalytics.aliyuncs.com',
],
[
'regionId' => 'cn-zhangbei-na61-b01',
'endpoint' => 'openanalytics.aliyuncs.com',
],
[
'regionId' => 'cn-zhangjiakou-na62-a01',
'endpoint' => 'openanalytics.aliyuncs.com',
],
[
'regionId' => 'cn-zhengzhou-nebula-1',
'endpoint' => 'openanalytics.aliyuncs.com',
],
[
'regionId' => 'eu-west-1-oxs',
'endpoint' => 'openanalytics.ap-northeast-1.aliyuncs.com',
],
[
'regionId' => 'me-east-1',
'endpoint' => 'openanalytics.me-east-1.aliyuncs.com',
],
[
'regionId' => 'rus-west-1-pop',
'endpoint' => 'openanalytics.ap-northeast-1.aliyuncs.com',
],
],
];