更新时间:2024-11-12 GMT+08:00
分享

查询联邦分析作业列表

功能介绍

查询联邦分析作业列表

调用方法

请参见如何调用API

URI

GET /v1/{project_id}/leagues/{league_id}/sql-jobs

表1 路径参数

参数

是否必选

参数类型

描述

project_id

String

项目id,最大32位,字母和数字组成

league_id

String

空间id,最大32位,字母和数字组成

表2 Query参数

参数

是否必选

参数类型

描述

limit

Integer

每页记录数,取值0-100

offset

Integer

记录数偏移量

请求参数

表3 请求Header参数

参数

是否必选

参数类型

描述

X-Auth-Token

String

用户凭证

Content-Type

String

消息体的类型(格式)

响应参数

状态码: 200

表4 响应Body参数

参数

参数类型

描述

lists

Array of TicsSqlJobVo objects

实例集合

total

Long

总记录数

表5 TicsSqlJobVo

参数

参数类型

描述

approval_status

String

作业审批状态。APPROVED审批通过,APPROVING审批中,NEW新建,REJECTED驳回,REVOKED撤销

create_time

String

创建时间

creator_id

String

创建人id

creator_name

String

创建人名称

deleted

Boolean

删除标记

description

String

作业描述

domain_id

String

作业发起方domainId

id

String

作业id

job_type

String

作业类型。SQL联合SQL分析,HFL横向联邦学习,VFL纵向联邦学习,PREDICT预测,DATA_EXCHANGE数据交换

league_id

String

空间id

name

String

作业名称

update_time

String

变更时间

update_user_id

String

变更人id

update_user_name

String

变更人名称

状态码: 401

表6 响应Body参数

参数

参数类型

描述

error_code

String

错误码

error_msg

String

错误信息

状态码: 500

表7 响应Body参数

参数

参数类型

描述

error_code

String

错误码

error_msg

String

错误信息

请求示例

查询联邦分析作业列表

get /v1/{project_id}/leagues/{league_id}/sql-jobs?offset=0&limit=10

响应示例

状态码: 200

查询联邦分析作业列表成功

{
  "total" : 2,
  "lists" : [ {
    "id" : "81b5641f6f14452aa251c5389433d0d9",
    "name" : "内存不足作业",
    "description" : "",
    "deleted" : false,
    "job_type" : "SQL",
    "domain_id" : "098593b06a80d2a30f5fc004c28f6da0",
    "league_id" : "ef73b252a0ad4b5db21a12c40a413b2f",
    "creator_id" : "09c680046180d4f91f41c0043e77e0e8",
    "creator_name" : "zhangyafei",
    "create_time" : "2022-10-10T08:05:41.000+00:00",
    "update_user_id" : "09c680046180d4f91f41c0043e77e0e8",
    "update_user_name" : "zhangyafei",
    "update_time" : "2022-10-13T06:35:20.000+00:00",
    "approval_status" : "NEW"
  }, {
    "id" : "ccb1d77a6ca140248d74fce2ceb3679d",
    "name" : "sql1",
    "description" : "",
    "deleted" : false,
    "job_type" : "SQL",
    "domain_id" : "098593b06a80d2a30f5fc004c28f6da0",
    "league_id" : "ef73b252a0ad4b5db21a12c40a413b2f",
    "creator_id" : "09c680046180d4f91f41c0043e77e0e8",
    "creator_name" : "zhangyafei",
    "create_time" : "2022-10-08T09:37:25.000+00:00",
    "update_user_id" : "09c680046180d4f91f41c0043e77e0e8",
    "update_user_name" : "zhangyafei",
    "update_time" : "2022-10-09T08:02:39.000+00:00",
    "approval_status" : "NEW"
  } ]
}

SDK代码示例

SDK代码示例如下。

 1
 2
 3
 4
 5
 6
 7
 8
 9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
package com.huaweicloud.sdk.test;

import com.huaweicloud.sdk.core.auth.ICredential;
import com.huaweicloud.sdk.core.auth.BasicCredentials;
import com.huaweicloud.sdk.core.exception.ConnectionException;
import com.huaweicloud.sdk.core.exception.RequestTimeoutException;
import com.huaweicloud.sdk.core.exception.ServiceResponseException;
import com.huaweicloud.sdk.tics.v1.region.TicsRegion;
import com.huaweicloud.sdk.tics.v1.*;
import com.huaweicloud.sdk.tics.v1.model.*;


public class ListSqlJobSolution {

    public static void main(String[] args) {
        // The AK and SK used for authentication are hard-coded or stored in plaintext, which has great security risks. It is recommended that the AK and SK be stored in ciphertext in configuration files or environment variables and decrypted during use to ensure security.
        // In this example, AK and SK are stored in environment variables for authentication. Before running this example, set environment variables CLOUD_SDK_AK and CLOUD_SDK_SK in the local environment
        String ak = System.getenv("CLOUD_SDK_AK");
        String sk = System.getenv("CLOUD_SDK_SK");
        String projectId = "{project_id}";

        ICredential auth = new BasicCredentials()
                .withProjectId(projectId)
                .withAk(ak)
                .withSk(sk);

        TicsClient client = TicsClient.newBuilder()
                .withCredential(auth)
                .withRegion(TicsRegion.valueOf("<YOUR REGION>"))
                .build();
        ListSqlJobRequest request = new ListSqlJobRequest();
        request.withLeagueId("{league_id}");
        try {
            ListSqlJobResponse response = client.listSqlJob(request);
            System.out.println(response.toString());
        } catch (ConnectionException e) {
            e.printStackTrace();
        } catch (RequestTimeoutException e) {
            e.printStackTrace();
        } catch (ServiceResponseException e) {
            e.printStackTrace();
            System.out.println(e.getHttpStatusCode());
            System.out.println(e.getRequestId());
            System.out.println(e.getErrorCode());
            System.out.println(e.getErrorMsg());
        }
    }
}
 1
 2
 3
 4
 5
 6
 7
 8
 9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
# coding: utf-8

import os
from huaweicloudsdkcore.auth.credentials import BasicCredentials
from huaweicloudsdktics.v1.region.tics_region import TicsRegion
from huaweicloudsdkcore.exceptions import exceptions
from huaweicloudsdktics.v1 import *

if __name__ == "__main__":
    # The AK and SK used for authentication are hard-coded or stored in plaintext, which has great security risks. It is recommended that the AK and SK be stored in ciphertext in configuration files or environment variables and decrypted during use to ensure security.
    # In this example, AK and SK are stored in environment variables for authentication. Before running this example, set environment variables CLOUD_SDK_AK and CLOUD_SDK_SK in the local environment
    ak = os.environ["CLOUD_SDK_AK"]
    sk = os.environ["CLOUD_SDK_SK"]
    projectId = "{project_id}"

    credentials = BasicCredentials(ak, sk, projectId)

    client = TicsClient.new_builder() \
        .with_credentials(credentials) \
        .with_region(TicsRegion.value_of("<YOUR REGION>")) \
        .build()

    try:
        request = ListSqlJobRequest()
        request.league_id = "{league_id}"
        response = client.list_sql_job(request)
        print(response)
    except exceptions.ClientRequestException as e:
        print(e.status_code)
        print(e.request_id)
        print(e.error_code)
        print(e.error_msg)
 1
 2
 3
 4
 5
 6
 7
 8
 9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
package main

import (
	"fmt"
	"github.com/huaweicloud/huaweicloud-sdk-go-v3/core/auth/basic"
    tics "github.com/huaweicloud/huaweicloud-sdk-go-v3/services/tics/v1"
	"github.com/huaweicloud/huaweicloud-sdk-go-v3/services/tics/v1/model"
    region "github.com/huaweicloud/huaweicloud-sdk-go-v3/services/tics/v1/region"
)

func main() {
    // The AK and SK used for authentication are hard-coded or stored in plaintext, which has great security risks. It is recommended that the AK and SK be stored in ciphertext in configuration files or environment variables and decrypted during use to ensure security.
    // In this example, AK and SK are stored in environment variables for authentication. Before running this example, set environment variables CLOUD_SDK_AK and CLOUD_SDK_SK in the local environment
    ak := os.Getenv("CLOUD_SDK_AK")
    sk := os.Getenv("CLOUD_SDK_SK")
    projectId := "{project_id}"

    auth := basic.NewCredentialsBuilder().
        WithAk(ak).
        WithSk(sk).
        WithProjectId(projectId).
        Build()

    client := tics.NewTicsClient(
        tics.TicsClientBuilder().
            WithRegion(region.ValueOf("<YOUR REGION>")).
            WithCredential(auth).
            Build())

    request := &model.ListSqlJobRequest{}
	request.LeagueId = "{league_id}"
	response, err := client.ListSqlJob(request)
	if err == nil {
        fmt.Printf("%+v\n", response)
    } else {
        fmt.Println(err)
    }
}

更多编程语言的SDK代码示例,请参见API Explorer的代码示例页签,可生成自动对应的SDK代码示例。

状态码

状态码

描述

200

查询联邦分析作业列表成功

401

操作无权限

500

内部服务器错误

相关文档