本文导读

功能介绍
调用方法
URI
请求参数
响应参数
请求示例
响应示例
SDK代码示例
状态码
错误码

展开导读

文档首页/ 云日志服务 LTS/ API参考/ API说明/ 日志管理/ 查询结构化日志（日志分析）

查询结构化日志（日志分析）

更新时间：2025-04-27 GMT+08:00

在线调试

CLI示例

查看PDF

功能介绍

通过SQL语句查询指定日志流下的结构化日志内容（日志分析）。

说明：

日志分析查询功能支持的局点信息请参考用户指南-日志可视化里的可视化章节。数据聚合结果不超过100亿条。仅支持分析最近30天内的数据，30天以上的数据不支持SQL分析。

调用方法

请参见如何调用API。

URI

POST /v2/{project_id}/streams/{log_stream_id}/struct-content/query

表1 路径参数
参数	是否必选	参数类型	描述
project_id	是	String	参数解释：项目ID，获取方式请参见：获取项目ID、获取账号ID、日志组ID、日志流ID。约束限制：不涉及。取值范围：不涉及。默认取值：不涉及。
log_stream_id	是	String	参数解释：日志流ID，获取方式请参见：获取项目ID、获取账号ID、日志组ID、日志流ID。约束限制：不涉及。取值范围：不涉及。默认取值：不涉及。

请求参数

表2 请求Header参数
参数	是否必选	参数类型	描述
X-Auth-Token	是	String	参数解释：从IAM服务获取的用户Token，获取方式请参见：获取用户Token。约束限制：不涉及。取值范围：不涉及。默认取值：不涉及。
Content-Type	是	String	参数解释：该字段填为：application/json;charset=UTF-8。约束限制：不涉及。取值范围：不涉及。默认取值：不涉及。

表3 请求Body参数
参数	是否必选	参数类型	描述
query	是	String	参数解释： SQL语句字符串。约束限制：不涉及。取值范围：不涉及。默认取值：不涉及。
format	是	String	参数解释：查询结果格式。约束限制：不涉及。取值范围：不涉及。默认取值：只取k-v，默认值k-v。
time_range	是	TimeRange object	参数解释：时间范围信息。约束限制：结束时间大于起始时间；时间区间不得超过30天；当时间区间超过对应日志流的保存时间时，默认查询时间区间与日志保存时间区间的交集。取值范围：不涉及。默认取值：不涉及。
whether_to_rows	否	Boolean	参数解释：返回数据格式，是否为行数据，约束限制：不涉及。取值范围：不涉及。默认取值： false。

表4 TimeRange
参数	是否必选	参数类型	描述
sql_time_zone	否	String	参数解释：时区信息。约束限制：不涉及。取值范围：有以下几种格式：-0800、 -08:00、America/Los_Angeles和UTC。默认取值： UTC。
start_time	是	Long	参数解释：搜索起始时间（UTC时间，毫秒级）。约束限制：不涉及。取值范围：大于0；当小于日志流保存时间的最小值时，会默认修改为日志流保存时间区间的最小值。默认取值：不涉及。
end_time	是	Long	参数解释：搜索结束时间（UTC时间，毫秒级）。约束限制：不涉及。取值范围：大于0。默认取值：不涉及。
start_time_gt	否	Boolean	参数解释：搜索是否包含起始时间点。约束限制：不涉及。取值范围：不涉及。默认取值： false。
end_time_lt	否	Boolean	参数解释：搜索是否包含结束时间点。约束限制：不涉及。取值范围：不涉及。默认取值： false。

响应参数

状态码：200

请求响应成功。

状态码：400

表5 响应Body参数
参数	参数类型	描述
error_code	String	参数解释：错误码。取值范围：不涉及。
error_msg	String	参数解释：调用失败响应信息描述。取值范围：不涉及。

状态码：500

表6 响应Body参数
参数	参数类型	描述
error_code	String	参数解释：错误码。取值范围：不涉及。
error_msg	String	参数解释：调用失败响应信息描述。取值范围：不涉及。

请求示例

当“query”参数填写为 select *。

POST https://{endpoint}/v2/{project_id}/streams/{log_stream_id}/struct-content/query

{
  "query" : "select *",
  "format" : "k-v",
  "time_range" : {
    "sql_time_zone" : "UTC",
    "start_time" : 1613806109000,
    "end_time" : 1613806110000,
    "start_time_gt" : false,
    "end_time_lt" : false
  }
}

当“query”参数填写为select count(test3) as mycount, sum(test4) as mysum。

POST https://{endpoint}/v2/{project_id}/streams/{log_stream_id}/struct-content/query

{
  "query" : "select count(test3) as mycount, sum(test4) as mysum",
  "format" : "k-v",
  "time_range" : {
    "sql_time_zone" : "UTC",
    "start_time" : 1613806109000,
    "end_time" : 1613806110000,
    "start_time_gt" : false,
    "end_time_lt" : false
  }
}

当“query”参数填写为 select count(test3), sum(test4) group by(test1)。

POST https://{endpoint}/v2/{project_id}/streams/{log_stream_id}/struct-content/query

{
  "query" : "select count(test3), sum(test4) group by(test1)",
  "format" : "k-v",
  "time_range" : {
    "sql_time_zone" : "UTC",
    "start_time" : 1613806109000,
    "end_time" : 1613806110000,
    "start_time_gt" : false,
    "end_time_lt" : false
  }
}

当“whether_to_rows”参数填写为 true。

POST https://{endpoint}/v2/{project_id}/streams/{log_stream_id}/struct-content/query

{
  "query" : "select count(test3), sum(test4) group by(test1)",
  "format" : "k-v",
  "time_range" : {
    "sql_time_zone" : "UTC",
    "start_time" : 1613806109000,
    "end_time" : 1613806110000,
    "start_time_gt" : false,
    "end_time_lt" : false
  },
  "whether_to_rows" : true
}

响应示例

状态码：200

请求响应成功。

{
  "pv" : [ 90 ]
}

状态码：400

非法请求。建议根据error_msg直接修改该请求，不要重试该请求。

{
  "error_code" : "LTS.2022",
  "error_msg" : "Column 'aa' not found in any table"
}

状态码：500

表明服务端能被请求访问到，但是服务内部出错。

{
  "error_code" : "LTS.0010",
  "error_msg" : "Internal Server Error"
}

SDK代码示例

SDK代码示例如下。

Java
Python
Go
更多

当“query”参数填写为 select *。

        
         
           
           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.lts.v2.region.LtsRegion;
import com.huaweicloud.sdk.lts.v2.*;
import com.huaweicloud.sdk.lts.v2.model.*;


public class ListStructuredLogsWithTimeRangeSolution {

    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);

        LtsClient client = LtsClient.newBuilder()
                .withCredential(auth)
                .withRegion(LtsRegion.valueOf("<YOUR REGION>"))
                .build();
        ListStructuredLogsWithTimeRangeRequest request = new ListStructuredLogsWithTimeRangeRequest();
        request.withLogStreamId("{log_stream_id}");
        QueryLtsStructLogParamsNew body = new QueryLtsStructLogParamsNew();
        TimeRange timeRangebody = new TimeRange();
        timeRangebody.withSqlTimeZone("UTC")
            .withStartTime(1613806109000L)
            .withEndTime(1613806110000L)
            .withStartTimeGt(false)
            .withEndTimeLt(false);
        body.withTimeRange(timeRangebody);
        body.withFormat("k-v");
        body.withQuery("select *");
        request.withBody(body);
        try {
            ListStructuredLogsWithTimeRangeResponse response = client.listStructuredLogsWithTimeRange(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());
        }
    }
}

          

        
       

当“query”参数填写为select count(test3) as mycount, sum(test4) as mysum。

        
         
           
           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.lts.v2.region.LtsRegion;
import com.huaweicloud.sdk.lts.v2.*;
import com.huaweicloud.sdk.lts.v2.model.*;


public class ListStructuredLogsWithTimeRangeSolution {

    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);

        LtsClient client = LtsClient.newBuilder()
                .withCredential(auth)
                .withRegion(LtsRegion.valueOf("<YOUR REGION>"))
                .build();
        ListStructuredLogsWithTimeRangeRequest request = new ListStructuredLogsWithTimeRangeRequest();
        request.withLogStreamId("{log_stream_id}");
        QueryLtsStructLogParamsNew body = new QueryLtsStructLogParamsNew();
        TimeRange timeRangebody = new TimeRange();
        timeRangebody.withSqlTimeZone("UTC")
            .withStartTime(1613806109000L)
            .withEndTime(1613806110000L)
            .withStartTimeGt(false)
            .withEndTimeLt(false);
        body.withTimeRange(timeRangebody);
        body.withFormat("k-v");
        body.withQuery("select count(test3) as mycount, sum(test4) as mysum");
        request.withBody(body);
        try {
            ListStructuredLogsWithTimeRangeResponse response = client.listStructuredLogsWithTimeRange(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());
        }
    }
}

          

        
       

当“query”参数填写为 select count(test3), sum(test4) group by(test1)。

        
         
           
           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.lts.v2.region.LtsRegion;
import com.huaweicloud.sdk.lts.v2.*;
import com.huaweicloud.sdk.lts.v2.model.*;


public class ListStructuredLogsWithTimeRangeSolution {

    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);

        LtsClient client = LtsClient.newBuilder()
                .withCredential(auth)
                .withRegion(LtsRegion.valueOf("<YOUR REGION>"))
                .build();
        ListStructuredLogsWithTimeRangeRequest request = new ListStructuredLogsWithTimeRangeRequest();
        request.withLogStreamId("{log_stream_id}");
        QueryLtsStructLogParamsNew body = new QueryLtsStructLogParamsNew();
        TimeRange timeRangebody = new TimeRange();
        timeRangebody.withSqlTimeZone("UTC")
            .withStartTime(1613806109000L)
            .withEndTime(1613806110000L)
            .withStartTimeGt(false)
            .withEndTimeLt(false);
        body.withTimeRange(timeRangebody);
        body.withFormat("k-v");
        body.withQuery("select count(test3), sum(test4) group by(test1)");
        request.withBody(body);
        try {
            ListStructuredLogsWithTimeRangeResponse response = client.listStructuredLogsWithTimeRange(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());
        }
    }
}

          

        
       

当“whether_to_rows”参数填写为 true。

        
         
           
           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.lts.v2.region.LtsRegion;
import com.huaweicloud.sdk.lts.v2.*;
import com.huaweicloud.sdk.lts.v2.model.*;


public class ListStructuredLogsWithTimeRangeSolution {

    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);

        LtsClient client = LtsClient.newBuilder()
                .withCredential(auth)
                .withRegion(LtsRegion.valueOf("<YOUR REGION>"))
                .build();
        ListStructuredLogsWithTimeRangeRequest request = new ListStructuredLogsWithTimeRangeRequest();
        request.withLogStreamId("{log_stream_id}");
        QueryLtsStructLogParamsNew body = new QueryLtsStructLogParamsNew();
        TimeRange timeRangebody = new TimeRange();
        timeRangebody.withSqlTimeZone("UTC")
            .withStartTime(1613806109000L)
            .withEndTime(1613806110000L)
            .withStartTimeGt(false)
            .withEndTimeLt(false);
        body.withWhetherToRows(true);
        body.withTimeRange(timeRangebody);
        body.withFormat("k-v");
        body.withQuery("select count(test3), sum(test4) group by(test1)");
        request.withBody(body);
        try {
            ListStructuredLogsWithTimeRangeResponse response = client.listStructuredLogsWithTimeRange(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());
        }
    }
}

          

        
       

当“query”参数填写为 select *。

        
         
           
           # coding: utf-8

import os
from huaweicloudsdkcore.auth.credentials import BasicCredentials
from huaweicloudsdklts.v2.region.lts_region import LtsRegion
from huaweicloudsdkcore.exceptions import exceptions
from huaweicloudsdklts.v2 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 = LtsClient.new_builder() \
        .with_credentials(credentials) \
        .with_region(LtsRegion.value_of("<YOUR REGION>")) \
        .build()

    try:
        request = ListStructuredLogsWithTimeRangeRequest()
        request.log_stream_id = "{log_stream_id}"
        timeRangebody = TimeRange(
            sql_time_zone="UTC",
            start_time=1613806109000,
            end_time=1613806110000,
            start_time_gt=False,
            end_time_lt=False
        )
        request.body = QueryLtsStructLogParamsNew(
            time_range=timeRangebody,
            format="k-v",
            query="select *"
        )
        response = client.list_structured_logs_with_time_range(request)
        print(response)
    except exceptions.ClientRequestException as e:
        print(e.status_code)
        print(e.request_id)
        print(e.error_code)
        print(e.error_msg)

          

        
       

当“query”参数填写为select count(test3) as mycount, sum(test4) as mysum。

        
         
           
           # coding: utf-8

import os
from huaweicloudsdkcore.auth.credentials import BasicCredentials
from huaweicloudsdklts.v2.region.lts_region import LtsRegion
from huaweicloudsdkcore.exceptions import exceptions
from huaweicloudsdklts.v2 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 = LtsClient.new_builder() \
        .with_credentials(credentials) \
        .with_region(LtsRegion.value_of("<YOUR REGION>")) \
        .build()

    try:
        request = ListStructuredLogsWithTimeRangeRequest()
        request.log_stream_id = "{log_stream_id}"
        timeRangebody = TimeRange(
            sql_time_zone="UTC",
            start_time=1613806109000,
            end_time=1613806110000,
            start_time_gt=False,
            end_time_lt=False
        )
        request.body = QueryLtsStructLogParamsNew(
            time_range=timeRangebody,
            format="k-v",
            query="select count(test3) as mycount, sum(test4) as mysum"
        )
        response = client.list_structured_logs_with_time_range(request)
        print(response)
    except exceptions.ClientRequestException as e:
        print(e.status_code)
        print(e.request_id)
        print(e.error_code)
        print(e.error_msg)

          

        
       

当“query”参数填写为 select count(test3), sum(test4) group by(test1)。

        
         
           
           # coding: utf-8

import os
from huaweicloudsdkcore.auth.credentials import BasicCredentials
from huaweicloudsdklts.v2.region.lts_region import LtsRegion
from huaweicloudsdkcore.exceptions import exceptions
from huaweicloudsdklts.v2 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 = LtsClient.new_builder() \
        .with_credentials(credentials) \
        .with_region(LtsRegion.value_of("<YOUR REGION>")) \
        .build()

    try:
        request = ListStructuredLogsWithTimeRangeRequest()
        request.log_stream_id = "{log_stream_id}"
        timeRangebody = TimeRange(
            sql_time_zone="UTC",
            start_time=1613806109000,
            end_time=1613806110000,
            start_time_gt=False,
            end_time_lt=False
        )
        request.body = QueryLtsStructLogParamsNew(
            time_range=timeRangebody,
            format="k-v",
            query="select count(test3), sum(test4) group by(test1)"
        )
        response = client.list_structured_logs_with_time_range(request)
        print(response)
    except exceptions.ClientRequestException as e:
        print(e.status_code)
        print(e.request_id)
        print(e.error_code)
        print(e.error_msg)

          

        
       

当“whether_to_rows”参数填写为 true。

        
         
           
           # coding: utf-8

import os
from huaweicloudsdkcore.auth.credentials import BasicCredentials
from huaweicloudsdklts.v2.region.lts_region import LtsRegion
from huaweicloudsdkcore.exceptions import exceptions
from huaweicloudsdklts.v2 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 = LtsClient.new_builder() \
        .with_credentials(credentials) \
        .with_region(LtsRegion.value_of("<YOUR REGION>")) \
        .build()

    try:
        request = ListStructuredLogsWithTimeRangeRequest()
        request.log_stream_id = "{log_stream_id}"
        timeRangebody = TimeRange(
            sql_time_zone="UTC",
            start_time=1613806109000,
            end_time=1613806110000,
            start_time_gt=False,
            end_time_lt=False
        )
        request.body = QueryLtsStructLogParamsNew(
            whether_to_rows=True,
            time_range=timeRangebody,
            format="k-v",
            query="select count(test3), sum(test4) group by(test1)"
        )
        response = client.list_structured_logs_with_time_range(request)
        print(response)
    except exceptions.ClientRequestException as e:
        print(e.status_code)
        print(e.request_id)
        print(e.error_code)
        print(e.error_msg)

          

        
       

当“query”参数填写为 select *。

        
         
           
           package main

import (
	"fmt"
	"github.com/huaweicloud/huaweicloud-sdk-go-v3/core/auth/basic"
    lts "github.com/huaweicloud/huaweicloud-sdk-go-v3/services/lts/v2"
	"github.com/huaweicloud/huaweicloud-sdk-go-v3/services/lts/v2/model"
    region "github.com/huaweicloud/huaweicloud-sdk-go-v3/services/lts/v2/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 := lts.NewLtsClient(
        lts.LtsClientBuilder().
            WithRegion(region.ValueOf("<YOUR REGION>")).
            WithCredential(auth).
            Build())

    request := &model.ListStructuredLogsWithTimeRangeRequest{}
	request.LogStreamId = "{log_stream_id}"
	sqlTimeZoneTimeRange:= "UTC"
	startTimeGtTimeRange:= false
	endTimeLtTimeRange:= false
	timeRangebody := &model.TimeRange{
		SqlTimeZone: &sqlTimeZoneTimeRange,
		StartTime: int64(1613806109000),
		EndTime: int64(1613806110000),
		StartTimeGt: &startTimeGtTimeRange,
		EndTimeLt: &endTimeLtTimeRange,
	}
	request.Body = &model.QueryLtsStructLogParamsNew{
		TimeRange: timeRangebody,
		Format: "k-v",
		Query: "select *",
	}
	response, err := client.ListStructuredLogsWithTimeRange(request)
	if err == nil {
        fmt.Printf("%+v\n", response)
    } else {
        fmt.Println(err)
    }
}

          

        
       

当“query”参数填写为select count(test3) as mycount, sum(test4) as mysum。

        
         
           
           package main

import (
	"fmt"
	"github.com/huaweicloud/huaweicloud-sdk-go-v3/core/auth/basic"
    lts "github.com/huaweicloud/huaweicloud-sdk-go-v3/services/lts/v2"
	"github.com/huaweicloud/huaweicloud-sdk-go-v3/services/lts/v2/model"
    region "github.com/huaweicloud/huaweicloud-sdk-go-v3/services/lts/v2/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 := lts.NewLtsClient(
        lts.LtsClientBuilder().
            WithRegion(region.ValueOf("<YOUR REGION>")).
            WithCredential(auth).
            Build())

    request := &model.ListStructuredLogsWithTimeRangeRequest{}
	request.LogStreamId = "{log_stream_id}"
	sqlTimeZoneTimeRange:= "UTC"
	startTimeGtTimeRange:= false
	endTimeLtTimeRange:= false
	timeRangebody := &model.TimeRange{
		SqlTimeZone: &sqlTimeZoneTimeRange,
		StartTime: int64(1613806109000),
		EndTime: int64(1613806110000),
		StartTimeGt: &startTimeGtTimeRange,
		EndTimeLt: &endTimeLtTimeRange,
	}
	request.Body = &model.QueryLtsStructLogParamsNew{
		TimeRange: timeRangebody,
		Format: "k-v",
		Query: "select count(test3) as mycount, sum(test4) as mysum",
	}
	response, err := client.ListStructuredLogsWithTimeRange(request)
	if err == nil {
        fmt.Printf("%+v\n", response)
    } else {
        fmt.Println(err)
    }
}

          

        
       

当“query”参数填写为 select count(test3), sum(test4) group by(test1)。

        
         
           
           package main

import (
	"fmt"
	"github.com/huaweicloud/huaweicloud-sdk-go-v3/core/auth/basic"
    lts "github.com/huaweicloud/huaweicloud-sdk-go-v3/services/lts/v2"
	"github.com/huaweicloud/huaweicloud-sdk-go-v3/services/lts/v2/model"
    region "github.com/huaweicloud/huaweicloud-sdk-go-v3/services/lts/v2/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 := lts.NewLtsClient(
        lts.LtsClientBuilder().
            WithRegion(region.ValueOf("<YOUR REGION>")).
            WithCredential(auth).
            Build())

    request := &model.ListStructuredLogsWithTimeRangeRequest{}
	request.LogStreamId = "{log_stream_id}"
	sqlTimeZoneTimeRange:= "UTC"
	startTimeGtTimeRange:= false
	endTimeLtTimeRange:= false
	timeRangebody := &model.TimeRange{
		SqlTimeZone: &sqlTimeZoneTimeRange,
		StartTime: int64(1613806109000),
		EndTime: int64(1613806110000),
		StartTimeGt: &startTimeGtTimeRange,
		EndTimeLt: &endTimeLtTimeRange,
	}
	request.Body = &model.QueryLtsStructLogParamsNew{
		TimeRange: timeRangebody,
		Format: "k-v",
		Query: "select count(test3), sum(test4) group by(test1)",
	}
	response, err := client.ListStructuredLogsWithTimeRange(request)
	if err == nil {
        fmt.Printf("%+v\n", response)
    } else {
        fmt.Println(err)
    }
}

          

        
       

当“whether_to_rows”参数填写为 true。

        
         
           
           package main

import (
	"fmt"
	"github.com/huaweicloud/huaweicloud-sdk-go-v3/core/auth/basic"
    lts "github.com/huaweicloud/huaweicloud-sdk-go-v3/services/lts/v2"
	"github.com/huaweicloud/huaweicloud-sdk-go-v3/services/lts/v2/model"
    region "github.com/huaweicloud/huaweicloud-sdk-go-v3/services/lts/v2/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 := lts.NewLtsClient(
        lts.LtsClientBuilder().
            WithRegion(region.ValueOf("<YOUR REGION>")).
            WithCredential(auth).
            Build())

    request := &model.ListStructuredLogsWithTimeRangeRequest{}
	request.LogStreamId = "{log_stream_id}"
	sqlTimeZoneTimeRange:= "UTC"
	startTimeGtTimeRange:= false
	endTimeLtTimeRange:= false
	timeRangebody := &model.TimeRange{
		SqlTimeZone: &sqlTimeZoneTimeRange,
		StartTime: int64(1613806109000),
		EndTime: int64(1613806110000),
		StartTimeGt: &startTimeGtTimeRange,
		EndTimeLt: &endTimeLtTimeRange,
	}
	whetherToRowsQueryLtsStructLogParamsNew:= true
	request.Body = &model.QueryLtsStructLogParamsNew{
		WhetherToRows: &whetherToRowsQueryLtsStructLogParamsNew,
		TimeRange: timeRangebody,
		Format: "k-v",
		Query: "select count(test3), sum(test4) group by(test1)",
	}
	response, err := client.ListStructuredLogsWithTimeRange(request)
	if err == nil {
        fmt.Printf("%+v\n", response)
    } else {
        fmt.Println(err)
    }
}

          

        
       

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

当“query”参数填写为 select *。

        
         
           
           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.lts.v2.region.LtsRegion;
import com.huaweicloud.sdk.lts.v2.*;
import com.huaweicloud.sdk.lts.v2.model.*;


public class ListStructuredLogsWithTimeRangeSolution {

    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);

        LtsClient client = LtsClient.newBuilder()
                .withCredential(auth)
                .withRegion(LtsRegion.valueOf("<YOUR REGION>"))
                .build();
        ListStructuredLogsWithTimeRangeRequest request = new ListStructuredLogsWithTimeRangeRequest();
        request.withLogStreamId("{log_stream_id}");
        QueryLtsStructLogParamsNew body = new QueryLtsStructLogParamsNew();
        TimeRange timeRangebody = new TimeRange();
        timeRangebody.withSqlTimeZone("UTC")
            .withStartTime(1613806109000L)
            .withEndTime(1613806110000L)
            .withStartTimeGt(false)
            .withEndTimeLt(false);
        body.withTimeRange(timeRangebody);
        body.withFormat("k-v");
        body.withQuery("select *");
        request.withBody(body);
        try {
            ListStructuredLogsWithTimeRangeResponse response = client.listStructuredLogsWithTimeRange(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());
        }
    }
}

          

        
       

当“query”参数填写为select count(test3) as mycount, sum(test4) as mysum。

        
         
           
           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.lts.v2.region.LtsRegion;
import com.huaweicloud.sdk.lts.v2.*;
import com.huaweicloud.sdk.lts.v2.model.*;


public class ListStructuredLogsWithTimeRangeSolution {

    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);

        LtsClient client = LtsClient.newBuilder()
                .withCredential(auth)
                .withRegion(LtsRegion.valueOf("<YOUR REGION>"))
                .build();
        ListStructuredLogsWithTimeRangeRequest request = new ListStructuredLogsWithTimeRangeRequest();
        request.withLogStreamId("{log_stream_id}");
        QueryLtsStructLogParamsNew body = new QueryLtsStructLogParamsNew();
        TimeRange timeRangebody = new TimeRange();
        timeRangebody.withSqlTimeZone("UTC")
            .withStartTime(1613806109000L)
            .withEndTime(1613806110000L)
            .withStartTimeGt(false)
            .withEndTimeLt(false);
        body.withTimeRange(timeRangebody);
        body.withFormat("k-v");
        body.withQuery("select count(test3) as mycount, sum(test4) as mysum");
        request.withBody(body);
        try {
            ListStructuredLogsWithTimeRangeResponse response = client.listStructuredLogsWithTimeRange(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());
        }
    }
}

          

        
       

当“query”参数填写为 select count(test3), sum(test4) group by(test1)。

        
         
           
           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.lts.v2.region.LtsRegion;
import com.huaweicloud.sdk.lts.v2.*;
import com.huaweicloud.sdk.lts.v2.model.*;


public class ListStructuredLogsWithTimeRangeSolution {

    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);

        LtsClient client = LtsClient.newBuilder()
                .withCredential(auth)
                .withRegion(LtsRegion.valueOf("<YOUR REGION>"))
                .build();
        ListStructuredLogsWithTimeRangeRequest request = new ListStructuredLogsWithTimeRangeRequest();
        request.withLogStreamId("{log_stream_id}");
        QueryLtsStructLogParamsNew body = new QueryLtsStructLogParamsNew();
        TimeRange timeRangebody = new TimeRange();
        timeRangebody.withSqlTimeZone("UTC")
            .withStartTime(1613806109000L)
            .withEndTime(1613806110000L)
            .withStartTimeGt(false)
            .withEndTimeLt(false);
        body.withTimeRange(timeRangebody);
        body.withFormat("k-v");
        body.withQuery("select count(test3), sum(test4) group by(test1)");
        request.withBody(body);
        try {
            ListStructuredLogsWithTimeRangeResponse response = client.listStructuredLogsWithTimeRange(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());
        }
    }
}

          

        
       

当“whether_to_rows”参数填写为 true。

        
         
           
           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.lts.v2.region.LtsRegion;
import com.huaweicloud.sdk.lts.v2.*;
import com.huaweicloud.sdk.lts.v2.model.*;


public class ListStructuredLogsWithTimeRangeSolution {

    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);

        LtsClient client = LtsClient.newBuilder()
                .withCredential(auth)
                .withRegion(LtsRegion.valueOf("<YOUR REGION>"))
                .build();
        ListStructuredLogsWithTimeRangeRequest request = new ListStructuredLogsWithTimeRangeRequest();
        request.withLogStreamId("{log_stream_id}");
        QueryLtsStructLogParamsNew body = new QueryLtsStructLogParamsNew();
        TimeRange timeRangebody = new TimeRange();
        timeRangebody.withSqlTimeZone("UTC")
            .withStartTime(1613806109000L)
            .withEndTime(1613806110000L)
            .withStartTimeGt(false)
            .withEndTimeLt(false);
        body.withWhetherToRows(true);
        body.withTimeRange(timeRangebody);
        body.withFormat("k-v");
        body.withQuery("select count(test3), sum(test4) group by(test1)");
        request.withBody(body);
        try {
            ListStructuredLogsWithTimeRangeResponse response = client.listStructuredLogsWithTimeRange(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());
        }
    }
}

          

        
       

当“query”参数填写为 select *。

        
         
           
           # coding: utf-8

import os
from huaweicloudsdkcore.auth.credentials import BasicCredentials
from huaweicloudsdklts.v2.region.lts_region import LtsRegion
from huaweicloudsdkcore.exceptions import exceptions
from huaweicloudsdklts.v2 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 = LtsClient.new_builder() \
        .with_credentials(credentials) \
        .with_region(LtsRegion.value_of("<YOUR REGION>")) \
        .build()

    try:
        request = ListStructuredLogsWithTimeRangeRequest()
        request.log_stream_id = "{log_stream_id}"
        timeRangebody = TimeRange(
            sql_time_zone="UTC",
            start_time=1613806109000,
            end_time=1613806110000,
            start_time_gt=False,
            end_time_lt=False
        )
        request.body = QueryLtsStructLogParamsNew(
            time_range=timeRangebody,
            format="k-v",
            query="select *"
        )
        response = client.list_structured_logs_with_time_range(request)
        print(response)
    except exceptions.ClientRequestException as e:
        print(e.status_code)
        print(e.request_id)
        print(e.error_code)
        print(e.error_msg)

          

        
       

当“query”参数填写为select count(test3) as mycount, sum(test4) as mysum。

        
         
           
           # coding: utf-8

import os
from huaweicloudsdkcore.auth.credentials import BasicCredentials
from huaweicloudsdklts.v2.region.lts_region import LtsRegion
from huaweicloudsdkcore.exceptions import exceptions
from huaweicloudsdklts.v2 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 = LtsClient.new_builder() \
        .with_credentials(credentials) \
        .with_region(LtsRegion.value_of("<YOUR REGION>")) \
        .build()

    try:
        request = ListStructuredLogsWithTimeRangeRequest()
        request.log_stream_id = "{log_stream_id}"
        timeRangebody = TimeRange(
            sql_time_zone="UTC",
            start_time=1613806109000,
            end_time=1613806110000,
            start_time_gt=False,
            end_time_lt=False
        )
        request.body = QueryLtsStructLogParamsNew(
            time_range=timeRangebody,
            format="k-v",
            query="select count(test3) as mycount, sum(test4) as mysum"
        )
        response = client.list_structured_logs_with_time_range(request)
        print(response)
    except exceptions.ClientRequestException as e:
        print(e.status_code)
        print(e.request_id)
        print(e.error_code)
        print(e.error_msg)

          

        
       

当“query”参数填写为 select count(test3), sum(test4) group by(test1)。

        
         
           
           # coding: utf-8

import os
from huaweicloudsdkcore.auth.credentials import BasicCredentials
from huaweicloudsdklts.v2.region.lts_region import LtsRegion
from huaweicloudsdkcore.exceptions import exceptions
from huaweicloudsdklts.v2 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 = LtsClient.new_builder() \
        .with_credentials(credentials) \
        .with_region(LtsRegion.value_of("<YOUR REGION>")) \
        .build()

    try:
        request = ListStructuredLogsWithTimeRangeRequest()
        request.log_stream_id = "{log_stream_id}"
        timeRangebody = TimeRange(
            sql_time_zone="UTC",
            start_time=1613806109000,
            end_time=1613806110000,
            start_time_gt=False,
            end_time_lt=False
        )
        request.body = QueryLtsStructLogParamsNew(
            time_range=timeRangebody,
            format="k-v",
            query="select count(test3), sum(test4) group by(test1)"
        )
        response = client.list_structured_logs_with_time_range(request)
        print(response)
    except exceptions.ClientRequestException as e:
        print(e.status_code)
        print(e.request_id)
        print(e.error_code)
        print(e.error_msg)

          

        
       

当“whether_to_rows”参数填写为 true。

        
         
           
           # coding: utf-8

import os
from huaweicloudsdkcore.auth.credentials import BasicCredentials
from huaweicloudsdklts.v2.region.lts_region import LtsRegion
from huaweicloudsdkcore.exceptions import exceptions
from huaweicloudsdklts.v2 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 = LtsClient.new_builder() \
        .with_credentials(credentials) \
        .with_region(LtsRegion.value_of("<YOUR REGION>")) \
        .build()

    try:
        request = ListStructuredLogsWithTimeRangeRequest()
        request.log_stream_id = "{log_stream_id}"
        timeRangebody = TimeRange(
            sql_time_zone="UTC",
            start_time=1613806109000,
            end_time=1613806110000,
            start_time_gt=False,
            end_time_lt=False
        )
        request.body = QueryLtsStructLogParamsNew(
            whether_to_rows=True,
            time_range=timeRangebody,
            format="k-v",
            query="select count(test3), sum(test4) group by(test1)"
        )
        response = client.list_structured_logs_with_time_range(request)
        print(response)
    except exceptions.ClientRequestException as e:
        print(e.status_code)
        print(e.request_id)
        print(e.error_code)
        print(e.error_msg)

          

        
       

当“query”参数填写为 select *。

        
         
           
           package main

import (
	"fmt"
	"github.com/huaweicloud/huaweicloud-sdk-go-v3/core/auth/basic"
    lts "github.com/huaweicloud/huaweicloud-sdk-go-v3/services/lts/v2"
	"github.com/huaweicloud/huaweicloud-sdk-go-v3/services/lts/v2/model"
    region "github.com/huaweicloud/huaweicloud-sdk-go-v3/services/lts/v2/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 := lts.NewLtsClient(
        lts.LtsClientBuilder().
            WithRegion(region.ValueOf("<YOUR REGION>")).
            WithCredential(auth).
            Build())

    request := &model.ListStructuredLogsWithTimeRangeRequest{}
	request.LogStreamId = "{log_stream_id}"
	sqlTimeZoneTimeRange:= "UTC"
	startTimeGtTimeRange:= false
	endTimeLtTimeRange:= false
	timeRangebody := &model.TimeRange{
		SqlTimeZone: &sqlTimeZoneTimeRange,
		StartTime: int64(1613806109000),
		EndTime: int64(1613806110000),
		StartTimeGt: &startTimeGtTimeRange,
		EndTimeLt: &endTimeLtTimeRange,
	}
	request.Body = &model.QueryLtsStructLogParamsNew{
		TimeRange: timeRangebody,
		Format: "k-v",
		Query: "select *",
	}
	response, err := client.ListStructuredLogsWithTimeRange(request)
	if err == nil {
        fmt.Printf("%+v\n", response)
    } else {
        fmt.Println(err)
    }
}

          

        
       

当“query”参数填写为select count(test3) as mycount, sum(test4) as mysum。

        
         
           
           package main

import (
	"fmt"
	"github.com/huaweicloud/huaweicloud-sdk-go-v3/core/auth/basic"
    lts "github.com/huaweicloud/huaweicloud-sdk-go-v3/services/lts/v2"
	"github.com/huaweicloud/huaweicloud-sdk-go-v3/services/lts/v2/model"
    region "github.com/huaweicloud/huaweicloud-sdk-go-v3/services/lts/v2/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 := lts.NewLtsClient(
        lts.LtsClientBuilder().
            WithRegion(region.ValueOf("<YOUR REGION>")).
            WithCredential(auth).
            Build())

    request := &model.ListStructuredLogsWithTimeRangeRequest{}
	request.LogStreamId = "{log_stream_id}"
	sqlTimeZoneTimeRange:= "UTC"
	startTimeGtTimeRange:= false
	endTimeLtTimeRange:= false
	timeRangebody := &model.TimeRange{
		SqlTimeZone: &sqlTimeZoneTimeRange,
		StartTime: int64(1613806109000),
		EndTime: int64(1613806110000),
		StartTimeGt: &startTimeGtTimeRange,
		EndTimeLt: &endTimeLtTimeRange,
	}
	request.Body = &model.QueryLtsStructLogParamsNew{
		TimeRange: timeRangebody,
		Format: "k-v",
		Query: "select count(test3) as mycount, sum(test4) as mysum",
	}
	response, err := client.ListStructuredLogsWithTimeRange(request)
	if err == nil {
        fmt.Printf("%+v\n", response)
    } else {
        fmt.Println(err)
    }
}

          

        
       

当“query”参数填写为 select count(test3), sum(test4) group by(test1)。

        
         
           
           package main

import (
	"fmt"
	"github.com/huaweicloud/huaweicloud-sdk-go-v3/core/auth/basic"
    lts "github.com/huaweicloud/huaweicloud-sdk-go-v3/services/lts/v2"
	"github.com/huaweicloud/huaweicloud-sdk-go-v3/services/lts/v2/model"
    region "github.com/huaweicloud/huaweicloud-sdk-go-v3/services/lts/v2/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 := lts.NewLtsClient(
        lts.LtsClientBuilder().
            WithRegion(region.ValueOf("<YOUR REGION>")).
            WithCredential(auth).
            Build())

    request := &model.ListStructuredLogsWithTimeRangeRequest{}
	request.LogStreamId = "{log_stream_id}"
	sqlTimeZoneTimeRange:= "UTC"
	startTimeGtTimeRange:= false
	endTimeLtTimeRange:= false
	timeRangebody := &model.TimeRange{
		SqlTimeZone: &sqlTimeZoneTimeRange,
		StartTime: int64(1613806109000),
		EndTime: int64(1613806110000),
		StartTimeGt: &startTimeGtTimeRange,
		EndTimeLt: &endTimeLtTimeRange,
	}
	request.Body = &model.QueryLtsStructLogParamsNew{
		TimeRange: timeRangebody,
		Format: "k-v",
		Query: "select count(test3), sum(test4) group by(test1)",
	}
	response, err := client.ListStructuredLogsWithTimeRange(request)
	if err == nil {
        fmt.Printf("%+v\n", response)
    } else {
        fmt.Println(err)
    }
}

          

        
       

当“whether_to_rows”参数填写为 true。

        
         
           
           package main

import (
	"fmt"
	"github.com/huaweicloud/huaweicloud-sdk-go-v3/core/auth/basic"
    lts "github.com/huaweicloud/huaweicloud-sdk-go-v3/services/lts/v2"
	"github.com/huaweicloud/huaweicloud-sdk-go-v3/services/lts/v2/model"
    region "github.com/huaweicloud/huaweicloud-sdk-go-v3/services/lts/v2/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 := lts.NewLtsClient(
        lts.LtsClientBuilder().
            WithRegion(region.ValueOf("<YOUR REGION>")).
            WithCredential(auth).
            Build())

    request := &model.ListStructuredLogsWithTimeRangeRequest{}
	request.LogStreamId = "{log_stream_id}"
	sqlTimeZoneTimeRange:= "UTC"
	startTimeGtTimeRange:= false
	endTimeLtTimeRange:= false
	timeRangebody := &model.TimeRange{
		SqlTimeZone: &sqlTimeZoneTimeRange,
		StartTime: int64(1613806109000),
		EndTime: int64(1613806110000),
		StartTimeGt: &startTimeGtTimeRange,
		EndTimeLt: &endTimeLtTimeRange,
	}
	whetherToRowsQueryLtsStructLogParamsNew:= true
	request.Body = &model.QueryLtsStructLogParamsNew{
		WhetherToRows: &whetherToRowsQueryLtsStructLogParamsNew,
		TimeRange: timeRangebody,
		Format: "k-v",
		Query: "select count(test3), sum(test4) group by(test1)",
	}
	response, err := client.ListStructuredLogsWithTimeRange(request)
	if err == nil {
        fmt.Printf("%+v\n", response)
    } else {
        fmt.Println(err)
    }
}

          

        
       

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

状态码


状态码	描述
200	请求响应成功。
400	非法请求。建议根据error_msg直接修改该请求，不要重试该请求。
500	表明服务端能被请求访问到，但是服务内部出错。

错误码

请参见错误码。

父主题：日志管理

上一篇：查询结构化日志（即将下线不推荐使用）

下一篇：查询日志直方图

意见反馈

文档内容是否对您有帮助？

有帮助没帮助

提供反馈

提交成功！非常感谢您的反馈，我们会继续努力做到更好！您可在我的云声建议查看反馈及问题处理状态。

系统繁忙，请稍后重试

在使用文档中是否遇到以下问题

内容与产品页面不一致

内容不易理解

缺失示例代码

步骤不可操作

搜不到想要的内容

缺少最佳实践

意见反馈（选填）

0/500

请至少选择一项反馈信息并填写问题反馈

字符长度不能超过500

直接提交取消

如您有其它疑问，您也可以通过华为云社区问答频道来与我们联系探讨

智能客服提问云社区提问

查询结构化日志（日志分析）

功能介绍

调用方法

URI

请求参数

响应参数

请求示例

响应示例

SDK代码示例

状态码

错误码

相关文档

意见反馈

文档内容是否对您有帮助？

文档反馈