华为云用户手册

  • 响应参数 状态码: 200 表4 响应Body参数 参数 参数类型 描述 [数组元素] Array of ShowRepoSharesResponse objects 共享列表 表5 ShowRepoSharesResponse 参数 参数类型 描述 id String ID namespace String 组织 repository String 镜像仓库 share_type String 共享类型。目前只支持account,organization share_principals Array of strings 被共享者的信息列表。 permission String 权限 deadline String 截止时间 description String 描述 creator_id String 创建者ID creator_name String 创建者名称 created String 镜像创建时间,UTC时间格式,时间为UTC标准时间,用户需要根据本地时间计算偏移量;如东8区需要+8:00 updated String 镜像更新时间,UTC时间格式,时间为UTC标准时间,用户需要根据本地时间计算偏移量;如东8区需要+8:00 status Boolean 是否过期:true:有效;false:过期
  • 请求参数 表3 请求Header参数 参数 是否必选 参数类型 描述 Content-Type 是 String 消息体的类型(格式),下方类型可任选其一使用: application/json;charset=utf-8 application/json 缺省值:application/json X-Auth-Token 是 String 用户Token。 通过调用IAM服务获取用户Token接口获取(响应消息头中X-Subject-Token的值)。
  • URI GET /v2/manage/namespaces/{namespace}/repos/{repository}/shares 表1 路径参数 参数 是否必选 参数类型 描述 namespace 是 String 组织名称。小写字母开头,后面跟小写字母、数字、小数点、下划线或中划线(其中下划线最多允许连续两个,小数点、下划线、中划线不能直接相连),小写字母或数字结尾,1-64个字符。 repository 是 String 镜像仓库名称 表2 Query参数 参数 是否必选 参数类型 描述 share_type 否 String 共享类型
  • 请求参数 表1 请求Header参数 参数 是否必选 参数类型 描述 Content-Type 是 String 消息体的类型(格式),下方类型可任选其一使用: application/json;charset=utf-8 application/json 缺省值:application/json X-Auth-Token 是 String 用户Token。 通过调用IAM服务获取用户Token接口获取(响应消息头中X-Subject-Token的值)。
  • 请求参数 表2 请求Header参数 参数 是否必选 参数类型 描述 Content-Type 是 String 消息体的类型(格式),下方类型可任选其一使用: application/json;charset=utf-8 application/json 缺省值:application/json X-Auth-Token 是 String 用户Token。 通过调用IAM服务获取用户Token接口获取(响应消息头中X-Subject-Token的值)。 表3 请求Body参数 参数 是否必选 参数类型 描述 source_tag 是 String 源镜像版本名称 destination_tag 是 String 目标镜像版本名称 override 否 Boolean 是否覆盖
  • URI POST /v2/manage/namespaces/{namespace}/repos/{repository}/tags 表1 路径参数 参数 是否必选 参数类型 描述 namespace 是 String 组织名称。小写字母开头,后面跟小写字母、数字、小数点、下划线或中划线(其中下划线最多允许连续两个,小数点、下划线、中划线不能直接相连),小写字母或数字结尾,1-64个字符。 repository 是 String 镜像仓库名称
  • 请求参数 表1 请求Header参数 参数 是否必选 参数类型 描述 Content-Type 是 String 消息体的类型(格式),下方类型可任选其一使用: application/json;charset=utf-8 application/json 缺省值:application/json X-Auth-Token 是 String 用户Token。 通过调用IAM服务获取用户Token接口获取(响应消息头中X-Subject-Token的值)。
  • URI PATCH /v2/manage/namespaces/{namespace}/repos/{repository}/shares/{share_id} 表1 路径参数 参数 是否必选 参数类型 描述 namespace 是 String 组织名称。小写字母开头,后面跟小写字母、数字、小数点、下划线或中划线(其中下划线最多允许连续两个,小数点、下划线、中划线不能直接相连),小写字母或数字结尾,1-64个字符。 repository 是 String 镜像仓库名称 share_id 是 String 镜像共享规则ID
  • 请求参数 表2 请求Header参数 参数 是否必选 参数类型 描述 Content-Type 是 String 消息体的类型(格式),下方类型可任选其一使用: application/json;charset=utf-8 application/json 缺省值:application/json X-Auth-Token 是 String 用户Token。 通过调用IAM服务获取用户Token接口获取(响应消息头中X-Subject-Token的值)。 表3 请求Body参数 参数 是否必选 参数类型 描述 permission 是 String 当前只支持read权限 deadline 是 String 截止时间,UTC时间格式。永久有效为forever description 否 String 描述。默认值为空字符串
  • 请求示例 PATCH https://{endpoint}/v2/manage/namespaces/{namespace}/repos/{repository}/shares/{share_id} { "permission" : "read", "deadline" : "2018-10-01T16:00:00.000Z", "description" : "description" }
  • 响应示例 状态码: 200 查询成功 { "id" : "1", "namespace" : "huawei", "repository" : "paas", "share_type" : "organization", "share_principals" : [ "organizations::19ae87f6919c44bca6596733264666d9:ou:o-ahjlk5emc2c9vi8fzpvps3hafuf425e5/ou-g2p6cwqrj5x6agbswzrmgyvncz6e9f2w" ], "permission" : "read", "deadline" : "2018-10-01T16:00:00.000Z", "description" : "description", "creator_id" : "fb3f175c1fd146ab8cdae3272be6107b", "creator_name" : "huawei", "created" : "2017-04-08T14:12:23Z", "updated" : "2017-04-13T21:01:11Z", "status" : false }
  • 响应参数 状态码: 200 表3 响应Body参数 参数 参数类型 描述 id String ID namespace String 组织 repository String 镜像仓库 share_type String 共享类型。目前只支持account,organization share_principals Array of strings 被共享者的信息列表。 permission String 权限 deadline String 截止时间 description String 描述 creator_id String 创建者ID creator_name String 创建者名称 created String 镜像创建时间,UTC时间格式,时间为UTC标准时间,用户需要根据本地时间计算偏移量;如东8区需要+8:00 updated String 镜像更新时间,UTC时间格式,时间为UTC标准时间,用户需要根据本地时间计算偏移量;如东8区需要+8:00 status Boolean 是否过期:true:有效;false:过期
  • URI GET /v2/manage/namespaces/{namespace}/repos/{repository}/shares/{share_id} 表1 路径参数 参数 是否必选 参数类型 描述 namespace 是 String 组织名称。小写字母开头,后面跟小写字母、数字、小数点、下划线或中划线(其中下划线最多允许连续两个,小数点、下划线、中划线不能直接相连),小写字母或数字结尾,1-64个字符。 repository 是 String 镜像仓库名称 share_id 是 String 镜像共享规则ID
  • 请求参数 表2 请求Header参数 参数 是否必选 参数类型 描述 Content-Type 是 String 消息体的类型(格式),下方类型可任选其一使用: application/json;charset=utf-8 application/json 缺省值:application/json X-Auth-Token 是 String 用户Token。 通过调用IAM服务获取用户Token接口获取(响应消息头中X-Subject-Token的值)。
  • 方法一:通过设置系统参数开启/关闭并行查询 在管理控制台的参数修改页面,通过设置系统参数,开启和关闭并行查询,并设置并行度。 通过全局参数force_parallel_execute来控制是否强制启用并行执行; 使用全局参数parallel_default_dop来控制使用多少线程并行执行; 使用全局参数parallel_cost_threshold来控制当执行代价为多大时,开启并行执行。 上述参数在使用过程中,随时可以修改,无需重启数据库。 例如,想要强制开启并行执行,并且并发度为4,最小执行代价为0,可参照如下进行设置: SET force_parallel_execute=ON SET parallel_default_dop=4 SET parallel_cost_threshold=0
  • 支持的系统参数和状态变量 表1 系统参数 参数名 级别 描述 force_parallel_execute Global, Session 是否开启并行查询,当设置为ON时,表示查询SQL尽可能地使用并行执行。 · 取值范围:ON, OFF · 默认值OFF parallel_max_threads Global 并行执行的最大活跃线程个数。当并行执行的活跃线程超过该值时,新的查询将不允许启用并行执行。 · 取值范围:0-4294967295 · 默认值:64 parallel_default_dop Global, Session 并行执行的默认并行度。当查询语句没有指定并行度时,使用该值。 · 取值范围:0-1024 · 默认值:4 parallel_cost_threshold Global, Session 启用并行执行的代价阈值。只有当查询的执行代价超过该阈值时才有可能进行并行执行。 · 取值范围:0-4294967295 · 默认值:1000 parallel_queue_timeout Global, Session 当不满足并行查询的条件时,请求并行执行的SQL等待超时时间。当等待时间超过该值后,则不再等待,开始进行单线程执行。 · 取值范围:0-4294967295 · 默认值:0 parallel_memory_limit Global 并行执行可用的内存上限。当并行执行使用的内存量超过该值时,新的SQL查询将不会进行并行执行。 · 取值范围:0-4294967295 · 默认值:104857600 表2 状态变量 变量名 级别 描述 PQ_threads_running Global 当前正在运行的并行执行的总线程数。 PQ_memory_used Global 当前并行执行使用的总内存量。 PQ_threads_refused Global 由于总线程数限制,导致未能执行并行执行的查询总数。 PQ_memory_refused Global 由于总内存限制,导致未能执行并行执行的查询总数。
  • 响应参数 状态码: 200 表4 响应Body参数 参数 参数类型 描述 data Object 返回的数据信息 状态码: 400 表5 响应Body参数 参数 参数类型 描述 error_code String 错误码,如DS.000,请求处理成功 error_msg String 错误信息 data Object 返回的数据信息 状态码: 401 表6 响应Body参数 参数 参数类型 描述 error_code String 错误码,如DS.000,请求处理成功 error_msg String 错误信息 data Object 返回的数据信息 状态码: 403 表7 响应Body参数 参数 参数类型 描述 error_code String 错误码,如DS.000,请求处理成功 error_msg String 错误信息 data Object 返回的数据信息
  • 请求示例 { "id" : "1024715832535691111", "name_ch" : "示例", "name_en" : "example", "description" : "desc", "alias" : "example", "data_owner" : "example", "data_owner_list" : "[\"abc\"]", "parent_id" : "1024715832535695360", "level" : 2, "self_defined_fields" : [ { "fd_name_ch" : "zdy", "fd_name_en" : "zdy", "not_null" : false, "fd_value" : "sdf" } ] }
  • 响应示例 状态码: 200 Success,返回data数据是 entity 详情 { "data" : { "value" : { "name_ch" : "示例", "name_en" : "example", "description" : "desc", "qualified_name" : "L3.example@Business.xxx", "guid" : null, "code" : null, "status" : "DRAFT", "new_biz" : null, "alias" : "example", "data_owner" : "example", "data_owner_list" : "[\"abc\"]", "data_department" : null, "path" : "主题3New/示例", "level" : 2, "ordinal" : 2, "owner" : "ei_dlf_l00341563", "parent_id" : "1024715832535695360", "swap_order_id" : null, "id" : "1035859890809266176", "qualified_id" : null, "create_by" : "abc", "update_by" : "abc", "create_time" : "2022-10-29T10:17:23.315+08:00", "update_time" : "2022-10-29T10:17:23.315+08:00", "self_defined_fields" : [ { "fd_name_ch" : "zdy", "fd_name_en" : "zdy", "not_null" : false, "fd_value" : "sdf" } ], "children_num" : null, "children" : null } } }
  • 请求参数 表2 请求Header参数 参数 是否必选 参数类型 描述 X-Auth-Token 是 String IAM Token workspace 是 String DataArts Studio工作空间ID 表3 请求Body参数 参数 是否必选 参数类型 描述 id 否 Long 编码。更新时必填,创建时可以为空 name_ch 是 String 中文名称 最大长度:200 name_en 是 String 英文名称 最大长度:100 description 否 String 描述信息, 业务对象必填 最大长度:200 alias 否 String 别名 最大长度:200 data_owner 否 String 数据owner部门 最大长度:200 data_owner_list 是 String 数据owner人员 level 是 Integer 层级 parent_id 否 Long 上层主题id,首层则为空 self_defined_fields 否 Array of SelfDefinedFieldVO objects 属性自定义项 表4 SelfDefinedFieldVO 参数 是否必选 参数类型 描述 fd_name_ch 否 String 自定义项中文名 最大长度:200 fd_name_en 否 String 自定义项英文名 最大长度:200 not_null 否 Boolean 是否必填 fd_value 否 String 属性值
  • 响应参数 状态码: 200 表5 响应Body参数 参数 参数类型 描述 data Object 返回的数据信息 状态码: 400 表6 响应Body参数 参数 参数类型 描述 error_code String 错误码,如DS.000,请求处理成功 error_msg String 错误信息 data Object 返回的数据信息 状态码: 401 表7 响应Body参数 参数 参数类型 描述 error_code String 错误码,如DS.000,请求处理成功 error_msg String 错误信息 data Object 返回的数据信息 状态码: 403 表8 响应Body参数 参数 参数类型 描述 error_code String 错误码,如DS.000,请求处理成功 error_msg String 错误信息 data Object 返回的数据信息 状态码: 404 表9 响应Body参数 参数 参数类型 描述 error_code String 错误码,如DS.000,请求处理成功 error_msg String 错误信息 data Object 返回的数据信息
  • 响应示例 成功响应 HTTP状态码 200 { "total": 1, "scripts": [ { "configuration": {}, "connectionName": "mrs_spark", "content": "SELECT 1;", "database": "aaa", "description": "", "directory": "/", "name": "mrs_spark_sql", "type": "SparkSQL" } ] } 失败响应 HTTP状态码 400 { "error_code":"DLF.3051", "error_msg":"The request parameter is invalid." }
  • 响应参数 状态码: 200 表4 响应Body参数 参数 参数类型 描述 data Object 返回的数据信息 状态码: 400 表5 响应Body参数 参数 参数类型 描述 error_code String 错误码,如DS.000,请求处理成功 error_msg String 错误信息 data Object 返回的数据信息 状态码: 401 表6 响应Body参数 参数 参数类型 描述 error_code String 错误码,如DS.000,请求处理成功 error_msg String 错误信息 data Object 返回的数据信息 状态码: 403 表7 响应Body参数 参数 参数类型 描述 error_code String 错误码,如DS.000,请求处理成功 error_msg String 错误信息 data Object 返回的数据信息
  • 响应示例 状态码: 200 Success,返回data数据是 AggregationLogicTableVO 详情 { "data" : { "value" : { "id" : "874242075850342400", "tb_name" : "dws_rate_code", "tb_logic_name" : "费率代码汇总", "l1_id" : "873232498044411904", "l2_id" : "873232716601204736", "l3_id" : "873233519286059008", "description" : "无", "owner" : "abc", "create_by" : "abc", "queue_name" : "dgc_dli_test", "dw_id" : "2c9080f07b03db8d017b198a4a20002f", "db_name" : "demo_dm_db", "tb_id" : "NativeTable-2c9080f07b03db8d017b198a4a20002f-demo_dm_db-dws_rate_code", "schema" : "", "dw_name" : null, "status" : "PUBLISHED", "tb_guid" : "a268644b-31b6-42e5-84ec-e35c31b541a5", "tb_logic_guid" : "8948f715-3567-4684-9950-e3ed01e77121", "dw_type" : "DLI", "l1" : "城市交通", "l2" : "行程记录", "l3" : "记录统计", "create_time" : "2021-08-09T10:45:54+08:00", "update_time" : "2021-09-26T15:36:53+08:00", "approval_info" : { "id" : "874242076399796224", "tenant_id" : null, "name_ch" : null, "name_en" : null, "biz_id" : "874242075850342400", "biz_type" : null, "biz_info" : null, "biz_info_obj" : null, "biz_version" : 0, "biz_status" : "PUBLISHED", "approval_status" : "APPROVED", "approval_type" : null, "submit_time" : "2021-08-09T10:45:54+08:00", "create_by" : null, "l1" : null, "l2" : null, "l3" : null, "approval_time" : "2021-08-09T10:45:53+08:00", "approver" : "abc", "email" : null, "msg" : "Fast Approval OK.", "directory_path" : null }, "new_biz" : null, "dimension_group" : "873252544997130240", "group_name" : "费率代码", "group_code" : null, "time_period" : { "id" : "874242075984560130", "aggregation_logic_table_id" : "874242075850342400", "ordinal" : 1, "name_en" : "dtime", "name_ch" : "统计日期", "attribute_type" : "SUMMARY_TIME", "is_primary_key" : false, "is_partition_key" : true, "not_null" : false, "description" : null, "data_type" : "TIMESTAMP", "domain_type" : "DATETIME", "data_type_extend" : null, "ref_id" : null, "stand_row_id" : null, "stand_row_name" : null, "quality_infos" : null, "alias" : null }, "table_attributes" : [ { "id" : "874242075984560130", "aggregation_logic_table_id" : "874242075850342400", "ordinal" : 1, "name_en" : "dtime", "name_ch" : "统计日期", "attribute_type" : "SUMMARY_TIME", "is_primary_key" : false, "is_partition_key" : true, "not_null" : false, "description" : null, "data_type" : "TIMESTAMP", "domain_type" : "DATETIME", "data_type_extend" : null, "ref_id" : null, "stand_row_id" : null, "stand_row_name" : null, "quality_infos" : null, "alias" : null }, { "id" : "874242075984560131", "aggregation_logic_table_id" : "874242075850342400", "ordinal" : 2, "name_en" : "sum_total_amount", "name_ch" : "总车费(费率代码)", "attribute_type" : "DERIVATIVE_INDEX", "is_primary_key" : false, "is_partition_key" : false, "not_null" : false, "description" : "", "data_type" : "DOUBLE", "domain_type" : "NUMBER", "data_type_extend" : null, "ref_id" : "873265784540004352", "stand_row_id" : null, "stand_row_name" : null, "quality_infos" : null, "alias" : null }, { "id" : "874242075984560132", "aggregation_logic_table_id" : "874242075850342400", "ordinal" : 3, "name_en" : "dim_rate_code_rate_code_id", "name_ch" : "费率代码_费率id", "attribute_type" : "SUMMARY_DIMENSION_ATTRIBUTE", "is_primary_key" : false, "is_partition_key" : false, "not_null" : true, "description" : "", "data_type" : "BIGINT", "domain_type" : "NUMBER", "data_type_extend" : null, "ref_id" : "873252544997130240.873258130849636352", "stand_row_id" : null, "stand_row_name" : null, "quality_infos" : null, "alias" : null }, { "id" : "874242075984560133", "aggregation_logic_table_id" : "874242075850342400", "ordinal" : 4, "name_en" : "dim_rate_code_rate_code_value", "name_ch" : "费率代码_费率说明", "attribute_type" : "SUMMARY_DIMENSION_ATTRIBUTE", "is_primary_key" : false, "is_partition_key" : false, "not_null" : false, "description" : "", "data_type" : "STRING", "domain_type" : "STRING", "data_type_extend" : null, "ref_id" : "873252544997130240.873258130849636353", "stand_row_id" : null, "stand_row_name" : null, "quality_infos" : null, "alias" : null } ], "physical_table" : "CREATE_SUCCESS", "technical_asset" : "UPDATE_SUCCESS", "business_asset" : "UPDATE_SUCCESS", "meta_data_link" : "UPDATE_SUCCESS", "data_quality" : "UPDATE_SUCCESS", "dlf_task" : "CREATE_SUCCESS", "publish_to_dlm" : "NO_NEED", "summary_status" : "SUMMARY_SUCCESS", "distribute" : null, "distribute_column" : null, "table_type" : "MANAGED", "dlf_task_id" : "demo_dm_db_dws_rate_code_874242075850342400", "quality_id" : "874242188178075649", "reversed" : null, "table_version" : 0, "partition_conf" : null, "dirty_out_switch" : false, "dirty_out_database" : "", "dirty_out_prefix" : "", "dirty_out_suffix" : "", "alias" : "", "self_defined_fields" : [ ], "api_id" : null } } }
  • 响应参数 状态码: 200 表4 响应Body参数 参数 参数类型 描述 data Object 返回的数据信息 状态码: 400 表5 响应Body参数 参数 参数类型 描述 error_code String 错误码,如DS.000,请求处理成功 error_msg String 错误信息 data Object 返回的数据信息 状态码: 401 表6 响应Body参数 参数 参数类型 描述 error_code String 错误码,如DS.000,请求处理成功 error_msg String 错误信息 data Object 返回的数据信息 状态码: 403 表7 响应Body参数 参数 参数类型 描述 error_code String 错误码,如DS.000,请求处理成功 error_msg String 错误信息 data Object 返回的数据信息
  • 响应示例 状态码: 200 Success,返回data数据是 ConditionVO 详情 { "data" : { "value" : { "id" : "873154196235517965", "name_en" : "f4w", "name_ch" : "未来4周", "description" : "历史数据的每天平均值*7*4", "create_by" : "SYSTEM", "condition_fn" : "BETWEEN_DAY", "condition_fn_param" : "1,28", "status" : "PUBLISHED", "create_time" : "2021-08-06T10:43:03+08:00", "update_time" : "2021-08-06T10:43:03+08:00", "approval_info" : null, "new_biz" : null, "base_time" : null } } }
  • 响应参数 状态码: 200 表4 响应Body参数 参数 参数类型 描述 data Object 返回的数据信息 状态码: 400 表5 响应Body参数 参数 参数类型 描述 error_code String 错误码,如DS.000,请求处理成功 error_msg String 错误信息 data Object 返回的数据信息 状态码: 401 表6 响应Body参数 参数 参数类型 描述 error_code String 错误码,如DS.000,请求处理成功 error_msg String 错误信息 data Object 返回的数据信息 状态码: 403 表7 响应Body参数 参数 参数类型 描述 error_code String 错误码,如DS.000,请求处理成功 error_msg String 错误信息 data Object 返回的数据信息
  • URI GET /v2/{project_id}/design/biz-metrics/dimensions 表1 路径参数 参数 是否必选 参数类型 描述 project_id 是 String 项目id 表2 Query参数 参数 是否必选 参数类型 描述 limit 否 Integer 查询条数,即查询Y条数据。默认值50,取值范围[1,100] 最大值:100 缺省值:50 offset 否 Integer 查询起始坐标,即跳过X条数据,仅支持0或limit的整数倍,不满足则向下取整。默认值0 缺省值:0
  • 响应示例 状态码: 200 Success,返回data数据是 FactLogicTableVO 数组, 以及总数 { "data" : { "value" : { "records" : [ { "id" : "873264563070599168", "tb_name" : "fact_stroke_order", "tb_logic_name" : "行程订单", "l1_id" : "873232498044411904", "l2_id" : "873232716601204736", "l3_id" : "873233440420560896", "description" : "无", "dw_name" : null, "owner" : "abc", "create_by" : "abc", "queue_name" : "dgc_dli_test", "dw_id" : "2c9080f07b03db8d017b198a4a20002f", "db_name" : "demo_dwr_db", "tb_id" : "NativeTable-2c9080f07b03db8d017b198a4a20002f-demo_dwr_db-fact_stroke_order", "dim_table_ids" : null, "reversed" : null, "partition_conf" : null, "dirty_out_switch" : false, "dirty_out_database" : "", "dirty_out_prefix" : "", "dirty_out_suffix" : "", "schema" : "", "distribute" : null, "distribute_column" : null, "table_type" : "MANAGED", "status" : "PUBLISHED", "tb_guid" : "60c0a59c-fc48-437a-94a3-48680e342114", "tb_logic_guid" : "3ebe8fda-5417-4934-80bd-46ed7d46906a", "dw_type" : "DLI", "l1" : "城市交通", "l2" : "行程记录", "l3" : "行程事实", "create_time" : "2021-08-06T18:01:36+08:00", "update_time" : "2021-10-14T11:08:16+08:00", "approval_info" : { "id" : "873264617198166016", "tenant_id" : null, "name_ch" : null, "name_en" : null, "biz_id" : "873264563070599168", "biz_type" : null, "biz_info" : null, "biz_info_obj" : null, "biz_version" : 0, "biz_status" : "PUBLISHED", "approval_status" : "APPROVED", "approval_type" : null, "submit_time" : "2021-08-06T18:01:49+08:00", "create_by" : null, "l1" : null, "l2" : null, "l3" : null, "approval_time" : "2021-08-06T18:01:49+08:00", "approver" : "abc", "email" : null, "msg" : "Fast Approval OK.", "directory_path" : null }, "new_biz" : null, "dimensions" : [ { "id" : "873264563087376384", "fact_logic_table_id" : "873264563070599168", "ordinal" : 1, "dimension_id" : "873252544997130240", "role" : null, "dimension" : null, "is_primary_key" : false, "is_partition_key" : false, "is_foreign_key" : true, "description" : "", "data_type" : "BIGINT", "domain_type" : "NUMBER", "data_type_extend" : null, "name_en" : "rate_code_id", "name_ch" : "费率id", "not_null" : false, "attribute_type" : "FACT_DIMENSION", "stand_row_id" : "873241897769082881", "stand_row_name" : null, "quality_infos" : null, "alias" : "", "self_defined_fields" : null }, { "id" : "873264563087376385", "fact_logic_table_id" : "873264563070599168", "ordinal" : 2, "dimension_id" : "873251932406448128", "role" : null, "dimension" : null, "is_primary_key" : false, "is_partition_key" : false, "is_foreign_key" : true, "description" : "", "data_type" : "BIGINT", "domain_type" : "NUMBER", "data_type_extend" : null, "name_en" : "payment_type_id", "name_ch" : "付款方式编码", "not_null" : false, "attribute_type" : "FACT_DIMENSION", "stand_row_id" : null, "stand_row_name" : null, "quality_infos" : null, "alias" : "", "self_defined_fields" : null }, { "id" : "873264563087376386", "fact_logic_table_id" : "873264563070599168", "ordinal" : 3, "dimension_id" : "873251051724242944", "role" : null, "dimension" : null, "is_primary_key" : false, "is_partition_key" : false, "is_foreign_key" : true, "description" : "", "data_type" : "BIGINT", "domain_type" : "NUMBER", "data_type_extend" : null, "name_en" : "vendor_id", "name_ch" : "供应商id", "not_null" : false, "attribute_type" : "FACT_DIMENSION", "stand_row_id" : "873241295328616449", "stand_row_name" : null, "quality_infos" : null, "alias" : "", "self_defined_fields" : null }, { "id" : "873264563087376387", "fact_logic_table_id" : "873264563070599168", "ordinal" : 4, "dimension_id" : "873254266029113344", "role" : "dim_pickup", "dimension" : null, "is_primary_key" : false, "is_partition_key" : false, "is_foreign_key" : true, "description" : "", "data_type" : "TIMESTAMP", "domain_type" : "DATETIME", "data_type_extend" : null, "name_en" : "dim_pickup_date_key", "name_ch" : "上车时间", "not_null" : false, "attribute_type" : "FACT_DIMENSION", "stand_row_id" : null, "stand_row_name" : null, "quality_infos" : null, "alias" : "", "self_defined_fields" : null }, { "id" : "873264563087376388", "fact_logic_table_id" : "873264563070599168", "ordinal" : 5, "dimension_id" : "873254266029113344", "role" : "dim_dropoff", "dimension" : null, "is_primary_key" : false, "is_partition_key" : false, "is_foreign_key" : true, "description" : "", "data_type" : "TIMESTAMP", "domain_type" : "DATETIME", "data_type_extend" : null, "name_en" : "dim_dropoff_date_key", "name_ch" : "下车时间", "not_null" : false, "attribute_type" : "FACT_DIMENSION", "stand_row_id" : null, "stand_row_name" : null, "quality_infos" : null, "alias" : "", "self_defined_fields" : null } ], "attributes" : null, "mappings" : null, "measures" : [ { "id" : "873264563087376389", "fact_logic_table_id" : "873264563070599168", "ordinal" : 6, "dimension_id" : null, "role" : null, "dimension" : null, "is_primary_key" : false, "is_partition_key" : false, "is_foreign_key" : null, "description" : "", "data_type" : "STRING", "domain_type" : "STRING", "data_type_extend" : "", "name_en" : "pu_location_id", "name_ch" : "上车地点", "not_null" : false, "attribute_type" : "FACT_MEASURE", "stand_row_id" : null, "stand_row_name" : null, "quality_infos" : null, "alias" : "", "self_defined_fields" : null }, { "id" : "873264563087376390", "fact_logic_table_id" : "873264563070599168", "ordinal" : 7, "dimension_id" : null, "role" : null, "dimension" : null, "is_primary_key" : false, "is_partition_key" : false, "is_foreign_key" : null, "description" : "", "data_type" : "STRING", "domain_type" : "STRING", "data_type_extend" : "", "name_en" : "do_location_id", "name_ch" : "下车地点", "not_null" : false, "attribute_type" : "FACT_MEASURE", "stand_row_id" : null, "stand_row_name" : null, "quality_infos" : null, "alias" : "", "self_defined_fields" : null }, { "id" : "873264563087376391", "fact_logic_table_id" : "873264563070599168", "ordinal" : 8, "dimension_id" : null, "role" : null, "dimension" : null, "is_primary_key" : false, "is_partition_key" : false, "is_foreign_key" : null, "description" : "", "data_type" : "DECIMAL", "domain_type" : "NUMBER", "data_type_extend" : "(10,2)", "name_en" : "fare_amount", "name_ch" : "车费", "not_null" : false, "attribute_type" : "FACT_MEASURE", "stand_row_id" : null, "stand_row_name" : null, "quality_infos" : null, "alias" : "", "self_defined_fields" : null }, { "id" : "873264563087376392", "fact_logic_table_id" : "873264563070599168", "ordinal" : 9, "dimension_id" : null, "role" : null, "dimension" : null, "is_primary_key" : false, "is_partition_key" : false, "is_foreign_key" : null, "description" : "", "data_type" : "DECIMAL", "domain_type" : "NUMBER", "data_type_extend" : "(10,2)", "name_en" : "extra", "name_ch" : "加收", "not_null" : false, "attribute_type" : "FACT_MEASURE", "stand_row_id" : null, "stand_row_name" : null, "quality_infos" : null, "alias" : "", "self_defined_fields" : null }, { "id" : "873264563087376393", "fact_logic_table_id" : "873264563070599168", "ordinal" : 10, "dimension_id" : null, "role" : null, "dimension" : null, "is_primary_key" : false, "is_partition_key" : false, "is_foreign_key" : null, "description" : "", "data_type" : "DECIMAL", "domain_type" : "NUMBER", "data_type_extend" : "(10,2)", "name_en" : "mta_tax", "name_ch" : "MTA税", "not_null" : false, "attribute_type" : "FACT_MEASURE", "stand_row_id" : null, "stand_row_name" : null, "quality_infos" : null, "alias" : "", "self_defined_fields" : null }, { "id" : "873264563087376394", "fact_logic_table_id" : "873264563070599168", "ordinal" : 11, "dimension_id" : null, "role" : null, "dimension" : null, "is_primary_key" : false, "is_partition_key" : false, "is_foreign_key" : null, "description" : "", "data_type" : "DECIMAL", "domain_type" : "NUMBER", "data_type_extend" : "(10,2)", "name_en" : "tip_amount", "name_ch" : "手续费", "not_null" : false, "attribute_type" : "FACT_MEASURE", "stand_row_id" : null, "stand_row_name" : null, "quality_infos" : null, "alias" : "", "self_defined_fields" : null }, { "id" : "873264563087376395", "fact_logic_table_id" : "873264563070599168", "ordinal" : 12, "dimension_id" : null, "role" : null, "dimension" : null, "is_primary_key" : false, "is_partition_key" : false, "is_foreign_key" : null, "description" : "", "data_type" : "DECIMAL", "domain_type" : "NUMBER", "data_type_extend" : "(10,2)", "name_en" : "tolls_amount", "name_ch" : "通行费", "not_null" : false, "attribute_type" : "FACT_MEASURE", "stand_row_id" : null, "stand_row_name" : null, "quality_infos" : null, "alias" : "", "self_defined_fields" : null }, { "id" : "873264563087376396", "fact_logic_table_id" : "873264563070599168", "ordinal" : 13, "dimension_id" : null, "role" : null, "dimension" : null, "is_primary_key" : false, "is_partition_key" : false, "is_foreign_key" : null, "description" : "", "data_type" : "DECIMAL", "domain_type" : "NUMBER", "data_type_extend" : "(10,2)", "name_en" : "improvement_surcharge", "name_ch" : "改善附加费", "not_null" : false, "attribute_type" : "FACT_MEASURE", "stand_row_id" : null, "stand_row_name" : null, "quality_infos" : null, "alias" : "", "self_defined_fields" : null }, { "id" : "873264563087376397", "fact_logic_table_id" : "873264563070599168", "ordinal" : 14, "dimension_id" : null, "role" : null, "dimension" : null, "is_primary_key" : false, "is_partition_key" : false, "is_foreign_key" : null, "description" : "", "data_type" : "DECIMAL", "domain_type" : "NUMBER", "data_type_extend" : "(10,2)", "name_en" : "total_amount", "name_ch" : "总车费", "not_null" : false, "attribute_type" : "FACT_MEASURE", "stand_row_id" : null, "stand_row_name" : null, "quality_infos" : null, "alias" : "", "self_defined_fields" : null } ], "table_attributes" : [ { "id" : "873264563087376384", "fact_logic_table_id" : "873264563070599168", "ordinal" : 1, "dimension_id" : "873252544997130240", "role" : null, "dimension" : null, "is_primary_key" : false, "is_partition_key" : false, "is_foreign_key" : true, "description" : "", "data_type" : "BIGINT", "domain_type" : "NUMBER", "data_type_extend" : null, "name_en" : "rate_code_id", "name_ch" : "费率id", "not_null" : false, "attribute_type" : "FACT_DIMENSION", "stand_row_id" : "873241897769082881", "stand_row_name" : null, "quality_infos" : null, "alias" : "", "self_defined_fields" : null }, { "id" : "873264563087376385", "fact_logic_table_id" : "873264563070599168", "ordinal" : 2, "dimension_id" : "873251932406448128", "role" : null, "dimension" : null, "is_primary_key" : false, "is_partition_key" : false, "is_foreign_key" : true, "description" : "", "data_type" : "BIGINT", "domain_type" : "NUMBER", "data_type_extend" : null, "name_en" : "payment_type_id", "name_ch" : "付款方式编码", "not_null" : false, "attribute_type" : "FACT_DIMENSION", "stand_row_id" : null, "stand_row_name" : null, "quality_infos" : null, "alias" : "", "self_defined_fields" : null }, { "id" : "873264563087376386", "fact_logic_table_id" : "873264563070599168", "ordinal" : 3, "dimension_id" : "873251051724242944", "role" : null, "dimension" : null, "is_primary_key" : false, "is_partition_key" : false, "is_foreign_key" : true, "description" : "", "data_type" : "BIGINT", "domain_type" : "NUMBER", "data_type_extend" : null, "name_en" : "vendor_id", "name_ch" : "供应商id", "not_null" : false, "attribute_type" : "FACT_DIMENSION", "stand_row_id" : "873241295328616449", "stand_row_name" : null, "quality_infos" : null, "alias" : "", "self_defined_fields" : null }, { "id" : "873264563087376387", "fact_logic_table_id" : "873264563070599168", "ordinal" : 4, "dimension_id" : "873254266029113344", "role" : "dim_pickup", "dimension" : null, "is_primary_key" : false, "is_partition_key" : false, "is_foreign_key" : true, "description" : "", "data_type" : "TIMESTAMP", "domain_type" : "DATETIME", "data_type_extend" : null, "name_en" : "dim_pickup_date_key", "name_ch" : "上车时间", "not_null" : false, "attribute_type" : "FACT_DIMENSION", "stand_row_id" : null, "stand_row_name" : null, "quality_infos" : null, "alias" : "", "self_defined_fields" : null }, { "id" : "873264563087376388", "fact_logic_table_id" : "873264563070599168", "ordinal" : 5, "dimension_id" : "873254266029113344", "role" : "dim_dropoff", "dimension" : null, "is_primary_key" : false, "is_partition_key" : false, "is_foreign_key" : true, "description" : "", "data_type" : "TIMESTAMP", "domain_type" : "DATETIME", "data_type_extend" : null, "name_en" : "dim_dropoff_date_key", "name_ch" : "下车时间", "not_null" : false, "attribute_type" : "FACT_DIMENSION", "stand_row_id" : null, "stand_row_name" : null, "quality_infos" : null, "alias" : "", "self_defined_fields" : null }, { "id" : "873264563087376389", "fact_logic_table_id" : "873264563070599168", "ordinal" : 6, "dimension_id" : null, "role" : null, "dimension" : null, "is_primary_key" : false, "is_partition_key" : false, "is_foreign_key" : null, "description" : "", "data_type" : "STRING", "domain_type" : "STRING", "data_type_extend" : "", "name_en" : "pu_location_id", "name_ch" : "上车地点", "not_null" : false, "attribute_type" : "FACT_MEASURE", "stand_row_id" : null, "stand_row_name" : null, "quality_infos" : null, "alias" : "", "self_defined_fields" : null }, { "id" : "873264563087376390", "fact_logic_table_id" : "873264563070599168", "ordinal" : 7, "dimension_id" : null, "role" : null, "dimension" : null, "is_primary_key" : false, "is_partition_key" : false, "is_foreign_key" : null, "description" : "", "data_type" : "STRING", "domain_type" : "STRING", "data_type_extend" : "", "name_en" : "do_location_id", "name_ch" : "下车地点", "not_null" : false, "attribute_type" : "FACT_MEASURE", "stand_row_id" : null, "stand_row_name" : null, "quality_infos" : null, "alias" : "", "self_defined_fields" : null }, { "id" : "873264563087376391", "fact_logic_table_id" : "873264563070599168", "ordinal" : 8, "dimension_id" : null, "role" : null, "dimension" : null, "is_primary_key" : false, "is_partition_key" : false, "is_foreign_key" : null, "description" : "", "data_type" : "DECIMAL", "domain_type" : "NUMBER", "data_type_extend" : "(10,2)", "name_en" : "fare_amount", "name_ch" : "车费", "not_null" : false, "attribute_type" : "FACT_MEASURE", "stand_row_id" : null, "stand_row_name" : null, "quality_infos" : null, "alias" : "", "self_defined_fields" : null }, { "id" : "873264563087376392", "fact_logic_table_id" : "873264563070599168", "ordinal" : 9, "dimension_id" : null, "role" : null, "dimension" : null, "is_primary_key" : false, "is_partition_key" : false, "is_foreign_key" : null, "description" : "", "data_type" : "DECIMAL", "domain_type" : "NUMBER", "data_type_extend" : "(10,2)", "name_en" : "extra", "name_ch" : "加收", "not_null" : false, "attribute_type" : "FACT_MEASURE", "stand_row_id" : null, "stand_row_name" : null, "quality_infos" : null, "alias" : "", "self_defined_fields" : null }, { "id" : "873264563087376393", "fact_logic_table_id" : "873264563070599168", "ordinal" : 10, "dimension_id" : null, "role" : null, "dimension" : null, "is_primary_key" : false, "is_partition_key" : false, "is_foreign_key" : null, "description" : "", "data_type" : "DECIMAL", "domain_type" : "NUMBER", "data_type_extend" : "(10,2)", "name_en" : "mta_tax", "name_ch" : "MTA税", "not_null" : false, "attribute_type" : "FACT_MEASURE", "stand_row_id" : null, "stand_row_name" : null, "quality_infos" : null, "alias" : "", "self_defined_fields" : null }, { "id" : "873264563087376394", "fact_logic_table_id" : "873264563070599168", "ordinal" : 11, "dimension_id" : null, "role" : null, "dimension" : null, "is_primary_key" : false, "is_partition_key" : false, "is_foreign_key" : null, "description" : "", "data_type" : "DECIMAL", "domain_type" : "NUMBER", "data_type_extend" : "(10,2)", "name_en" : "tip_amount", "name_ch" : "手续费", "not_null" : false, "attribute_type" : "FACT_MEASURE", "stand_row_id" : null, "stand_row_name" : null, "quality_infos" : null, "alias" : "", "self_defined_fields" : null }, { "id" : "873264563087376395", "fact_logic_table_id" : "873264563070599168", "ordinal" : 12, "dimension_id" : null, "role" : null, "dimension" : null, "is_primary_key" : false, "is_partition_key" : false, "is_foreign_key" : null, "description" : "", "data_type" : "DECIMAL", "domain_type" : "NUMBER", "data_type_extend" : "(10,2)", "name_en" : "tolls_amount", "name_ch" : "通行费", "not_null" : false, "attribute_type" : "FACT_MEASURE", "stand_row_id" : null, "stand_row_name" : null, "quality_infos" : null, "alias" : "", "self_defined_fields" : null }, { "id" : "873264563087376396", "fact_logic_table_id" : "873264563070599168", "ordinal" : 13, "dimension_id" : null, "role" : null, "dimension" : null, "is_primary_key" : false, "is_partition_key" : false, "is_foreign_key" : null, "description" : "", "data_type" : "DECIMAL", "domain_type" : "NUMBER", "data_type_extend" : "(10,2)", "name_en" : "improvement_surcharge", "name_ch" : "改善附加费", "not_null" : false, "attribute_type" : "FACT_MEASURE", "stand_row_id" : null, "stand_row_name" : null, "quality_infos" : null, "alias" : "", "self_defined_fields" : null }, { "id" : "873264563087376397", "fact_logic_table_id" : "873264563070599168", "ordinal" : 14, "dimension_id" : null, "role" : null, "dimension" : null, "is_primary_key" : false, "is_partition_key" : false, "is_foreign_key" : null, "description" : "", "data_type" : "DECIMAL", "domain_type" : "NUMBER", "data_type_extend" : "(10,2)", "name_en" : "total_amount", "name_ch" : "总车费", "not_null" : false, "attribute_type" : "FACT_MEASURE", "stand_row_id" : null, "stand_row_name" : null, "quality_infos" : null, "alias" : "", "self_defined_fields" : null } ], "physical_table" : "CREATE_SUCCESS", "technical_asset" : "CREATE_SUCCESS", "business_asset" : "CREATE_SUCCESS", "meta_data_link" : "UPDATE_SUCCESS", "data_quality" : "UPDATE_SUCCESS", "summary_status" : "SUMMARY_SUCCESS", "quality_id" : "898163867648204801", "alias" : "", "self_defined_fields" : [ ] } ] } } }
  • 响应参数 状态码: 200 表4 响应Body参数 参数 参数类型 描述 data Object 返回的数据信息 状态码: 400 表5 响应Body参数 参数 参数类型 描述 error_code String 错误码,如DS.000,请求处理成功 error_msg String 错误信息 data Object 返回的数据信息 状态码: 401 表6 响应Body参数 参数 参数类型 描述 error_code String 错误码,如DS.000,请求处理成功 error_msg String 错误信息 data Object 返回的数据信息 状态码: 403 表7 响应Body参数 参数 参数类型 描述 error_code String 错误码,如DS.000,请求处理成功 error_msg String 错误信息 data Object 返回的数据信息
共100000条