Simple Log Service:SQL in completely accurate mode

Console

1. Log on to the Simple Log Service console.

2. In the Projects section, click the one you want.

   

3. On the Log Storage > Logstores tab, click the logstore you want.

   

4. Choose > Completely Accurate.

   Important

   You can configure the query_max_run_time parameter to modify the maximum timeout period.

   In this example, the * | select count(*) as pv query statement is specified. After you add set session query_max_run_time=10s; to the analytic statement, the query statement becomes * | set session query_max_run_time=10s; select count(*) as pv.

   

API

• GetLogs (the query results are not compressed and are directly returned)

  • Parameter: query

    In this example, the * | select count(*) as pv query statement is executed.

    • Enable the completely accurate mode: Add set session allow_incomplete=false; to the analytic statement, indicating that the completely accurate mode is used. The query statement becomes * | set session allow_incomplete=false; select count(*) as pv.

    • Specify the maximum timeout period: Add set session query_max_run_time=10s; to the analytic statement, indicating the maximum timeout period is 10 seconds. The query statement becomes * | set session query_max_run_time=10s; select count(*) as pv.

    • Enable the completely accurate mode and specify the maximum timeout period: The query statement becomes * | set session allow_incomplete=false; set session query_max_run_time=10s;select count(*) as pv.

• GetLogsV2 (the query results are compressed and then returned)

  • Parameter: query

    In this example, the * | select count(*) as pv query statement is executed.

    • Enable the completely accurate mode: Add set session allow_incomplete=false; to the analytic statement, indicating that the completely accurate mode is used. The query statement becomes * | set session allow_incomplete=false; select count(*) as pv.

    • Specify the maximum timeout period: Add set session query_max_run_time=10s; to the analytic statement, indicating the maximum timeout period is 10 seconds. The query statement becomes * | set session query_max_run_time=10s; select count(*) as pv.

    • Enable the completely accurate mode and specify the maximum timeout period: The query statement becomes * | set session allow_incomplete=false; set session query_max_run_time=10s;select count(*) as pv.

SDK

In this example, Simple Log Service SDK for Java is used.

• GetLogs() method

  • Parameter: query

    In this example, the * | select count(*) as pv query statement is executed.

    • Enable the completely accurate mode: Add set session allow_incomplete=false; to the analytic statement, indicating that the completely accurate mode is used. The query statement becomes * | set session allow_incomplete=false; select count(*) as pv.

    • Specify the maximum timeout period: Add set session query_max_run_time=10s; to the analytic statement, indicating the maximum timeout period is 10 seconds. The query statement becomes * | set session query_max_run_time=10s; select count(*) as pv.

    • Enable the completely accurate mode and specify the maximum timeout period: The query statement becomes * | set session allow_incomplete=false; set session query_max_run_time=10s;select count(*) as pv.

  • Parameter: session

    • Enable the completely accurate mode: request.SetSession("allow_incomplete=false");.

    • Specify the maximum timeout period: request.SetSession("query_max_run_time=10s");.

    • Enable the completely accurate mode and specify the maximum timeout period: request.SetSession("allow_incomplete=false;query_max_run_time=10s").

  import com.aliyun.openservices.log.Client;
  import com.aliyun.openservices.log.exception.LogException;
  import com.aliyun.openservices.log.request.GetLogsRequest;
  import com.aliyun.openservices.log.response.GetLogsResponse;
  
  public class CrearteLogStore {
      public static void main(String[] args) throws LogException {
          // Configure environment variables. In this example, the AccessKey ID and AccessKey secret are obtained from environment variables.
          String accessId = System.getenv("ALIBABA_CLOUD_ACCESS_KEY_ID");
          String accessKey = System.getenv("ALIBABA_CLOUD_ACCESS_KEY_SECRET");
          // The Simple Log Service endpoint. In this example, the Simple Log Service endpoint for the China (Hangzhou) region is used. Replace the parameter value with the actual endpoint.
          String host = "https://cn-beijing.log.aliyuncs.com";
          // Create a Simple Log Service client.
          Client client = new Client(host, accessId, accessKey);
          // The project name.
          String projectName = "aliyun-test-project";
          // The logstore name.
          String logstore = "request_log";
          String query = "* | SELECT count(0)";
          int from = (int)(System.currentTimeMillis()/1000) - 60;
          int to = (int)(System.currentTimeMillis()/1000);
          GetLogsRequest request = new GetLogsRequest(projectName, logstore, from, to, "", query);
          request.SetSession("allow_incomplete=false;query_max_run_time=10s");
          GetLogsResponse response = client.GetLogs(request);
          System.out.println(response.getCpuSec());
      }
  }