Simple Log Service:Completely accurate SQL 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. Click > Completely Accurate.

   Important

   You can adjust the timeout by setting the query_max_run_time parameter.

   For example, if your analytic statement is * | select count(*) as pv, you can add set session query_max_run_time=10s; to the statement. The full analytic statement becomes * | set session query_max_run_time=10s; select count(*) as pv .

   

API

• GetLogs (returns uncompressed results) - Queries log data in a Logstore

  • Parameter: query

    For example, the analytic statement is * | select count(*) as pv.

    • Enable completely accurate mode: Prepend set session allow_incomplete=false; to your analytic statement. For example, * | select count(*) as pv becomes * | set session allow_incomplete=false; select count(*) as pv .

    • Set the query analysis timeout: Add set session query_max_run_time=10s; to the analysis statement. This sets the maximum execution time to 10s. The analysis statement is: * | set session allow_incomplete=false; select count(*) as pv .

    • To enable completely accurate mode and set a timeout, prepend the session commands to your analytic statement. For example: * | set session allow_incomplete=false; set session query_max_run_time=10s;select count(*) as pv .

• GetLogsV2 (returns compressed results) - Queries log data in a Logstore

  • Parameter: query

    For example, the analytic statement is * | select count(*) as pv.

    • Enable completely accurate mode: Prepend set session allow_incomplete=false; to your analytic statement. For example, * | select count(*) as pv becomes * | set session allow_incomplete=false; select count(*) as pv .

    • Set the query analysis timeout: Add set session query_max_run_time=10s; to the analysis statement. This sets the maximum execution time to 10s. The analysis statement is: * | set session allow_incomplete=false; select count(*) as pv .

    • To enable completely accurate mode and set a timeout, prepend the session commands to your analytic statement. For example: * | set session allow_incomplete=false; set session query_max_run_time=10s;select count(*) as pv .

SDK

This section uses the Simple Log Service SDK for Java as an example.

• GetLogs() method

  • Parameter: query

    For example, the analytic statement is * | select count(*) as pv.

    • Enable completely accurate mode: Prepend set session allow_incomplete=false; to your analytic statement. For example, * | select count(*) as pv becomes * | set session allow_incomplete=false; select count(*) as pv .

    • Set the query analysis timeout: Add set session query_max_run_time=10s; to the analysis statement. This sets the maximum execution time to 10s. The analysis statement is: * | set session allow_incomplete=false; select count(*) as pv .

    • To enable completely accurate mode and set a timeout, prepend the session commands to your analytic statement. For example: * | set session allow_incomplete=false; set session query_max_run_time=10s;select count(*) as pv .

  • Parameter: session

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

    • Set the query timeout: request.SetSession("query_max_run_time=10s"); .

    • Enable completely accurate mode and set a timeout: 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 {
          // This example obtains the AccessKey ID and AccessKey Secret from environment variables.
          String accessId = System.getenv("ALIBABA_CLOUD_ACCESS_KEY_ID");
          String accessKey = System.getenv("ALIBABA_CLOUD_ACCESS_KEY_SECRET");
          // Set the endpoint for Simple Log Service. This example uses the endpoint for the China (Beijing) region. Replace it with your actual endpoint.
          String host = "https://cn-beijing.log.aliyuncs.com";
          // Create a Simple Log Service client.
          Client client = new Client(host, accessId, accessKey);
          // Specify the Project name.
          String projectName = "aliyun-test-project";
          // Specify 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());
      }
  }